How to Connect to a SQL 2005 Server When You Are Completely Locked Out

http://www.sqlservercentral.com/Forums/Topic812701-471-1.aspx

It is really a business decision on the part of Microsoft not to spend the resources to add a feature that will only rarely be needed.

If there is really a...

It is likely that the select queries are timing out because of blocks by the deletes. You should consider setting the database to read committted snapshot to prevent deletes...

san43 (1/11/2010)

---

I have scheduled a full backup after the rebuild index job, so that I don't get a huge transaction log backup. But a transaction log after the full backup...

Just convert the DATETIME value to datatype DATE.

select

MyDate = convert(date,MyDateTime),

MyDateTime

from

( -- Test Data

Select MyDateTime = getdate()union all

select dateadd(hh,-11,getdate())union all

select dateadd(hh, 11,getdate())union all

select dateadd(hh, 12,getdate())

) a

Results:

MyDate MyDateTime

----------...

select

HoursWorked =

right('0000000000'+convert(varchar(10),convert(int,a.HoursWorked*100)),6)

from

( -- Test Data

select HoursWorked = 2080.00 union all

select HoursWorked = 780.50

) a

Results:

HoursWorked

-----------

208000

078050

Script to analyze table space usage:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

I often schedule a job to run sp_updatestats on each non-system database on a daily basis.

This procedure was greatly improved with SQL 2005 to only do updates when they are...

I test all drives with 8KB, 16KB, 32KB, 64KB, 128KB and 256KB block sizes for sequential read, sequential write, random read, and random write for a total of 24 tests...

maria_gallagher (11/29/2009)

---

Hi Michael,

The script worked great. It's very detailed!

Is there a way to stop rounding of the File_size_used and file_size_unused values? Currently it may display 7606, while in Taskpad view...

This script gets the file information for every database on a server, inserts it into temp table, and queries it multiple ways to give various levels of analysis of file...

If the table you are selecting into will later have a clustered index created on it, it is usually faster to create the table first and insert the data in...

You can also delete the history with a maintenance plan.

There is a pre-defined task just for that, the History Cleanup Task.

50 MB may be a little small. I usually use at least 100 MB, but for a database that I expect to grow fairly often, 500 MB or more...

Piotr.Rodak (11/10/2009)

...There is no point in filtering out rows that did not change from the update statement in my opinion, as updating all rows will not change rows that are...