Hi,

Very nice script. I've been searching ages for this. I am not so comfortable with cursors, they tend to always crash for me.

However,

Do you really want to reorganize or rebuild...

Another one which states when server is ready to rock 'n roll

USE master;

SELECT login_time FROM sysprocesses

WHERE spid = 1

This return comes later then tempdb creation because in between a...

Fine and neat script, but I have a question.

Did you put this an all 100+ SQL servers?

Honestly guys, no backup and they are to be DBA's?

First thing a DBA should do is to make sure he can restore every database to a point in time depending...

All services used in SQL is using the same service account

We have SQL 2008 R2 (x64) on MS Server 2008 R2 with all the SP including SP2 for SQL Server 10.50.4000.

This is a new server and we started using it...

Do you really consider having all databases set to SIMPLE RECOVERY MODE?

I ask because you stated only 200GB Logfile space for 1000GB of dataspace.

Hope you never get index problems and...

I agree with tim.cloud that you should have a backup drive attached to your database system.

I normally set up the following when creating new SQL server

C: for OS ~ 60GB...

What about MS Server 2008 R2 (std) and SQL Server 2008 R2 (std).

The issue is still there, would the solution work in this environment as well?

Hi,

I have worked some with translation from Unix to PC encoding.

The main problem to BULK INSERT is that it has problems reading Unicode text documents as it does not have...

Thanks anyhow. I'll address Microsoft with this

I am doing this as I am enterring a new user and to check if I spelled the name correctly, i.e. fetching group from AD.

I would like to have that...

There is still an advantage to have local backup or should I say at least three disadvanteges to not to.

1. Network issues

2. Discs on the backup (3rd party)

3. Timehandling as...

This calculation is not accurate regarding Total size.

But it is close, so it depends on how accurate you want to be

This script will find a Head blocking script and in the temporary table all scripts running is shown.

Only tested in SQL 2008

/*

Check for the SPID that has a BlockingSPID set...