Are you asking how SQL internally calculates UTC based on a given date? Or, are you looking for some examples?

What does this return?

SELECT name ,

size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB

FROM sysfiles;

Deepathy,

The link to "How to post performance problems" is great. In looking at everything you've posted there are two things I don't know, 1) How long the batch...

Try this:

select account_nbr,

(select min(date) from tab1 as b

where b.date >= a.date

and not exists

(select * from tab1 as c

where b.date = c.date - 1)) as date,

...

Are you out of space?

http://www.sqlskills.com/blogs/paul/post/Database-snapshots-when-things-go-wrong.aspx

Use the DBCC CHECKDB......ESTIMATEONLY.

Just a thought.

You could possibly setup a logon trigger and do something based on the login. Maybe you could write an event out to the error log(xp_logevent) and report if that...

I have attached the script. It is extremely basic, but you can build on it very easily. Actually, if you are familiar with Informix, they have a built-in...

Have you tried doing this through Powershell? You can easily access the the SQL Server SMO to script out the objects to a file. I hadn't used powershell...

I wish it stopped there. I like the ones where the application has an hourly job that takes 1.5 hours to run. For some reasons, the developers never...

See if this query gives you what you are looking for. I have found ordering by execution_count useful in the past especially for those queries that might execute hundreds...