Disabling Indexes - SQL School Video
There are times that you do not want indexes to be updated and used. Brian Knight shows how you can accomplish this with a new SQL School video.
2009-01-13
3,269 reads
Articles
Get Error Description in SQL Server 2000
How to Extract Error Description in SQL Server 2000 based on Error Number
2009-01-13
7,946 reads
Grouping with SQL Server 2008
Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.
2009-01-13
3,724 reads
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
2009-01-13
142 reads
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
2009-01-13
448 reads
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
2009-01-13
162 reads
Using the NOWAIT option with the SQL Server RAISERROR statement
T-SQL scripts and stored procedures don’t produce their PRINT statements and RAISERROR output in a way that keeps you informed of the code’s progress. You usually have to wait until the procedure is complete before seeing messages. How can I get insight into the code's progress?
2009-01-13
2,944 reads
2009-01-12
507 reads
2009-01-12
515 reads
SQL Server Management Studio 2008: New features, part 2
SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
2009-01-12
4,656 reads
Blogs
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers