New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
11 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
11 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
71 reads
2015-03-03
4 reads
NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there...
2014-12-04
38 reads
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There...
2014-12-04
23 reads
2014-10-31
7 reads
2014-10-20
11 reads
2014-09-26
9 reads
2014-09-19
11 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
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...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
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
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers