Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
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)
Basics
(10)
News
(2)
HierarchyID
(1)
Miscellaneous
(104)
Triggers
(8)
Replication
(2)
Outer Joins
(1)
SQL Server 7, 2000
(101)
Indexing
(6)
Schemas/DTDs
(2)
pivot
(1)
Basic Querying
(68)
SQL Server 2008
(6)
SQL Server 2005 - TSQL
(2)
Product Reviews
(1)
Stored Procedures
(60)
SQL-DMO
(6)
Worst Practices
(2)
Regular Expressions
(1)
Performance Tuning
(58)
Backup and Recovery
(5)
Administration
(1)
Reviews
(1)
Programming
(56)
System Development Life Cycle
(5)
Advanced
(1)
Scripts
(1)
Administering
(53)
.Net
(4)
Aggregates
(1)
Search
(1)
Performance Tuning and Scaling
(34)
DTS
(4)
Alias Data Types
(1)
Semaphore
(1)
SQL Puzzles
(31)
Installation
(4)
Analysis Services
(1)
Service Packs
(1)
Strategies
(19)
OpenXML
(4)
Best Practices
(1)
solo
(1)
Configuring
(16)
SQL Server 6.5
(4)
BLOB Manipulation
(1)
SQL Server 2000
(1)
Security
(15)
UpdateGrams
(4)
CLR Integration
(1)
SS2K5 - XML
(1)
Database Design
(14)
Best and Worst Practices
(3)
Data Types
(1)
String Manipulation
(1)
User-Defined functions
(14)
Naming Standards
(3)
Data Warehousing
(1)
Triangular Joins
(1)
Visual Basic 6
(14)
XSL
(3)
Datetime Manipulation
(1)
Truncate
(1)
Monitoring
(12)
ASP
(2)
delete
(1)
T-SQL Aids
(1)
XML
(12)
CTE
(2)
DerivedTables
(1)
UDF
(1)
ADO
(11)
Development
(2)
Distributed Queries
(1)
Video
(1)
SQL Server 2005
(11)
Dynamic SQL
(2)
English Query
(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,803 reads
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,537 reads
Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays
It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.
Read more...
By
Jeff Moden
2008/05/22
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
9 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
|
14 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,048 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
|
4,395 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,725 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
|
43,836 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,674 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,675 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,440 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,653 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,093 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,113 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
|
2,988 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,349 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,635 reads
How to Share Data Between Stored Procedures
Different ways of passing sets of data between stored procedures.
Read more...
By
Additional Articles
2008/04/08
|
Source:
Erland Sommarskog's SQL Page
|
Category:
Stored Procedures
Rating:
Rate this
|
Briefcase
|
5,747 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,630 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,616 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
|
43,836 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,085 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,430 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use