SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
755 reads
SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
764 reads
SQL Server – How to Best Remove Extra TempDB Data Files and Log Files
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
949 reads
May 2013 – Monthly SQL Server Checklist
It’s the start of the month of May, or at least the first Monday in May. Hopefully you aren’t nursing...
2013-05-06
694 reads
SQLSaturday Atlanta #220–May 18th
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th...
2013-05-06
556 reads
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I...
2013-05-06
704 reads
PowerSQL – Identify a Head of the Database Blocks and Generate Automated Alert across all listed SQL Instances
This is going to be a simplest way of capturing and sending some useful information via an email of ‘N’...
2013-05-06
760 reads
Last Weeks Top “Reading” Links #31
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-06
431 reads
Quick Tip: Navigating to a UNC within SQLPS
I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the...
2013-05-06
766 reads
A SQL Shirt Style For Any Occasion
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
594 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers