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,824 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,111 reads

Blogs

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

FDD 2023 – Session Materials

By

You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Read the latest Blogs

Forums

Central Management Server (CMS) on AlwaysOn for Failover Process

By sunshine-587009

Good afternoon! Is there any type of documentation or process for failing over a...

Convert Binary or Hex field to show text information

By kakovatos7

Hi all, I have an SQL database table with events, and within it a...

Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers