Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
716 reads
MSSQLFUN
How to kill a negative SPID (like SPID -2 or -3) in SQL Server?
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...
2014-08-25
38 reads
How to kill a negative SPID (like SPID -2 or -3) in SQL Server?
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,561 reads
SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...
2014-08-11
24 reads
SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE
Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...
2014-08-11
1,150 reads
Renaming or Changing SQL Server Cluster Instance
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...
2014-08-12 (first published: 2014-08-04)
16,510 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as...
2014-07-29
20 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL...
2014-08-05 (first published: 2014-07-29)
9,145 reads
Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !
The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes...
2014-07-27
21 reads
Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !
The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2014-07-27
761 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers