Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,484 reads
Kenneth Fisher
T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,579 reads
Transactions: What commands aren’t allowed?
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,554 reads
Check your SQL Agent history settings before it’s too late!
A little while back I was doing some research into a failed job and ran into a slight problem. The...
2014-02-10
895 reads
Negative session_ids
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,171 reads
Transactions: Creating a single restore point across multiple databases.
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...
2014-02-02
1,362 reads
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
1,181 reads
Transactions: Who, What and Where
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...
2014-01-23 (first published: 2014-01-20)
3,295 reads
The “most_recent_sql_handle” column
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...
2014-01-22
1,080 reads
Guid vs Identity columns (Ints)
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...
2014-01-20 (first published: 2014-01-13)
4,747 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