Sometime we feel that a query in application is quite fast while same query is relatively slow in SQL Server Management Studio. Why So....

Here is the answer buddy: http://beyondrelational.com/modules/2/blogs/69/posts/18622/sql-server-client-ip-along-with-ddl-change-log-using-service-broker.aspx...

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....

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. Like ev...

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-padd...

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 th...

Would you like to share, error you are facing....