Simple Merges KDiff3 at SQL in the City
One of the hassles of working in a development team is that you will have conflicts between your code and...
2015-09-21
1,045 reads
Blog Posts
Speaking at SQLSaturday #446, Oregon 2015
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
434 reads
Step by Step SSIS - Conditional Split Transformation TIP #117
In the series of Zero to Hero in SSIS this is our next post. In this post we will see...
2015-09-21
3,275 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
368 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
646 reads
Why I hate Pie Charts
The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...
2015-09-21
541 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
195 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
305 reads
Yes, Foreign Keys Help Performance
I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....
2015-09-21 (first published: 2015-09-09)
2,684 reads
Zombie AD Groups
I spent something like 2 hours today trying to figure out how a particular user had access to one of...
2015-09-21
629 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