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
439 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
576 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
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers