Quick tip: Using sp_server_diagnostics
In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...
2013-04-11 (first published: 2013-04-03)
4,080 reads
Tomorrow: NYC Metro SQL Server User Group Presents Paul Randal and Kimberly Trip
Well, they're baack in the City!Coming this Thursday April 4, 2013 to the Big Apple, hosted by the NYC
Metro SQL...
2013-04-03
942 reads
DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats
sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx
Returns aggregate performance statistics for cached query plans. The view...
2013-04-03
4,585 reads
Total Number Of Records In each Table
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
733 reads
Reminders and Rehearsal
I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by...
2013-04-02
794 reads
Analysis Services Webinar Recording and Q&A
I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If...
2013-04-08 (first published: 2013-04-02)
2,228 reads
Madison SQL Saturday (#SQLSat206) Is This Weekend
Crack a beer and melt the cheese, the Madison SQL Saturday is this weekend. Don’t wait any longer because you...
2013-04-02
494 reads
Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,283 reads
The New MidnightDBA.com is live!
GUYS! GUYS! GUYS!!! We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for,...
2013-04-02
630 reads
Merging SQL Server and Softball Just for Fun
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,292 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers