SQLServerCentral 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)     Ranking Functions (3)     constraints (1)     OUTER APPLY (1)    
Miscellaneous (104)     Spatial Data (3)     copyright (1)     parallel processing (1)    
SQL Server 7, 2000 (104)     XSL (3)     correlated subqueries (1)     Parameterized Queries (1)    
Performance Tuning (75)     Alias (2)     cross apply (1)     Partitioned Tables (1)    
Basic Querying (68)     ASP (2)     CROSS JOIN (1)     procedural programming (1)    
Stored Procedures (62)     Auditing (2)     Data Manipulation (1)     Product Reviews (1)    
Programming (58)     Comma seperated (2)     Data Profiling (1)     RANDOM (1)    
Administration (57)     Common Language Runtime (CLR) (2)     Data Quality (1)     Record Linkage (1)    
SQL Puzzles (33)     Crosstab (2)     deadlock (1)     Recursive function (1)    
Strategies (19)     CTE (2)     DENY SELECT (1)     Regular Expressions (1)    
SQL Server 2008 (18)     Data Warehousing (2)     DerivedTables (1)     Reporting (1)    
User Defined Function (UDF) (18)     Database Weekly (2)     Distributed Queries (1)     REVERT (1)    
Configuring (16)     Datetime Manipulation (2)     DMV (1)     Reviews (1)    
Database Design (16)     Delimited Strings (2)     Editorial - iPod (1)     Row Count (1)    
Security (16)     Design and Theory (2)     Editorial - WMV (1)     ROW_NUMBER() (1)    
SQL Server 2005 (15)     Editorial - MP3 (2)     English Query (1)     Scripts (1)    
XML (15)     Hierarchies (2)     Error Handling (1)     Search (1)    
Visual Basic 6 (14)     HierarchyID (2)     Excel (1)     SELECT * (1)    
ADO (12)     Intersect (2)     EXCEPT (1)     Semaphore (1)    
Monitoring (12)     joe celko (2)     Execute AS (1)     Semi-Additive measures (1)    
Triggers (11)     Matrix (2)     FILESTREAM (1)     Service Packs (1)    
Basics (10)     News (2)     Fiscal Year (1)     Set Based (1)    
Date Manipulation (8)     Outer Joins (2)     Foreign Key (1)     Similarity (1)    
String Manipulation (8)     paging (2)     function (1)     solo (1)    
Video (8)     parsing delimited string (2)     Functional Dependency (1)     split (1)    
Indexing (7)     pivot (2)     Fuzzy Match (1)     SQL Scripts (1)    
Blogs (6)     Recursion (2)     GROUP BY (1)     SQL Server (1)    
Common Table Expression (CTE) (6)     Replication (2)     IDENTITY (1)     SQL Server 2000 (1)    
SQL-DMO (6)     Running Totals (2)     INNER Join (1)     SQL Server Management Studio (SSMS) (1)    
System Development Life Cycle (6)     Schema (2)     insert (1)     SS2K5 - XML (1)    
Backup and Recovery (5)     Schemas/DTDs (2)     Integration Services (SSIS) (1)     SSAS (1)    
Best Practices (5)     SQL Server 2005 - TSQL (2)     Inventory Problem (1)     Star Schemas (1)    
Editorial (5)     Synonyms (2)     IP Addresses (1)     Storage (1)    
.Net (4)     Tally Table (2)     IPv4 Addresses (1)     String Match (1)    
Aggregates (4)     UNION (2)     Jaro Winkler (1)     SUBSTRING (1)    
Best and Worst Practices (4)     Views (2)     Javascript (1)     Swap data (1)    
cursors (4)     Worst Practices (2)     JSON (1)     Temp tables (1)    
Data Types (4)     4-4-5 Accounting (1)     Large UDT (1)     Top (1)    
delete (4)     Advanced (1)     logging (1)     Triangular Joins (1)    
DTS (4)     Alias Data Types (1)     Management Studio (1)     Truncate (1)    
Installation (4)     Analysis Services (SSAS) (1)     MEDIAN (1)     T-SQL Aids (1)    
OpenXML (4)     Arrays (1)     MERGE (1)     T-SQL Challenges (1)    
SQL Server 6.5 (4)     Backup / Restore (1)     meta data (1)     UDF (1)    
UpdateGrams (4)     BLOB Manipulation (1)     mobile devices (1)     UniqueIdentifier (1)    
Development (3)     Business Days (1)     msdb (1)     update (1)    
Dynamic SQL (3)     checksum (1)     ntile (1)     WHERE (1)    
grouping sets (3)     Closing Balances (1)     Ordinal Rank (1)     xxxx (1)    
Naming Standards (3)     Common Table Expressions (1)    

Search for any content tagged T-SQL

   Items 1 to 20 of 708    Next 20 >>
 

Introduction to Common Table Expressions

Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.  Read more...
By Kathi Kellenberger 2009/12/08 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 1 read

REPLACE Multiple Spaces with One

Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method for replacing multiple spaces from MVP Jeff Moden.  Read more...
By Jeff Moden 2009/11/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 12,452 reads

Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.  Read more...
By Jeff Moden 2009/11/10 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 8,428 reads

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...
By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 8,808 reads

Using T-SQL CROSS APPLY and OUTER APPLY

That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.  Read more...
By Additional Articles 2009/11/06 | Source: developer.com | Category: T-SQL
Rating:  Rate this |  Briefcase | 5,609 reads

Preventing usage of "SELECT *..."

Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.  Read more...
By Raghuram (AJ) 2009/11/05 | Source: SQLServerCentral.com | Category: SELECT *
Rating: |  Discuss |  Briefcase | 19,812 reads

Improving Cube Performance with Precalculated Aggregations

A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.  Read more...
By Johan Åhlén 2009/11/04 | Source: SQLServerCentral.com | Category: SSAS
Rating: |  Discuss |  Briefcase | 4,301 reads

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses

Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.  Read more...
By Additional Articles 2009/11/04 | Source: Database Journal | Category: T-SQL
Rating:  Rate this |  Briefcase | 6,815 reads

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 30,611 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2009/10/29 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 13,363 reads

Characters

No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”   Read more...
By Steve Jones 2009/10/26 | Source: SQLServerCentral.com | Category: Blogs
Rating:  Rate this |  Briefcase | 922 reads

Understanding INNER join in detail

This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.   Read more...
By Susantha Bathige 2009/10/23 (first published: 2008/07/08) | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 40,245 reads

Causation, Correlation and Crackpots

Joe Celko explores the dangers of muddling correlation and causation, emphasises the importance of determining how likely it is that a correlation has occurred by chance, and gets stuck into calculating correlation coefficients in SQL. Along the way, Joe illustrates the consequences of leaping to the wrong conclusion from correlations with tales of Pop Dread.   Read more...
By Additional Articles 2009/10/19 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 1,549 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.  Read more...
By Carl P. Anderson 2009/10/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 13,648 reads

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.  Read more...
By Jeff Moden 2009/10/02 (first published: 2008/08/19) | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 48,320 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2009/09/28 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |  Briefcase | 8,270 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 2009/09/25 (first published: 2008/02/27) | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 57,247 reads

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: T-SQL
Rating:  Rate this |  Briefcase | 8,132 reads

A Function to Split JSON Data

JSON is Javascript Object Notation and it's a format for exchanging data. New author Ric Vander Ark brings us an article that shows how to implement a function to split out the data into a table format and gives a number of examples for different data.  Read more...
By Ric Vander Ark 2009/09/23 | Source: SQLServerCentral.com | Category: JSON
Rating: |  Discuss |  Briefcase | 5,898 reads

The Dynamic Tally or Numbers Table

Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.  Read more...
By Lynn Pettis 2009/09/22 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 7,025 reads
   Items 1 to 20 of 708    Next 20 >>
 
Most popular

ROW_NUMBER(): An Efficient Alternative to Subqueries

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...
By Francis Rodrigues 2009/05/12 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 36,789 reads

How To Get Table Row Counts Quickly And Painlessly

Use sysindexes\DMVs insead of select count(*) to retreive table row counts  Read more...
By Kendal Van Dyke 2009/09/02 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 22,630 reads

REPLACE Multiple Spaces with One

Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method for replacing multiple spaces from MVP Jeff Moden.  Read more...
By Jeff Moden 2009/11/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 12,452 reads