Gulappa Vijaya Kumar

User-defined data type dependencies

MSSQLServer has got sp_depends system sp to display the dependencies for a stored procedure, table and view.  sp_depends does not support to display the User-defined data type dependencies.  For custom database, we will create user defined data types (UDDT) and add this UDDT to a column/variable in a table/stored procedure.  This sp (UDTDepends) will help […]

5 (1)

2003-10-30

436 reads

Stabilize Index

This sp is used to update index in a database.  This sp has got three optional varchar parameters.  First parameter will take the tablename. Second parameter will take the indexname.  Third parameter will take the fillfactor.  The following option we can execute the sp in a user database.1.    exec StabilizeIndexIt will update all index in […]

1 (1)

2003-10-29

271 reads

Blogs

Weekly reading #19

By

Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland....

Azure SQL DB Maxdop Hint

By

I had a good question from JP via a comment on my blog about...

The Constant and Constantly Changing Role of the DBA

By

I’ve been working in and around data for over 30 years now. My title...

Read the latest Blogs

Forums

unable to install SQL Server 2014

By Srinivas Sista

Hi, I am trying the install SQL Server 2014 enterprise edition on Windows 2016...

What's the CMK?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the CMK?

All flash vs adaptive flash storage - which is right for my organisation?

By Stephen Wild

Comments posted to this topic are about the item All flash vs adaptive flash...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers