Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Programming Rss

   Items 1 to 20 of 70    Older >>
 

Conversion of a plain English problem into T-SQL

An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.  Read more...
By Rob McNicol 2011/10/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,865 reads

Data Types

By Britt Cluff 2009/09/02 | Category: programming
Rating: (not yet rated) |  Discuss |   Briefcase | 4,221 reads

Uncommon Table Expressions

This article describes an alternate use of CTEs for functional data processing.  Read more...
By Peter Kierstead 2008/08/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,294 reads

T-SQL Data Processing

This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.  Read more...
By Peter Kierstead 2008/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,916 reads

Introduction to Bitmasking in SQL Server 2005

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.   Read more...
By Lee Everest 2006/12/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,578 reads

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,457 reads

Introduction to Bitmasking in SQL Server 2005

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.   Read more...
By Lee Everest 2006/12/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,578 reads

Unit Testing With Visual Studio

Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.   Read more...
By Grant Fritchey 2006/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,056 reads

Implementing a T-SQL semaphore

SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.   Read more...
By Robert Cary 2006/10/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,844 reads

A Look at GUIDs

Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.   Read more...
By Andy Warren 2006/07/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,713 reads

Introduction to the ADO Connection Object

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,956 reads

Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.   Read more...
By Asif Sayed 2006/05/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,956 reads

How to Build Dynamic Stored Procedures

Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!   Read more...
By Robert Marda 2005/12/16 (first published: 2003/04/25) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 48,992 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,262 reads

Creating a PDF from a Stored Procedure

A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.   Read more...
By Masar Ivica 2005/09/02 (first published: 2003/08/26) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 55,005 reads

Dynamic SQL or Stored Procedure

We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.   Read more...
By Andy Warren 2005/08/26 (first published: 2003/04/23) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 47,237 reads

You Want To Do What, with MY Database?

SQL Server 2000 is an extremely powerful and flexible development platform, but if the users mess up the data, there's nothing you can do. Protecting the integrity sometimes means severely limiting access to users. Roy Carlson brings us a technique using sp_makewebtask that you can easily use to provide users with some data without giving them query access.   Read more...
By Roy Carlson 2005/05/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,013 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,813 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 reads

Divide and Conquer

This is the first article by Steve Jones that examines a programming technique for handling operations that may be too large to run in a single query.   Read more...
By Steve Jones 2004/11/05 (first published: 2001/05/09) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,586 reads
   Items 1 to 20 of 70    Older >>
 
Tags
miscellaneous (45)    
sql server 7 (18)    
stored procedures (18)    
visual basic 6 (14)    
administration (11)    
ado (11)    
strategies (9)    
performance tuning (8)    
advanced querying (7)    
database design (6)    
sql-dmo (6)    
configuring (5)    
.net (4)    
security (4)    
basics (3)    
sql puzzles (3)    
asp (2)    
best and worst practices (2)    
naming standards (2)    
worst practices (2)    
xml (2)    
analysis services (ssas) (1)    
backup / restore (1)    
common table expression (cte) (1)    
data warehousing (1)    
indexing (1)    
installation (1)    
monitoring (1)    
semaphore (1)    
synonyms (1)    
updategrams (1)