Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
737 reads
Simple SQL Server
Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,614 reads
Free SQL Server Training (not a sales pitch)
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,081 reads
The Approachable DBA
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
486 reads
Cleaning up the Buffer Pool to Increase PLE
Chances are you have extra information in the buffer pool for a bad query and it’s dragging down your PLE,...
2014-01-08
2,028 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,683 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
841 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,170 reads
Monitoring and Baselines Presentation
Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...
2013-09-20
949 reads
Monitoring Database and Table Sizes
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,093 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Bank BCA KCU BCA KCU Jayapura telp 0817 844 112
WhatsApp CS,0817844112 Komp. Pertokoan Jayapura, Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
Bank BCA KCU Tanjung Pandan telp 0817 844 112
WhatsApp CS,0817844112 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten Belitung,...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers