Re-size TempDB files
Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.
2009-04-03
13,847 reads
- Interests: Nature travel, good design and great beer.
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-09 (first published: 2008-12-31)
2,013 reads
Blogs
Error: 8623 - The query processor ran out of internal resources and could not produce a query plan
Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...
Goal Progress– October 2020
By Steve Jones
This is my report, which continues on from the Aug report. After that report,...
Daily Coping 30 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
DQS LogOnWindowFailedToConnect
HI every one I'm running into problems in DQS I'll appreciate your advice, I...
sys.dm_db_index_physical_stats returning wrong object_ID in MSDB database
I'm running an index maintenance script on the MSDB database that loops through a...
Do I need a trigger?
I want to test a condition during an insert or an update and only...
Ask SSC