Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.

TSQL Challenge 21 - Reading, recognizing and processing graphical representation of digits.

by Press Release

T-SQL Challenges

T-SQL Challenges

Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here is something that is very interesting where you might need to process records in a 'three-line-at-a-time' fashion.

Balancing the Message

by Steve Jones

SQLServerCentral.com

Editorial

How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

by Jeff Moden

SQLServerCentral.com

T-SQL

It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.

Balancing the Message

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Balancing the Message

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Balancing the Message

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Identity Values – Two things to know

by Steve Jones

SQLServerCentral.com

Blogs

I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...

The Right Attitude to be a Mentor

by Brian Kelley

SQLServerCentral.com

Blogs

When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....

Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)

by Additional Articles

CodeProject.com

Performance Tuning

Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:

Manipulating Multiple Objects in SQL Server Management Studio

TSQL Challenge 21 - Reading, recognizing and processing graphical representation of digits.

Balancing the Message

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Balancing the Message

Balancing the Message

Balancing the Message

Identity Values – Two things to know

The Right Attitude to be a Mentor

Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)

Blogs

PlanTrace Now Supports PostgreSQL

A New Word: the Kinder Surprise

Crash-Consistent Snapshot Cloning - Hyper-V Edition

Forums

Call Center Batik Air Yogyakarta

Call Center Batik Air Medan

Call Center Batik Air Tangerang

Question of the Day

SSoL Support on the OS