T-SQL

A Plunge Into TOP

  • Article

Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]

5 (6)

2019-06-04

4,289 reads

SQL Server Cursor Example

  • DatabaseWeekly

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors?

2019-05-31

DEADLOCK_PRIORITY

  • DatabaseWeekly

When it detects a deadlock, SQL Server will, by default, pick the process the has the lowest cost to rollback. This can present a potential issue if the process is a business critical process. The DEADLOCK_PRIORITY allows us to have a bit of control over whether or not a process is chosen as the victim.

2019-05-31

Blogs

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

Read the latest Blogs

Forums

SQL Tamagotchi! Mini-Servers as Database Pets

By Phil Factor

Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...

SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

By Warren Peace

Anyone have any insights on how this licensing works and what the "Use Rights"...

SSIS - Adding Columns to existing table and load data

By sunshine

I am working in SSIS (Sql server version 2012) , I have a requirement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers