Use the ROUND Function - for help & examples, refer BOL.

If this is a new database that you are designing, I would strongly recommend the use of schemas. With the user-schema isolation coming in from SQL 2005, the task at...

THis should have been a multiple choice question. DBCC_INDEXDEFRAG is also an ONLINE operation - the question is not which operation will remain for online index maintenance long-term; it was...

I guess the concept of team members being "resources" or machine equivalents is where the problem lies. Machines can designed to repeat an activity again and again; while the very...

Hello!

I am confused as well. Here's what I did (on a SQL 2008 box):

1. Ran the query mentioned

2. Restarted the services (both SQL Server Agent & SQL Server)

3. Re-ran the...

Hello!

I work for a product (and have been working with the same product since the last 6 years). What we typically do is exactly what you have mentioned - rotate!

As...

Really good question. Thank-you!

Hello!

For those who are interested in an official documentation on this behaviour, refer BOL at: http://msdn.microsoft.com/en-us/library/ms186272.aspx

Thank-you!

With an identity of (-1,1), -1, -2 and -3 is just not the possible output.

The first record that goes in will have -1. Next would be -1 + 1 =...

Excellent article - never thought that SQL would work differently for SPs and for functions.

However, to get the list of columns, why go into all the trouble (min. 3 steps)...