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 […]
2003-10-30
446 reads
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 […]
2003-10-29
276 reads
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Good afternoon! Is there any type of documentation or process for failing over a...
Hi all, I have an SQL database table with events, and within it a...
Hi All, I have been trying to download a csv file which is produced...
Ask SSC