Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
641 reads
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
12,951 reads
Inserting into an XML document
I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...
2010-03-23
2,061 reads
An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
2010-03-23
2,188 reads
Plagiarism Again
Update: The problem posts have been removed from the SQLTechConsulting site.
I ran across a note from Brent Ozar (blog | Twitter)...
2010-03-23
1,806 reads
Critiquing Free Events
Yesterday I wrote about expectations at free events, basically saying they don’t differ a lot from paid events. The next...
2010-03-23
569 reads
Access Analysis Services via T-SQL?
It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...
2010-03-22
877 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,374 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
834 reads
SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,552 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers