SQL Server database programming

I want to find out which Employees have a contract and whether they've worked and if so, the last work day the tables concerned are : tblEmployee : table holding all records of Employees tblContracts : table holding all contract of Employees (not every employee ...

I'm trying to improve the performance of my queries by measuring the process time. Since SQL Server also improves the performance by the query cache, I am not always shure whether the performance is due to the recoding or the ...

For a long time, I have wanted to use SQL Server to perform some calculations which are based on running values (which imply an order).  Of course, using SQL Server for this is not a good idea, since all operations ...

I want to have a SQL query can return the max value for a given time range. Let me give an example which can clear up what I mean: Over all the data we have, what is the value for the largest two hour ...

I know there is not a single answer to this, but...  How many indexes are too many on a busy table? In a book, I read not more than THREE if the table is busy!  How do you ...

Hi, I am trying to write a query that will add sequentially. For example, Month    Week    Amount    Amount2 1    1    200    200 ...

Hi, I'm working on converting *= and =* to 'left outer join' and 'right outer join'. I noticed the difference in behavior between the =* and the phrase "right outer join" and between *=  and 'left outer join'. The result set is ...

I am grouping total orders per month. Currently, as an example, I am able to get the following results. January     25 March       15 May          10 ...

Is anybody here from MS SQL Server Development Team? I got couple ideas how to improve MS SQL Server Enterprise Manager, but I guess the community needs to discuss it first and maybe this NG is not the very worst place to start ...