SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,384 reads
vitamindba
Let’s talk SQL Server Waits: Topic 2 – CXPacket
With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...
2019-01-30 (first published: 2019-01-16)
2,669 reads
SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16
I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...
2019-01-10
8,037 reads
Let’s talk SQL Server Waits: Topic 1 – SOS_SCHEDULER_YIELD
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,544 reads
What is the Max Degree of Parallelism setting for SQL Server?
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,656 reads
Seeing WriteLog wait type on your SQL Server?
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
2,785 reads
Get Rid of those unused indexes!
Indexes in relational databases are very helpful and increase the speed to access data. However maintaining indexes is just as...
2018-12-11
190 reads
Enabling Query Store
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
889 reads
Deadlocks in a SQL Server Database
Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...
2018-12-18 (first published: 2018-12-03)
3,142 reads
Database Stuck in Suspect Mode
My holiday week did not started off very good. I come in and find a UAT environment database in suspect...
2018-11-27
1,884 reads
Blogs
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Daily Coping 8 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
MAX not working with a CTE
I have a query that is supposed to return one patient id but even...
doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'
i have a cursor that runs on all my views and then exec...
Transaction log full error 9002 on Alwayon Availability groups
Hi All, I am looking for some inputs on how to avoid or prevent...
Ask SSC