On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,882 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
PASS Summit Session Votes
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,072 reads
On Transactions, errors and rollbacks
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,276 reads
Pass summit abstracts
I missed the Pass summit last November for a number of reasons, but I’m hoping I can attend this year....
2011-05-10
954 reads
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
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,010 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,775 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
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers