SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
5 reads
Blog Posts
Why is my tSQLt test not running?
I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my...
2015-09-24 (first published: 2015-09-10)
1,220 reads
“sql_handle” is not a recognized table hints option.
I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...
2015-09-23
1,023 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
48 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
69 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
870 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know about when you create the dacpac, possibly you have...
2015-09-23
4 reads
Dynamic SQL & Quotename
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
915 reads
Dynamic SQL & Quotename
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
382 reads
Extended Events – Events
After thrilling dives into the XEvent Core Concepts of packages, channels and objects, today we have the core concept of...
2015-09-23 (first published: 2015-09-10)
1,442 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers