Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running
on January 29 (Vienna/Austria) and January...
2012-12-10
2,451 reads
December Checklist and Updates
It’s a bit past the first Monday in December, but better a week late than no checklist and update post...
2012-12-10
904 reads
Great Tools for Formatting T-SQL
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-10
1,216 reads
Last Weeks Top 10 “Reading” Links #10
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-10
767 reads
SQL Server Books–Query Tuning
Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...
2012-12-10
1,054 reads
Partitioning Table in SQL Server:
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,335 reads
Is Self-service BI Threatening IT Professionals’ Livelihoods?
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
833 reads
SQL Server Consulting Blog–Sunday Stats
I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done...
2012-12-09
807 reads
SQL Saturday #173 Washington DC wrap up
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
737 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,762 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