2011-07-08
2,080 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,632 reads
2011-07-05
2,508 reads
2011-06-24
2,473 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
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers