Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
804 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Indexing for ORs
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,011 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...
2011-05-02
1,318 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,782 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,068 reads
Q & A from 24 Hours of PASS session
Earlier this week I took part in the 24 Hours of PASS live webcast event. There were far more questions...
2011-03-18
701 reads
Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,333 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,576 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCU TANJUNG PRIOK No. Telp:083831617937
Whatsapp.083831617937 Jl. Enggano 22-23 Jakarta Utara, DKI Jakarta, Indonesia 14310
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers