SQL Server Cursor Example

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

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource

Instance wide script to add user (the 4th way)

The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.

CURSOR LOOP

RE: Export table Structer and Data into SQL script file...

pogowolf is going from access to sql server, so the access table will be created in sql server; not scripted from an existing sql server table

RE: SQL2000 Stored Procedures run WAY slower than straight TSQL Queries?

Excellent information, thanks! I took an easy way out, and it actually worked... I copied all of stored procedure into a new one, name tmpusp, ran it, and it ran fine. I then got rid of the old one, renamed the new one, and it solved the problem.

RE: Index Usage w/ Dynamic Where Clause

SQL Server needs to pick one and only one access path for your SELECT statement. Since there are 5 columns being compared it will assume that every one is being used all the time which will never be the actual case due to the CASE statements embedded into the WHERE clause.As for a "better" way, what […]

Changes to replication with MS03-031

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Looking for Visual Basic .Net demo code using SQL client .net provider

Have a look at www.pscode.com