Your SQL Server is Bored: What Low Wait Times Mean
In which you ask your assistant to fetch your coffee, and time them.
2018-10-19
3,120 reads
wait statistics
Knee-Jerk Wait Statistics : PAGELATCH
Paul Randal adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.
2015-11-05
5,574 reads
Knee-Jerk Wait Statistics : CXPACKET
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
2015-07-13
3,180 reads
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
2014-04-18
5,338 reads
Capturing Baselines on SQL Server: Wait Statistics
By capturing baseline data, a well-prepared DBA should get a good idea of what potential issues they will face. In this article Erin Stellato looks at Wait Statistics and what they can tell you about your databases.
2020-06-30 (first published: 2013-02-04)
18,339 reads
RE: Wat are the disadvantages of SELECT ... WITH (NOLOCK)?
Ron,I knew there wouldn't be an easy solution. I just wanted to know how other developers/DBA's think about the Quick and Dirty solution WITH (NOLOCK). If anything, this thread confirms that I know not enough of Locking. Yet comprehension dawns (I hope.... )GS
2005-04-29
RE: Table History
No, if you need that kind of information, you would need to set up an audit table and populate it with a trigger.Steve
2004-08-23
RE: Question of the Day for 27 Jul 2004
Add the 'order by' column to the end of each select (i.e., display the field myiT.Unique_ID) and see what happens.It appears that because the second query is using an alias which bears the same name as a field in one of the tables, it is ignoring the prefix in the order by and using the […]
2004-07-27
Books/On-line resources For Newbies
What would be good on-line resource/books for someone new to SQL Server?
2004-06-01
1 reads
RE: CASE Statement in Check constraint?
Try thisALTER TABLE roysched ADD CONSTRAINT CK_title_id CHECK (CASE royalty WHEN 10 THEN 'BU2075' ELSE title_id END = title_id )
2004-03-29
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers