SQL Server 2017 for Linux First Impressions
Microsoft has released a version of SQL Server 2017 for Linux.
2018-03-26
2,731 reads
Articles
READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count
Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.
2018-03-26
3,103 reads
Getting query text from SSMS into a CSV with PowerShell
You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.
2018-03-23 (first published: 2015-09-07)
6,385 reads
Scripting the Description of Database Tables Using Extended Properties
Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.
2018-03-23
3,324 reads
The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS
This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.
2018-03-22
36,709 reads
How to Get a Random Row from a Large Table
Brent Ozar takes a look at four different ways to get a random row from a large SQL Server table.
2018-03-22
5,124 reads
Charles Bachman and Pointer Chains
Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.
2018-03-21
2,756 reads
Balancing Performance and Readability
Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.
2018-03-20
1,339 reads
Different Ways to Import JSON Files into SQL Server
Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.
2018-03-20
4,130 reads
Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
3,238 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