SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 

Content with tag T-SQL Rss

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

Advanced Querying (179)     Running Totals (3)     Data Manipulation (1)     Procedure (1)    
SQL Server 7, 2000 (113)     Space Usage (3)     Data Profiling (1)     Product Reviews (1)    
Miscellaneous (112)     Spatial Data (3)     Data Quality (1)     PUBLIC (1)    
Administration (92)     Table (3)     Databases (1)     Puzzle (1)    
Performance Tuning (88)     Text matching (3)     deadlock (1)     QA-Taskpad (1)    
Stored Procedures (69)     Truncate (3)     DEFAULT (1)     Query Optimization (1)    
Basic Querying (68)     Views (3)     DENY SELECT (1)     RANDOM (1)    
Programming (59)     XSL (3)     DerivedTables (1)     Record Linkage (1)    
SQL Server 2005 (57)     2-Dimensional Arrays (2)     description (1)     Recursive function (1)    
SQL Puzzles (34)     Alias (2)     Distributed Queries (1)     Referential Integrity (1)    
T-SQL Aids (26)     ASP (2)     DM_DB_Index_Physical_Stats (1)     Regular Expressions (1)    
Maintenance and Management (25)     Auditing (2)     DMV (1)     report (1)    
Utility (24)     Backup / Restore (2)     Drop Column (1)     Reporting (1)    
SQL Server 2008 (23)     Buffer Cache (2)     Duplicate Indexes (1)     Restore (1)    
Maintenance (21)     checksum (2)     Editorial - iPod (1)     REVERT (1)    
Security (21)     column (2)     Editorial - WMV (1)     Reviews (1)    
User Defined Function (UDF) (21)     Comma seperated (2)     Encode (1)     Role (1)    
Indexing (19)     Common Language Runtime (CLR) (2)     English Query (1)     Rollback (1)    
Strategies (19)     CTE (2)     Excel (1)     Row Count (1)    
String Manipulation (19)     Database Weekly (2)     EXCEPT (1)     ROW_NUMBER() (1)    
Configuring (16)     DateTime (2)     Execute AS (1)     Running aggregate (1)    
Database Design (16)     DDL (2)     Exponents (1)     script (1)    
XML (16)     duplicate records (2)     Extended Stored Procedures (1)     Script Generator (1)    
Visual Basic 6 (14)     Editorial - MP3 (2)     fall on friday (1)     scripting (1)    
Date Manipulation (13)     Error Handling (2)     FILESTREAM (1)     Scripts (1)    
Development (13)     Extract, Transform, Load (ETL) (2)     find foreign key using SQL (1)     select (1)    
Monitoring (13)     function (2)     Fiscal Year (1)     SELECT * (1)    
Triggers (13)     games (2)     Foreign Key (1)     Selectivity (1)    
ADO (12)     GRANT (2)     foreign key constraints (1)     Semaphore (1)    
Data Types (12)     GROUP BY (2)     foreign keys (1)     Semi-Additive measures (1)    
Search (12)     Hierarchies (2)     Functional Dependency (1)     Service Broker (1)    
Admin (10)     HierarchyID (2)     Fuzzy Match (1)     Service Packs (1)    
Basics (10)     Index Usage (2)     Geometry (1)     Set Based (1)    
Indexes (10)     Indexed Views (2)     GPS (1)     SET Functions (1)    
Index Management (9)     Intersect (2)     Grouping VARCHAR Columns (1)     sieve (1)    
pivot (9)     joe celko (2)     growth trend (1)     Similarity (1)    
Aggregates (8)     Lock and Connection Management (2)     Guest User (1)     solo (1)    
nums (8)     Locking (2)     Hexadecimal (1)     source control (1)    
SQLInsider Scripts (8)     Matrix (2)     implicit conversion (1)     sp_msforeachdb (1)    
Storage (8)     MERGE (2)     Index Tuning (1)     Spherical coordinates (1)    
Table of Numbers (8)     News (2)     INNER Join (1)     split (1)    
tally (8)     Outer Joins (2)     insert (1)     SQL (1)    
Video (8)     paging (2)     Insert Update Stored Procedure Generation (1)     SQL Permissions (1)    
automated DBA (7)     parsing delimited string (2)     Integration Services (SSIS) (1)     sql query (1)    
Common Table Expression (CTE) (7)     Permissions (2)     Inventory Problem (1)     SQL Script (1)    
counter (7)     Recursion (2)     IP Addresses (1)     SQL Scripts (1)    
Crosstab (7)     Scalar-valued Functions (2)     IPv4 Addresses (1)     SQL Server (1)    
Delimited Strings (7)     Schema (2)     IsNumeric (1)     SQL Server 2000 (1)    
sys.dm_db_partition_stats (7)     Schemas/DTDs (2)     ISOLATION LEVEL (1)     SQL Server 2005 / SQL Server 2008 (1)    
tables (7)     SQL Server 2005 - TSQL (2)     Isolation Levels (1)     SQL Server Management Studio (SSMS) (1)    
Arrays (6)     sys.dm_exec_query_plan (2)     Jaro Winkler (1)     SQLAgent (1)    
Backup and Recovery (6)     sys.dm_exec_requests (2)     Javascript (1)     SS2K5 - XML (1)    
Blogs (6)     sys.dm_exec_sessions (2)     Jobs (1)     SSAS (1)    
Datetime Manipulation (6)     sys.dm_exec_sql_text (2)     JSON (1)     Star Schemas (1)    
SQL-DMO (6)     sys.dm_os_buffer_descriptors (2)     Large UDT (1)     Stored Procedure Template (1)    
System Development Life Cycle (6)     sys.partitions (2)     LEN() (1)     String formatting (1)    
Best Practices (5)     Tally Table (2)     like (1)     String Match (1)    
delete (5)     Temp tables (2)     logging (1)     SUBSTRING (1)    
Editorial (5)     Top (2)     Logins (1)     Swap data (1)    
List Indexes (5)     Troubleshooting (2)     Management (1)     sys.dm_db_index_usage_stats (1)    
parse (5)     UNION (2)     Management Studio (1)     sys.dm_db_missing_index_details (1)    
.Net (4)     Worst Practices (2)     MDX (1)     sys.dm_exec_connections (1)    
auto-growth (4)     ::fn_listextendedproperty (1)     MEDIAN (1)     sys.dm_exec_cursors (1)    
Best and Worst Practices (4)     4-4-5 Accounting (1)     meta data (1)     sys.dm_tran_session_transactions (1)    
cursors (4)     Advanced (1)     mirror (1)     sys.foreign_key_columns (1)    
data file management (4)     Alias Data Types (1)     Missing Indexes (1)     sys.foreign_keys (1)    
Design and Theory (4)     Alter table (1)     mobile devices (1)     sys.sql_modules (1)    
DTS (4)     Analysis Services (SSAS) (1)     msdb (1)     syscolumns (1)    
FOR XML PATH (4)     Backup (1)     multi process (1)     Sysobjects (1)    
IDENTITY (4)     Barcode (1)     next 13th (1)     System Tables (1)    
Installation (4)     Bitwise Operators (1)     Nth occurance of day in a month/year (1)     table field information (1)    
OpenXML (4)     BLOB Manipulation (1)     Nth occurrence of a weekday in a month and year (1)     table metadata (1)    
routine database growth (4)     Business Days (1)     ntile (1)     Table Valued Function (1)    
routine growth (4)     CAST and CONVERT (1)     object (1)     tempdb (1)    
SQL Server 6.5 (4)     Closing Balances (1)     Object Permissions (1)     Tools (1)    
String Comparison (4)     CLR functions (1)     Operators (1)     Triangular Joins (1)    
Synonyms (4)     CLR Stored Procedures (1)     order by (1)     TSQL (1)    
sys.allocation_units (4)     CLR UDT (1)     Ordinal Rank (1)     T-SQL Challenges (1)    
UpdateGrams (4)     Coalesce (1)     OUTER APPLY (1)     TVP (1)    
Administrator (3)     column description wi SQL (1)     output (1)     UCC/EAN (1)    
Automation (3)     Column Permissions (1)     Parallel (1)     UDF (1)    
Data Warehousing (3)     Common Table Expressions (1)     parallel processing (1)     UniqueIdentifier (1)    
Dynamic SQL (3)     constraints (1)     Parameterized Queries (1)     update (1)    
grouping sets (3)     conversion (1)     parameters (1)     URL (1)    
Naming Standards (3)     Conversions (1)     Partitioned Tables (1)     User (1)    
NULL (3)     copyright (1)     Performance (1)     varchar (1)    
Performance testing (3)     correlated subqueries (1)     prime (1)     WHERE (1)    
Ranking Functions (3)     cross apply (1)     prime number (1)     xxxx (1)    
Replication (3)     CROSS JOIN (1)     procedural programming (1)     Zip codes (1)    
   Items 1 to 20 of 1159    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

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 17 reads

syscolumns names

get a list of syscolumns names from string comma separated columns list  Read more...
By Bernabe Diaz 2009/12/02 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 4 reads

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.  Read more...
By Bernabe Diaz 2009/12/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 12 reads

^ : T-SQL

Read more...
By VM-723206 2009/11/20 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 1,481 reads

Cast as datetime question

Read more...
By John Schroeder 2009/11/18 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 1,965 reads

T-SQL

Read more...
By bitbucket 2009/11/17 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 2,240 reads

Auto-Execute Procs

Read more...
By Taposh Dutta Roy 2009/11/16 | Category: Stored Procedures
Rating: (not yet rated) |  Discuss |  Briefcase | 2,321 reads

Search in your T-SQL objects

This procedure searches for your criteria not only in code, but also in objectnames  Read more...
By Wilfred van Dijk 2009/11/16 | Source: SQLServerCentral.com | Category: Search
Rating: |  Discuss |  Briefcase | 583 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,449 reads

Wait for Mirror treshold

This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.  Read more...
By Wilfred van Dijk 2009/11/10 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 172 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,427 reads

More Fun With NULL

Read more...
By John Arnott 2009/11/09 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 3,173 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,607 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,810 reads

Retrieve consecutive records from the table based the value difference

Retrieve consecutive records from the table based the value difference  Read more...
By Venkatesan Prabu Jayakantham 2009/11/04 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 422 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,813 reads

Substring comprehension

Read more...
By dcawvive 2009/11/02 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 3,172 reads
   Items 1 to 20 of 1159    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,788 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,629 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,449 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use