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

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: (not yet rated) |  Discuss |  Briefcase | 56 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 | 3 reads

More Fun With NULL

Read more...
By John Arnott 2009/11/09 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 17 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: (not yet rated) |  Discuss |  Briefcase | 1 read

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: (not yet rated)  Rate this |  Briefcase | 3,089 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 | 17,059 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 | 386 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 | 3,729 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,001 reads

Substring comprehension

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

uniqueidentifier

Read more...
By VM-723206 2009/10/30 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 2,909 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,087 reads

Ultimate Alter Script generator

In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.  Read more...
By SQL Species 2009/10/30 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 527 reads

Identity Crisis

Read more...
By dun 2009/10/29 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 3,216 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 | 12,610 reads

Ceiling, Floor and Round!

Read more...
By VM-723206 2009/10/28 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 2,891 reads

DateTime Trick

Read more...
By Volkan Kuyucuoglu 2009/10/26 | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 3,364 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,324 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 | 837 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 | 39,660 reads
   Items 1 to 20 of 1149    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,119 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,102 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 | 12,610 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use