Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
443 reads
An open letter to the PASS community (2017)
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
355 reads
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
438 reads
Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,052 reads
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...
2017-09-27 (first published: 2017-09-20)
1,069 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt. Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:http://andreas-wolter.com/blog/
Dear Readers this...
2017-09-20
19 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich...
2017-09-20
333 reads
UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database
sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...
2017-09-20
156 reads
The Tabular Model Documenter is now a Power BI Template
A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or...
2017-09-26 (first published: 2017-09-19)
2,392 reads
How to change Integration Services Catalog (SSISDB) database Master Key encryption password?
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement: In the above Transact-SQL fragment, we first open the Integration Services Catalog...
2017-09-19
16 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