OK, so your statistics on sales_fact are more than five weeks out of date. Please update all statistics on that table with FULLSCAN, run the query again, and post...

Hmmm.. I saw where he said "the stats were run 3 weeks back", which doesn't sound very up to date to me. I think you're right - a bit...

Also, when was the last time you updated your statistics? There are massive discrepancies on some of those index seeks between estimated and actual number of rows. Please...

Oof! Good spot, Lynn. I wrote that script years ago when it still had to work against SQL Server 2000. I'll update my package at the next...

Some performance counters are further divided in instances, so the % Processor Time counter is divided into one instance for each processor you have, and the Avg. Disk sec/Read counter...

If your query is quite simple, then something like the code below will work.

BEGIN TRY

EXEC('SELECT name FROM sys.databased')

END TRY

BEGIN CATCH

EXEC('SELECT name FROM sys.databases')

END CATCH

If it's a bit more complex, you're...

You certainly don't need a cursor, as others have shown you. However, may I suggest you approach this from a different angle? It's all very well checking you...

You can use DATEPART to get the hours, minutes, seconds and milliseconds components from the date, and build your decimal number from there.

John

OK, now why do you want to convert to decimal? What should the result look like for that date and time?

John

What precise date and time does that represent? Is i6 16:31:00 on 8th July 2014, or is it 08:16:31 on some day in July 2014?

John

You can set up an alert in SQL Server Agent based on the Log File Size and Data File Size counters in the Databases performance object.

John

Have you tried changing the protocol to TCP/IP in the alias?

John

Is it just this one client that can't connect? Is remote access allowed?

EXEC sp_configure 'remote access'

John

Ashok

OK, I'm assuminng you know how to get all your data into a staging table, which we'll call SampleData. I'm not sure I understand the second and third rules,...

Prabhu

It depends. You can only find out by testing. Test it with the index drop and without, for all sizes of data you're likely to encounter.

John