sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,322 reads
More on SQLSaturday – From Jack Corbett
My friend Jack posted a nice aggregate of comments so far about the transfer of SQLSaturday to PASS, and added...
2010-02-18
550 reads
Interactive Sorting Using a Tablix in Reporting Services
Many organizations collect data, lots and lots of data. We have the opportunity and ability today to collect more data...
2010-02-18
1,068 reads
NOT EXISTS vs NOT IN
Continuing with the mini-series on query operators, I want to have a look at NOT EXISTS and NOT IN.
Just one...
2010-02-18
56,355 reads
BugMeNot
Warning: Rant coming
Every once in awhile I get a note from someone, usually a somewhat nasty one, that complaints about...
2010-02-18
1,100 reads
SQLSaturday Acquired by PASS – Reactions
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-18
1,238 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,018 reads
The Adversity Index
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
502 reads
Free MSDN Azure Event in Orlando
Joe Healy is doing a four hour Azure training event on March 6, 2010 in Orlando, details and free registration...
2010-02-18
665 reads
Chicago Next Week
I’m in Chicago for a couple days next week, flying in on Sunday. Anyone in the area available for dinner...
2010-02-18
541 reads
Blogs
Flyway Tips: Immediate Code Review for Developers
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
Forums
Alamat Kontak Bank BCA KCU GALAXY Telp:08218154393
WA:08218154393 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa Timur...
Alamat Kontak Bank BCA KCP Tidar Telp:08218154393
WA:08218154393 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers