Gulappa Vijaya Kumar

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.

4 (1)

2006-03-31 (first published: )

39,062 reads

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 […]

2005-12-06 (first published: )

311 reads

Execution Plans

How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.

3.7 (64)

2005-10-07 (first published: )

51,861 reads

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.

2005-01-12 (first published: )

575 reads

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 […]

2003-11-06

138 reads

Blogs

Weekly reading #19

By

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

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...

Power BI Monthly Digest – June 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

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