SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
Home Tags 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

   Items 1 to 20 of 1259    Next 20 >>
 

Intersect, Except, Union, All and Any

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.  Read more...
By David Poole 2010/05/21 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,325 reads

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,121 reads

SQL Server 2005 Paging – The Holy Grail

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.  Read more...
By Robert Cary 2010/05/07 (first published: 2009/03/11) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,473 reads

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |  Briefcase | 17,704 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2010/03/26 (first published: 2009/08/28) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 9,885 reads

Credit Card Number Validation Escalar Function

Evaluate credit card numbers based on ISO 2894 algorithm.  Read more...
By thor the viking 2010/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 45 reads

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.  Read more...
By Arshad Ali 2010/03/19 (first published: 2009/08/27) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 17,519 reads

An Urgent Ad Hoc Report

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.  Read more...
By Yakov Shlafman 2010/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 6,875 reads

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA: I need your input to derive the...  Read more...
By Robert Davis 2010/03/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 993 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: admin
Rating: |  Discuss |  Briefcase | 1,124 reads

T-SQL: Why “It Depends”

Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.   Read more...
By Bob Hovious 2010/03/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 8,736 reads

Beginning T-SQL 2008 - Book Review

A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger.  Read more...
By Beverley Beverley 2010/03/15 | Source: SQLServerCentral.com | Category: book reviews
Rating: |  Discuss |  Briefcase | 1,342 reads

What's the count?

Read more...
By Slick84 2010/03/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 3,098 reads

Breaking Down TempDB Contention

Breaking Down TempDB Contention  What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...  Read more...
By Robert Davis 2010/03/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 1,300 reads

COUNT_BIG

Read more...
By Prakriti Agrawal 2010/03/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 2,763 reads

Procedural, Semi-Procedural and Declarative Programming in SQL

A lot of the time, the key to making SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethinking in terms of a set-based declarative approach. Joe takes a simple discussion abut a problem with a UDF to illustrate the point that ingrained procedural reflexes can often prevent us from seeing simpler set-based techniques.  Read more...
By Additional Articles 2010/03/09 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |  Briefcase | 2,745 reads

Cast vs. Convert

Read more...
By Prakriti Agrawal 2010/03/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 3,466 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...
By Arshad Ali 2010/03/05 (first published: 2009/01/22) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 32,791 reads

Calculating Moving Averages with T-SQL

How to efficiently calculate moving averages with SQL Server using Stock Market data.  Read more...
By Gabriel Priester 2010/03/04 | Source: SQLServerCentral.com | Category: moving average
Rating: |  Discuss |  Briefcase | 9,176 reads

How many rows are returned from the query below?

Read more...
By Ashka Modi 2010/03/03 | Category: cte
Rating: (not yet rated) |  Discuss |  Briefcase | 2,892 reads
   Items 1 to 20 of 1259    Next 20 >>
 
Tags
advanced querying (180)    
sql server 7, 2000 (113)    
miscellaneous (112)    
administration (92)    
performance tuning (91)    
stored procedures (72)    
basic querying (68)    
programming (59)    
sql server 2005 (59)    
sql puzzles (36)    
sql server 2008 (27)    
t-sql aids (26)    
maintenance and management (25)    
utility (24)    
security (22)    
maintenance (21)    
user defined function (udf) (21)    
indexing (20)    
string manipulation (20)    
strategies (19)    
xml (17)    
configuring (16)    
database design (16)    
blogs (15)    
date manipulation (14)    
visual basic 6 (14)    
development (13)    
monitoring (13)    
triggers (13)    
ado (12)    
data types (12)    
search (12)    
admin (11)    
basics (10)    
indexes (10)    
aggregates (9)    
crosstab (9)    
index management (9)    
pivot (9)    
nums (8)    
sqlinsider scripts (8)    
storage (8)    
table of numbers (8)    
tally (8)    
video (8)    
automated dba (7)    
common table expression (cte) (7)    
counter (7)    
cte (7)    
delimited strings (7)    
sys.dm_db_partition_stats (7)    
tables (7)    
arrays (6)    
backup and recovery (6)    
datetime manipulation (6)    
sql-dmo (6)    
system development life cycle (6)    
best practices (5)    
delete (5)    
editorial (5)    
identity (5)    
list indexes (5)    
null (5)    
parse (5)    
.net (4)    
auto-growth (4)    
best and worst practices (4)    
cursors (4)    
data file management (4)    
design and theory (4)    
dts (4)    
dynamic sql (4)    
for xml path (4)    
installation (4)    
linked server (4)    
openxml (4)    
recursion (4)    
routine database growth (4)    
routine growth (4)    
sql server 6.5 (4)    
string comparison (4)    
synonyms (4)    
sys.allocation_units (4)    
truncate (4)    
updategrams (4)    
views (4)    
administrator (3)    
automation (3)    
data warehousing (3)    
function (3)    
grouping sets (3)    
naming standards (3)    
performance testing (3)    
ranking functions (3)    
replication (3)    
running totals (3)    
space usage (3)    
spatial data (3)    
table (3)    
tally table (3)    
text matching (3)    
udf (3)    
xsl (3)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
alias (2)    
asp (2)    
auditing (2)    
backup / restore (2)    
buffer cache (2)    
checksum (2)    
column (2)    
comma seperated (2)    
common language runtime (clr) (2)    
database weekly (2)    
datetime (2)    
ddl (2)    
dmv (2)    
duplicate records (2)    
editorial - mp3 (2)    
error handling (2)    
etl (2)    
excel (2)    
except (2)    
extract, transform, load (etl) (2)    
fiscal year (2)    
foreign keys (2)    
games (2)    
grant (2)    
group by (2)    
hierarchies (2)    
hierarchyid (2)    
index usage (2)    
indexed views (2)    
intersect (2)    
joe celko (2)    
like (2)    
lock and connection management (2)    
locking (2)    
matrix (2)    
merge (2)    
news (2)    
outer joins (2)    
paging (2)    
parsing delimited string (2)    
performance (2)    
permissions (2)    
puzzle (2)    
reverse (2)    
scalar-valued functions (2)    
schema (2)    
schemas/dtds (2)    
scripting (2)    
scripts (2)    
select (2)    
sql scripts (2)    
sql server (2)    
sql server 2005 - tsql (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
temp tables (2)    
top (2)    
troubleshooting (2)    
union (2)    
worst practices (2)    
::fn_listextendedproperty (1)    
active directory (1)    
advanced (1)    
alias data types (1)    
alter table (1)    
analysis services (ssas) (1)    
backup (1)    
barcode (1)    
bitwise operators (1)    
blob manipulation (1)    
book reviews (1)    
bug (1)    
business days (1)    
cast and convert (1)    
closing balances (1)    
clr functions (1)    
clr stored procedures (1)    
clr udt (1)    
cmdshell (1)    
coalesce (1)    
column description wi sql (1)    
column permissions (1)    
common table expressions (1)    
comparing (1)    
computed column (1)    
constraints (1)    
conversion (1)    
conversions (1)    
copyright (1)    
correlated subqueries (1)    
count (1)    
cross apply (1)    
cross join (1)    
data manipulation (1)    
data mining (1)    
data profiling (1)    
data quality (1)    
databases (1)    
dba (1)    
deadlock (1)    
default (1)    
deny select (1)    
derivedtables (1)    
description (1)    
distributed queries (1)    
dm_db_index_physical_stats (1)    
drives (1)    
drop column (1)    
dsql (1)    
duplicate indexes (1)    
editorial - ipod (1)    
editorial - wmv (1)    
ema (1)    
encode (1)    
english query (1)    
execute as (1)    
exponents (1)    
extended stored procedures (1)    
fall on friday (1)    
filestream (1)    
find foreign key using sql (1)    
foreign key (1)    
foreign key constraints (1)    
functional dependency (1)    
fuzzy match (1)    
geometry (1)    
gps (1)    
grouping varchar columns (1)    
growth trend (1)    
guest user (1)    
guid (1)    
hash (1)    
hexadecimal (1)    
holiday (1)    
humor (1)    
ids to table (1)    
implicit conversion (1)    
index tuning (1)    
inner join (1)    
insert (1)    
insert update stored procedure generation (1)    
integration services (ssis) (1)    
inventory problem (1)    
ip addresses (1)    
ipv4 addresses (1)    
isnull (1)    
isnumeric (1)    
isolation level (1)    
isolation levels (1)    
jaro winkler (1)    
javascript (1)    
jobs (1)    
json (1)    
large udt (1)    
len() (1)    
local variables (1)    
logging (1)    
logins (1)    
lookups (1)    
macd (1)    
maintenance and management sql server 2005 (1)    
management (1)    
management studio (1)    
mdx (1)    
median (1)    
meta data (1)    
mirror (1)    
missing indexes (1)    
mobile devices (1)    
moving average (1)    
msdb (1)    
multi process (1)    
network (1)    
newid (1)    
next 13th (1)    
nth occurance of day in a month/year (1)    
nth occurrence of a weekday in a month and year (1)    
ntile (1)    
object (1)    
object permissions (1)    
objects (1)    
operators (1)    
order by (1)    
ordinal rank (1)    
outer apply (1)    
output (1)    
output clause (1)    
parallel (1)    
parallel processing (1)    
parameterized queries (1)    
parameters (1)    
partitioned tables (1)    
performance & optimization (1)    
prime (1)    
prime number (1)    
procedural programming (1)    
procedure (1)    
product reviews (1)    
public (1)    
qa-taskpad (1)    
query optimization (1)    
quick tip (1)    
random (1)    
random numbers (1)    
record linkage (1)    
recursive function (1)    
referential integrity (1)    
regular expressions (1)    
replicate (1)    
report (1)    
reporting (1)    
restore (1)    
revert (1)    
reviews (1)    
role (1)    
rollback (1)    
row count (1)    
row_number() (1)    
running aggregate (1)    
script (1)    
script generator (1)    
select * (1)    
selectivity (1)    
semaphore (1)    
semi-additive measures (1)    
service broker (1)    
service packs (1)    
set based (1)    
set functions (1)    
sieve (1)    
similarity (1)    
sma (1)    
solo (1)    
source control (1)    
sp_msforeachdb (1)    
spherical coordinates (1)    
split (1)    
sql (1)    
sql permissions (1)    
sql query (1)    
sql script (1)    
sql server 2000 (1)    
sql server 2005 / sql server 2008 (1)    
sql server management studio (ssms) (1)    
sqlagent (1)    
ss2k5 - xml (1)    
ssas (1)    
star schemas (1)    
stored procedure (1)    
stored procedure template (1)    
string formatting (1)    
string match (1)    
string to table (1)    
strings (1)    
structure (1)    
substring (1)    
swap data (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
sys.fn_physlocformatter (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
syscolumns (1)    
sysobjects (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
table valued function (1)    
tempdb (1)    
tips & tricks (1)    
tools (1)    
transactions (1)    
triangular joins (1)    
try-catch (1)    
t-sql challenges (1)    
tvp (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
uniqueidentifier (1)    
update (1)    
url (1)    
user (1)    
user defined table type (1)    
uuid (1)    
varchar (1)    
where (1)    
xxxx (1)    
zip codes (1)    
 
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use