nice article

I dont think you can restrict somebody from seeing the names of databases. Is there any harm in that?

You can create a development database for the developer on another server...

Skeeve , First What i have understood.

The same database when is restored in SQL 2008 and in MSDE 2000. The same query runs fine in SQL 2008 but not...

I faced a similar problem in the recent past. Mine was most probably due to disk corruption cant say for sure. I tried everything that you have listed and it...

There are 2 things that you can do.

One is to restore the full backup on another server and then import the data to your database from the restored backup.

The...

knew the answer but clicked on the wrong button 🙁

My 2 cents...

Using a smart script will definitely reduce the problem but may not completely solve it. Certain indexes will still be fragmented and require a index rebuild. This...

one more difference

in your dynamic query its Where Address like ''%'' + @Address + ''%'' where as in your procedure it is

WHERE Address like '%' + @Address

Can u give us the details why you need to do this. It may help us to give you better answers.

Edit - How about using views.

Nice question, but i agree with diamondgm. The average calculation need not be the same as you pointed out.

Sorry it was a typo i meant 2005

Sorry but am feeling a bit strong about this

From Bob Hovious signature

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller

SELECT TOP 1 AccountID, NewAccountId from #a

ORDER BY CASE WHEN CAST((RAND() * 10) AS INT)%2 = 0 THEN AccountID ELSE NewAccountId END ASC

Using newid() method is more...

You need to find out when and where the deadlocks are occuring . Run a trace or use DMV's to get dead lock information.

My 2 cents... I could be entirely wrong :ermm:

Reindex organizes the pages but does not release the space on the files back to OS. So your file size...