Have you tried; KILL <SPID> WITH STATUSONLY to see if the transaction is 100% rolled back?

If it is then it's been my experience that the hung SPID is waiting to...

Seems MS got the message.

SQL 2008 SP2 due Q3 2010

SQL 2005 SP4 due Q4 2010

http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/12/sql-server-servicing-plans.aspx

Stumbled across this link a while ago, it's a handy little trick.

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8976dd8f-44a8-4fb7-b3ac-05b06f33f9f1/%5B/url%5D

Most of the Windows I get are in the middle of the night and I prefer not to implement large projects on Fridays or over the weekend. If something small...

The auto shrink option has nothing to do with recovery model. If you turn auto shrink off and leave the db in simple recovery mode the tlog will continue to...

SQL needs free space in the data files to rebuild indexes approximately 1.5 times the size of the largest index. So if there is no free space in your data...

I believe you can just open the reports in BIDS 2008 to convert them and then upload them to RS 2008. I didn't go this route because of the 1000's...

The migration is pretty straight forward when moving from SSRS 2005 to SSRS 2008. Just backup the ReportServer and ReportServerTempdb from 2005 and restore them to 2008, then point RS...

Adding a secondary data file will not break mirroring as long as you have the same folder structure on the mirror server.

For example adding datafile2.ndf:

Add datafile2.ndf to C:\Data\ on primary...

Yes, but you will have to install it as a named instance if you installed 2008 as the default instance.

You can add a secondary data file on the same filegroup to the new drive and then restrict the size of your primary data file.

The catch is that it's a small company of only 14 people so everyone knows when you’re not in the office.

A company called Social Strata in Seattle just offered its employees unlimited paid time off. Unfortunately they are not hiring. I checked...

- Question: if you do: dbcc dbreindex(NAME,'',90) to the table, does the indexes gets the statistics updated automatically with 100% statistics?

- Also, how about the non-indexed statistics column...

I am trying to automate an SSIS package which imports data into a sql server table from a text file . Looks like the account ABC\XYZ does not the permissions...