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
706 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
25 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,358 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
5 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,138 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,425 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
4 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,102 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
4 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
752 reads
Blogs
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)
We have an issue where SSIS packages are failing with a status of "ended...
SQL Newbie HELP: The query references an object that is not supported in distr..
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers