Per Books On Line for SQL 2008 (http://msdn.microsoft.com/en-us/library/bb933942(v=SQL.105).aspx),

The tempdb, model, msdb and Resource databases are all set to the new compatibility level (100 for SQL 2008).

The master database however, remains...

Hello!

Thank-you, all for taking the time out and reading my article during the holiday week-end.

I really appreciate your kind support and am proud to be a part of such a...

dbuendiab (12/23/2010)

I apologize for this to all of you who have got disappointed, and by the other side, I hope it can help someone to avoid getting so confused as...

Agree. The SQL 2005 instances that we have are all running...

I would say giving feedback on an write-up is more like doing a peer-review. When we review code, we try to not use words like "you" or "me" or even...

I would still prefer a tape for shipment offsite. The reason? No impact of mechanical forces!

Secondly, tapes have stood the test of time. Optical disks are a good alternate, but...

One thing that immediately comes to mind is the Upgrade Advisor. For ISVs planning for compatibility with an upcoming version of SQL Server, the first thing they should do (I...

Thank-you, Jeff! Great series!

Great question! Thank-you.

Really appreciate the effort put forward to bring tthe uncertainity of using temp tables of the same name but across purposes.

I would have liked the query though (instead...

Very good, basic question. Clearly signifies the importance of scoping things right, which most tend to forget when piling on tons of code.

Thank-you!

The only time we use shrinking is when we are shipping databases around (by shipping, I mean moving databases to teams in different geographic locations, or even within the network)....

The Buffer cache hits are pegged at 100% (all that is required is found from cache).

I agree...

Ah..that's where the problem is. SQL Server Express does not support management of Full-text objects by default. You need the SQL Server Express Advanced Series for using Full-text support.

http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/a217f7d1-5e56-4dd5-832b-d19545ab00d2

Here's where...

What edition of SQL Server are you using? (Standard/Workgroup/Enterprise)?

I completely agree with the study referenced that applying standard accounting rules and ROI calculations may mean the death of innovation. The reason we need innovation is because conventional ideas...