Folders to Check for errors in SQL Patching or Installation
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
5,663 reads
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
5,663 reads
Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same
2016-10-27
2,236 reads
A while ago I wrote a piece on public speaking assignements over here and promised to write what it takes to...
2016-10-27
392 reads
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
968 reads
Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or...
2016-10-17
929 reads
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
2,525 reads
Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...
2016-10-09
531 reads
Many of us use the stored procedure "sp_recompile" to mark the stored procedure for recompilation, so that next time it...
2016-10-06
1,089 reads
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,004 reads
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
416 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers