You may be interested in reading about how to customize "GO". If so, please read my post: [“GO” as Batch Separator – Customize batch separator in SSMS & SQLCMD – What would you use instead of “GO”?][1] (and please leave your feedback as you go!) ...

Today I learned, how we can get list of all store procedure from database which is using the given table [code] sp_depends <tableName> [/code] Thank You......

Today I learned, how we can get list of all store procedure from database which is using the given table [code] sp_depends <tableName> [/code] Thank You......

Today I learned, how we can get list of all store procedure from database which is using the given table [code] sp_depends <tableName> [/code] Thank You......

Today I learned, how we can get list of all store procedure from database which is using the given table [code] sp_depends <tableName> [/code] Thank You......

I always thought that for Clustered Index, Rows physically will store in a page in order. In our recent Chennai UG meet, speaker Ramkumar explained paul randall myths. He mentioned that records are not stored in order, only slot array will be in order. ...

I always thought that for Clustered Index, Rows physically will store in a page in order. In our recent Chennai UG meet, speaker Ramkumar explained paul randall myths. He mentioned that records are not stored in order, only slot array will be in order. ...

I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing: [code] /* I would like to insert information from table ...

I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing: [code] /* I would like to insert information from table ...

SQL backup compression is a must tool for many Microsoft SQL Server administrators if you experience disk space problems, also decreases the network traffic load and network transfer time of SQL backup data files if you have to copy your SQL backup file...