2011-07-08
2,079 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,631 reads
2011-07-05
2,508 reads
2011-06-24
2,472 reads
Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,803 reads
T-SQL Tuesday: Disasters don’t just come in huge
So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...
2011-06-14
735 reads
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
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,071 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,275 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
953 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers