Gulappa Vijaya Kumar


Technical Article

Replace Object Owner

This SP is used to identify and replace the owner of the database objects. This SP will give display object id, object name, owner id, owner name and concatenate object + owner name with brackets. SP does change the owner for the following objects. SP should available in "master" database to execute in more than […]

You rated this post out of 5. Change rating

2005-12-06 (first published: )

324 reads

Technical Article

Convert Unique Identifier to Varchar data type

Script will drop the Default, Primary, Unique, Foreign Constraints, Index and ROWGUID on Unique Identifier data type column and finally it alters the unique identifier to varchar (38) data type. I have compile and execute the script in my database server. Script has executed successfully.

You rated this post out of 5. Change rating

2005-01-12 (first published: )

752 reads

Technical Article

ClearData

We can use this sp to clear data in tables.  I mainly created this sp for two reason. 1.This is useful to commence the testing from scratch.  2.Whenever we ask the database backup from our customer.  They hesitant to give the production database because of confidential.  I have used Delete and Truncate statement to clear […]

You rated this post out of 5. Change rating

2003-11-06

166 reads

Technical Article

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)

You rated this post out of 5. Change rating

2003-10-30

449 reads

Technical Article

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)

You rated this post out of 5. Change rating

2003-10-29

280 reads

Blogs

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

By

As data becomes the backbone of modern business, understanding how to manage and analyze...

Read the latest Blogs

Forums

SQL Server 2008 to SQL Server 2022

By Skybvi

Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers