Weird that it's deadlocking on a page. Since you have the page address (5:1:1662692), it would be nice to see what the actual deadlocked resource is.

Print the page header with...

Looks like just a path issue. Is the account executing the script able to run sqlcmd from the context of the folder that holds the script file? (log on as...

Think of mirroring as really fast log shipping. The transaction log replay includes the target pages of the modifications. The buffer cache is not part of the transaction log.

So, to...

SELECT physical_memory_in_bytes FROM sys.dm_os_sys_info

This is pretty much what the NTILE() windowed function is for - equally dividing a results set into x number of pieces. Unlike throwing calculations at the min and max...

Using a self-join, you can establish what a daily average rate for each entry is. Once you've gotten that, each entry will have a start and an end date.

From...

First thing that comes to mind is Unicode conversion problems. That data must be stored as nvarchar() or nchar(). If any table application, column, temp table column, or variable touched...

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...