SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

Advanced Querying (168)     Basics (10)     News (2)     English Query (1)    
Miscellaneous (104)     Triggers (8)     Replication (2)     HierarchyID (1)    
SQL Server 7, 2000 (101)     Indexing (6)     Schemas/DTDs (2)     Outer Joins (1)    
Basic Querying (68)     SQL Server 2008 (6)     SQL Server 2005 - TSQL (2)     pivot (1)    
Stored Procedures (60)     SQL-DMO (6)     String Manipulation (2)     Product Reviews (1)    
Performance Tuning (58)     Backup and Recovery (5)     Worst Practices (2)     Regular Expressions (1)    
Programming (56)     System Development Life Cycle (5)     Administration (1)     Reviews (1)    
Administering (53)     .Net (4)     Advanced (1)     Scripts (1)    
Performance Tuning and Scaling (34)     DTS (4)     Aggregates (1)     Search (1)    
SQL Puzzles (31)     Installation (4)     Alias Data Types (1)     Semaphore (1)    
Strategies (19)     OpenXML (4)     Analysis Services (1)     Service Packs (1)    
Configuring (16)     SQL Server 6.5 (4)     Best Practices (1)     solo (1)    
Security (15)     UpdateGrams (4)     BLOB Manipulation (1)     SQL Server 2000 (1)    
Database Design (14)     Best and Worst Practices (3)     CLR Integration (1)     SS2K5 - XML (1)    
User-Defined functions (14)     Naming Standards (3)     Data Types (1)     Triangular Joins (1)    
Visual Basic 6 (14)     XSL (3)     Data Warehousing (1)     Truncate (1)    
Monitoring (12)     ASP (2)     Datetime Manipulation (1)     T-SQL Aids (1)    
XML (12)     CTE (2)     delete (1)     UDF (1)    
ADO (11)     Development (2)     DerivedTables (1)     Video (1)    
SQL Server 2005 (11)     Dynamic SQL (2)     Distributed Queries (1)     Views (1)    

Search for any content tagged T-SQL

   Items 1 to 20 of 459    Next 20 >>
 

Eliminating Cursors

T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.   Read more...
By Kamran Ali 2008/06/13 (first posted: 2006/01/17) | Source: SQLServerCentral.com | Category: SQL Puzzles
Rating: |  Discuss |  Briefcase | 33,875 reads

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.  Read more...
By Additional Articles 2008/06/04 | Source: Builder.com | Category: T-SQL
Rating: (not yet rated)  Rate this |  Briefcase | 1 read

Is a Temporary Table Really Necessary?

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.   Read more...
By Randy Dyess 2008/05/30 (first posted: 2002/04/09) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 38,627 reads

Row Value Constructor in SQL Server 2008

This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.  Read more...
By Additional Articles 2008/05/16 | Source: Database Journal | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,971 reads

Everybody Reports to Somebody

One of the very common questions posted about T-SQL is how to traverse a hierarchy in a set based manner. New author Craig Hatley brings us his techniques for handling the common scenario of employees and managers.   Read more...
By Craig Hatley 2007/06/04 | Source: SQLServerCentral.com | Category: Advanced Querying
Rating: |  Discuss |  Briefcase | 4,914 reads

PIVOT working incorrectly?

One developer's journey through PIVOTing incorrectly.  Read more...
By Ryan Clare 2008/05/13 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |  Briefcase | 5,571 reads

Simplify SQL Server 2005 queries with a Dates table

Learn what a Dates table is and how to create one, and then try it out for yourself  Read more...
By Additional Articles 2008/05/06 | Source: Builder.com | Category: SQL Server 2005
Rating:  Rate this |  Briefcase | 4,900 reads

Passing a Table to A Stored Procedure

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...
By Jacob Sebastian 2007/12/07 (first posted: 2007/05/30) | Source: SQLServerCentral.com | Category: Stored Procedures
Rating: |  Discuss |  Briefcase | 44,350 reads

The T-SQL Quiz

Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.   Read more...
By Grant Fritchey 2007/05/28 | Source: SQLServerCentral.com | Category: SQL Puzzles
Rating: |  Discuss |  Briefcase | 14,746 reads

A Function Gotcha with the Use of an Asterisk

This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function.  Read more...
By Stephen Lasham 2008/04/30 | Source: SQLServerCentral.com | Category: UDF
Rating: |  Discuss |  Briefcase | 7,790 reads

Converting Hexadecimal String Values to Alpha (ASCII) Strings

In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.   Read more...
By Stephen Lasham 2007/05/17 | Source: SQLServerCentral.com | Category: Advanced Querying
Rating: |  Discuss |  Briefcase | 7,487 reads

TSQL Spam-killer

In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.  Read more...
By Additional Articles 2008/04/25 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 1,677 reads

UPSERT Functionality in SQL Server 2008

This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.  Read more...
By Additional Articles 2008/04/24 | Source: Database Journal | Category: SQL Server 2008
Rating:  Rate this |  Briefcase | 4,157 reads

Reading the SQL Server log files using T-SQL

One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?  Read more...
By Additional Articles 2008/04/23 | Source: MSSQLTips.com | Category: T-SQL
Rating:  Rate this |  Briefcase | 3,155 reads

SQL String User Function Workbench: part 1

Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.  Read more...
By Additional Articles 2008/04/22 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 3,039 reads

Giving Permissions through Stored Procedures

QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.  Read more...
By Additional Articles 2008/04/15 | Source: Erland Sommarskog's SQL Page | Category: T-SQL
Rating:  Rate this |  Briefcase | 2,367 reads

Joining to the Next Sequential Row

One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their order is important. For example, values lying along a time line. The solution is actually quite simple, but not immediately obvious.  Read more...
By Additional Articles 2008/04/10 | Source: SQLTeam.com | Category: T-SQL
Rating:  Rate this |  Briefcase | 3,668 reads

How to Share Data Between Stored Procedures

Different ways of passing sets of data between stored procedures.  Read more...
Rating:  Rate this |  Briefcase | 5,802 reads

New Column Updates

What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation.   Read more...
By Bimal Fernando 2007/05/21 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 6,659 reads

CASE function in SQL Server – part II

Part I of this series illustrated how to use simple case functions in queries. This installment discusses how to use case functions in different types of scenarios.  Read more...
By Additional Articles 2007/04/12 | Source: Database Journal | Category: Advanced Querying
Rating:  Rate this |  Briefcase | 7,645 reads
   Items 1 to 20 of 459    Next 20 >>
 
Most popular

Passing a Table to A Stored Procedure

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...
By Jacob Sebastian 2007/12/07 (first posted: 2007/05/30) | Source: SQLServerCentral.com | Category: Stored Procedures
Rating: |  Discuss |  Briefcase | 44,350 reads

Linking to the Previous Row

One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.  Read more...
By David McKinney 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 12,302 reads

TSQL LAB 2 - Writing Conditional WHERE Clauses

Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.  Read more...
By Jacob Sebastian 2008/02/27 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 15,682 reads