If you start SQL Server with a cold buffer and empty cache, the plan_handles should match, the execution counts should match should match, the logical reads should roughly match, and...

Perhaps an unprintable character - group by len().

Best to start a new thread??. In new thread I suggest scripting out job, obfuscating names via Replace All, posting sanitized script as SQL, and inspecting & stating step 19's...

Seems worth a Premier incident to me. Bugs are free. Ensure with your TAM that no root cause is free (if you are offering to help MS catch a kernel...

A dummy update (updating a field to its current value) is a common 'trick' used in transactional and (IIRC) merge repl.

Any foreign keys in the update's plan?

If a database is "rarely" used, if you want the database's data files and log files to usually be included in the system's regular OS backups (as opposed to SQL...

We do see high latency values over a sustained period of times. But SAN guys are stating they don't find any latency at LUN layer from their end. they are...

I am sure you can find other queries that look for "the" consumer of tempdb space, but the BOL URL is good enough.

Here's one that was generated by PSSDiag...

The best solution is to redesign the table. For the query in question, a ticket number should not be part of a whole column/field. Instead, a ticket number (with...

An attempt to create a SQL linked server from srv_integration to srv_target using the credentials of the current user fails if it is created through SSMS from a workstation, the...

See the URL I offered, step 2.

If it takes 15 seconds to grow tempdb by merely 500 MB, your disks suck :hehe:.

Disk performance needs to be measured by using no greater than a 5 second polling...

SSMS is a client, not SQL Server :). SSMS happens to ship with SQL Server, but it is not built by the SQL Server's developers. It is instead built...

Replay a Trace File (SQL Server Profiler)

3.In the Replay Configuration dialog box, on the Basic Replay Options tab, specify the Replay server. Click Change to change the server displayed in...

Does this SQL Server host linked servers?

If not known, run select * from sys.dm_os_loaded_modules where company <> 'Microsoft Corporation'

a few times throughout the day. Is a non-Microsoft module listed?

Fatal...