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
Articles with tag
T-SQL
Refine your search with one of the following additional tags (with number of items):
Advanced Querying
(168)
grouping sets
(3)
checksum
(1)
parallel processing
(1)
Miscellaneous
(104)
Naming Standards
(3)
Closing Balances
(1)
Parameterized Queries
(1)
SQL Server 7, 2000
(104)
Ranking Functions
(3)
constraints
(1)
Partitioned Tables
(1)
Performance Tuning
(74)
Spatial Data
(3)
copyright
(1)
procedural programming
(1)
Basic Querying
(68)
XSL
(3)
cross apply
(1)
Product Reviews
(1)
Stored Procedures
(62)
Alias
(2)
CROSS JOIN
(1)
RANDOM
(1)
Programming
(58)
ASP
(2)
Data Manipulation
(1)
Record Linkage
(1)
Administration
(57)
Auditing
(2)
Data Profiling
(1)
Recursive function
(1)
SQL Puzzles
(33)
Comma seperated
(2)
Data Quality
(1)
Regular Expressions
(1)
Strategies
(19)
Common Language Runtime (CLR)
(2)
DENY SELECT
(1)
Reporting
(1)
SQL Server 2008
(18)
Crosstab
(2)
DerivedTables
(1)
REVERT
(1)
User Defined Function (UDF)
(18)
CTE
(2)
Distributed Queries
(1)
Reviews
(1)
Configuring
(16)
Data Warehousing
(2)
DMV
(1)
Row Count
(1)
Database Design
(16)
Database Weekly
(2)
Editorial - iPod
(1)
ROW_NUMBER()
(1)
Security
(16)
Datetime Manipulation
(2)
Editorial - WMV
(1)
Running Totals
(1)
SQL Server 2005
(15)
Delimited Strings
(2)
English Query
(1)
Scripts
(1)
XML
(15)
Design and Theory
(2)
Error Handling
(1)
Search
(1)
Visual Basic 6
(14)
Editorial - MP3
(2)
Excel
(1)
SELECT *
(1)
ADO
(12)
Hierarchies
(2)
EXCEPT
(1)
Semaphore
(1)
Monitoring
(12)
HierarchyID
(2)
Execute AS
(1)
Semi-Additive measures
(1)
Triggers
(11)
Intersect
(2)
FILESTREAM
(1)
Service Packs
(1)
Basics
(10)
joe celko
(2)
Fiscal Year
(1)
Set Based
(1)
Date Manipulation
(8)
Matrix
(2)
function
(1)
Similarity
(1)
String Manipulation
(8)
News
(2)
Functional Dependency
(1)
solo
(1)
Video
(8)
Outer Joins
(2)
Fuzzy Match
(1)
split
(1)
Blogs
(6)
paging
(2)
GROUP BY
(1)
SQL Scripts
(1)
Common Table Expression (CTE)
(6)
parsing delimited string
(2)
IDENTITY
(1)
SQL Server
(1)
Indexing
(6)
pivot
(2)
INNER Join
(1)
SQL Server 2000
(1)
SQL-DMO
(6)
Recursion
(2)
insert
(1)
SQL Server Management Studio (SSMS)
(1)
System Development Life Cycle
(6)
Replication
(2)
Integration Services (SSIS)
(1)
SS2K5 - XML
(1)
Backup and Recovery
(5)
Schema
(2)
Inventory Problem
(1)
SSAS
(1)
Best Practices
(5)
Schemas/DTDs
(2)
IP Addresses
(1)
Star Schemas
(1)
Editorial
(5)
SQL Server 2005 - TSQL
(2)
IPv4 Addresses
(1)
Storage
(1)
.Net
(4)
Synonyms
(2)
Jaro Winkler
(1)
String Match
(1)
Aggregates
(4)
Tally Table
(2)
Javascript
(1)
SUBSTRING
(1)
Best and Worst Practices
(4)
UNION
(2)
JSON
(1)
Swap data
(1)
cursors
(4)
Views
(2)
Large UDT
(1)
Top
(1)
Data Types
(4)
Worst Practices
(2)
logging
(1)
Triangular Joins
(1)
delete
(4)
4-4-5 Accounting
(1)
Management Studio
(1)
Truncate
(1)
DTS
(4)
Advanced
(1)
MEDIAN
(1)
T-SQL Aids
(1)
Installation
(4)
Alias Data Types
(1)
MERGE
(1)
T-SQL Challenges
(1)
OpenXML
(4)
Analysis Services (SSAS)
(1)
meta data
(1)
UDF
(1)
SQL Server 6.5
(4)
Arrays
(1)
mobile devices
(1)
UniqueIdentifier
(1)
UpdateGrams
(4)
Backup / Restore
(1)
msdb
(1)
update
(1)
Development
(3)
BLOB Manipulation
(1)
ntile
(1)
WHERE
(1)
Dynamic SQL
(3)
Business Days
(1)
OUTER APPLY
(1)
xxxx
(1)
Search for
any
content tagged
T-SQL
Items 1 to 20 of 704
Next 20 >>
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
|
2,893 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
|
16,912 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,691 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
|
5,952 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,070 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,596 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
|
835 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,648 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,517 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,297 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
|
47,754 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,169 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,052 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,038 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,822 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
|
6,893 reads
Recursion with SQL Server 2008 within the Financial World
As most of you, we in the financial world have often been faced with the challenge of extracting data from relational sources that within the business frame of reference are more hierarchical in nature. Recently, I did what most of us do from time to.
Read more...
By
Stefaans
2009/09/17
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
864 reads
Deleting Large Number of Records
Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005
Read more...
By
Lynn Pettis
2009/09/15
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
18,307 reads
T-SQL Challenge #1
Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
Read more...
By
Jacob Sebastian
2009/09/14
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
4,129 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. (from Apr 2008)
Read more...
By
Stephen Lasham
2009/09/11 (first published: 2008/04/30)
|
Source:
SQLServerCentral.com
|
Category:
User Defined Function (UDF)
Rating:
|
Discuss
|
Briefcase
|
17,543 reads
Items 1 to 20 of 704
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,112 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,095 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,596 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use