Monthly Archive: July 2009
The DMVs are a great way to get a closer look at what is actually going on in your system. In particular, for some operations, SQL Server populates the percent_complete and estimated_completion_time (in milliseconds)...
I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive. In SQL Server 2005 and earlier, you could get out...
I'm a day early; sorry. But I have a lot of interesting items to share this week. ======================================== More control over TOP (n) in DML This week I realized that the workarounds for affecting...
Looks like dozens of fixes for SQL Server 2008 have made their way into another cumulative rollup; CU3 for SP1 (build 2723), and CU6 for RTM (build 1812). You can get them here: Cumulative...
In a shared SQL Server hosting environment, there are several problems that can arise when you let your customers use Management Studio to connect and administer their databases. In the typical case, you give...
I missed last week because I was having fun up in Canada… mostly without any kind of computer access at all. It was a nice break, but now I'm back in the thick of...
Last night I spoke at the Charlotte SQL Server User Group, and a bunch of people requested an online version of the talk, so I presented a webcast today at lunch. Hope it was...
Well, there are a couple of post-submission edits that I hope will be corrected in short order, but at long last, the white paper I wrote with Boris Baryshnikov is finally available for download...
Well, let me be more precise: there is an updated version of Books Online online. As reported earlier by Buck Woody, the online version of SQL Server 2008 Books Online has been updated (we...
I know most readers are out polishing their grills, buying hamburger buns and preparing potato and macaroni salads. I am recovering from a pre-4th party, so here I am, groggy and online, finally not...
I see people complain that IntelliSense (new in SQL Server 2008's Management Studio) is not working. Most of the time, it is for one of two reasons: The object is not in the local...