Gulappa Vijaya Kumar


SQLServerCentral Article

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.71 (65)

You rated this post out of 5. Change rating

2017-02-02 (first published: )

52,766 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

40,088 reads

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

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

665 reads

Technical Article

DependencyDetails

This sp will return the dependency details of the select table or all tables as a resultset.  This resultset will display the dependency details if it is used in 1. select * from table or2. insert/delete/update dml statement or 3. select col1, col2 from table.

You rated this post out of 5. Change rating

2004-02-25

209 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

150 reads

Blogs

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs

Forums

You have an error in your SQL syntax; check the manual that corresponds

By yrstruly

I am having great trouble creating a data pipeline using MariaDB connector 3 with...

Availability Group database went into 'Restoring' state

By Arsh

Dear Friends, Please advise why would one of my Availability Group databases go into...

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers