log reader uses single CPU
For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...
2015-10-09
438 reads
Vinay Thakur
Whats new in SQL Server 2016
While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with...
2015-07-31
1,637 reads
hey its time for 2016!!!
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,215 reads
Whats New 2014
Hey all, Continue to my whats New series, I am going through its new features and the more I am...
2014-12-19
575 reads
Re-initialize replication not working
For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask...
2014-02-22
564 reads
Sql Cluster Resource not comming online
when you check on the sql server services and sql agent services it’s getting started on windows cluster but on...
2014-02-22
683 reads
TempDB Contention 2.1.%
Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of 2.1.103...
2013-10-16
744 reads
Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
894 reads
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
838 reads
Sql Server 2014…….What!!!
Yes, its true. Microsoft vice president has announce that new version of sql server 2014, will release on 2014… do...
2013-06-17
1,075 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers