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: )

316 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: )

672 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

154 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

446 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

276 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

system_health configuration

By Sailor

I'm on SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11...

SQL Server UCP

By deubel_m

Hello everybody, I just read on the Microsoft homepage that SQL Server Utility Control...

Using AI for Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using AI for Security

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers