Monthly Archive: July 2009

When will my backup / restore / index reorganize finish?

When will my backup / restore / index reorganize finish?

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)...

Oh, the horror!  Please stop telling people they should shrink their log files!

Oh, the horror! Please stop telling people they should shrink their log files!

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...

Connect digest : 2009-07-24

Connect digest : 2009-07-24

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...

More Cumulative Updates available for SQL Server 2008

More Cumulative Updates available for SQL Server 2008

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...

For shared SQL Server providers : hiding your list of databases from customers

For shared SQL Server providers : hiding your list of databases from customers

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...

Connect Digest : 2009-07-18

Connect Digest : 2009-07-18

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...

Resource Governor slide deck from Charlotte SSUG

Resource Governor slide deck from Charlotte SSUG

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...

Resource Governor whitepaper is now available

Resource Governor whitepaper is now available

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...

SQL Server 2008 Books Online update is available

SQL Server 2008 Books Online update is available

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...

Connect digest : 2009-07-04

Connect digest : 2009-07-04

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...

Why is IntelliSense not working?

Why is IntelliSense not working?

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...