SET STATISTICS TIME ON;

EXEC YourProcedureNameGoesHere;

Then check the 'Messages' output window.

You may need to force a recompile of your proc before running it in order to see the compilation time (no...

S_Kumar_S (4/10/2013)

---

So some questions are here:

1.What's wrong with existing structure?

2.Table is partitioned on WeekOfJoining, which has nonclustered index.( the index itself is not partitioned). Is it better to partition...

If you specified WITH RECOMPILE in the CREATE PROC/ALTER PROC statement, the plan won't be cached.

Any 823 or 824 errors in the SQL Server error log?

You can use a feature called 'Composable DML' that allows the output of a DML statement (such as MERGE) to feed another one - basically using an OUTPUT clause in...

That message is 2 1/2 years old. Were you taking SAN snapshots then? Is this happening currently?

Because DepartmentID is the second column in the index (unique indexes are created automatically to enforce unique constraints), the only option available to the query processer is to scan the...

I'd go with a disk problem, and ignore the NOLOCK part of the error message. That specific error can be thrown if there is a corrupt page encountered while running...

RESTORE DATABASE TestDB

FROM DISK = 'D:\Backup\backup.bak'

WITH NORECOVERY,

MOVE 'DateFile' TO 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TestDB.mdf',

MOVE 'LogFile_Log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TestDB.ldf';

GO

In the...

SELECT Root_Cause_Analysis.value('(/RCA/PREVENTION/text())[1]', 'varchar(64)')

FROM T1.Submission;

A while back, I posted a breakdown of SAN snapshot options with SQL Server in response to a different question:

http://www.sqlservercentral.com/Forums/Topic795819-357-2.aspx#bm797256

-Eddie

Never researched External Activation, but we do have a number of queues with activated CLR procs whose purpose is to communicate with systems (such as Redis) outside of the SQL...

When multiple files exist in a filegroup, space is allocated from each file proportionally by the amount of free space in each file. Your new second file is only 1MB....

Full details at http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

The guy who said 'rip out a processor' was on the right path. If the Windows OS can see a processor core, even if you use SQL...

If you're making your own version of the proc with custom mods, try marking it as a system procedure:

EXEC sp_ms_marksystemobject 'your proc name'

-Eddie