PowerShell Script for Creating Indexes
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,811 reads
Blog Posts
Speaking at European PASS
I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...
2010-01-21
690 reads
Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
582 reads
SQL Server 2008 - Top Reasons to Upgrade.....
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,215 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
446 reads
SQL Server 2008 R2 to be Available in May
This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...
2010-01-21
673 reads
SQLSaturday #32 – Tampa
Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd). This will be my 5th SQLSaturday...
2010-01-21
338 reads
Using sp_ExecuteSql to Run Dynamic SQL
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
640 reads
Can query performance be dependent on the client?
This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent...
2010-01-20
651 reads
Collaboration Patterns – Part 2
Recently I caught a few minutes of a CSPAN interview with Chief Justice John Roberts, part of a larger presentation...
2010-01-20
491 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
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers