|
|
|
|
-
Guru Samy Liked 5 Months ago through Blogs | 1 Point
Delete duplicate records from a table...
|
|
|
-
Guru Samy Liked 5 Months ago through Blogs | 1 Point
Integration Service Catalog in SSIS 2012...
|
|
|
-
Guru Samy Liked 5 Months ago through Blogs | 1 Point
When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....
|
-
Guru Samy Liked 5 Months ago through Blogs | 1 Point
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
|
|
|
|
-
Guru Samy Liked 5 Months ago through Blogs | 1 Point
From my query bank here is another useful script which can help a Database Administrator to list down stored procedures with tables names which are used in stored procedures but don't contain and non clustered index. Query Output:...
|