2013-08-08
5,466 reads
Shashank Srivastava
Orphaned Distribution Transactions
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
2013-07-16
3,548 reads
Change the Maintenance Plan Owner
This article shows how you can change the maintenance plan owner in SQL SERVER
2013-07-02
3,249 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
2013-05-16
10,672 reads
Blogs
Microsoft Tools That Help Query Tuning
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at...
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can...
Forums
Upgrading SQL Service Packs on multiple versions
Hello SSC, My company has SQL versions that range between 2008 R2 to SQL...
Dynamic images within my report
Hi, Im trying to get dynamic images in my report based on a Tablix...
Setting fill factor on an auto-increment INT clustered index
Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [int] IDENTITY(1,1)...
Ask SSC