|
|
-
|
|
Sometime we feel that a query in application is quite fast while same query is relatively slow in SQL Server Management Studio. Why So....
|
|
-
|
|
DDL Changes Log additional changes in script to get client IP...
|
|
-
|
|
How to create DDL Change Log using Service Broker,for multiple databases on a single instance....
|
|
-
|
|
During upgradation of a client database from SQL Server 2000 (Compatibility Level 80) to SQL Server 2005 (Compatibility Level 90), I have found that there are changes which need to apply for compatibility level 90, that are still not documented...
|
|
-
|
|
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:...
|
|
-
|
|
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-padding...
|
|
-
|
|
A year back I have shared a script from query bank, which can be helpful to get indexes list of a database, with key and involved columns. Being a DBA, I never remember a day, without using this script. Getting detail of indexes on a database most of the t...
|
|
-
|
|
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-padding...
|
|
-
|
|
Using SQL Server Management Studio, have you ever come a cross following questions: Why every time, a new query window is open with MASTER database.? On opening SQL Server Management Studio, I need a new query window automatically ?
...
|
|
-
|
|
While applying, Long Running Sessions Detection Job on a production server, we start receiving alert that a session is taking more then 3 minutes. But what actually this session was doing for so long and how to resolve it....
|
|