SQLServerCentral: Content tagged T-SQL

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Content with tag T-SQL

Items 1 to 20 of 1817 Next 20 >>

Stairway to T-SQL DML

This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server. Read more...

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly. Read more...

By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning

Rating:

|

Briefcase | 31,692 reads

HASHBYTES

By Steve Jones 2012/02/09 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,205 reads

TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state. Read more...

By Bret Lowery 2012/02/07 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 6,646 reads

TRUNCATE TABLE and ROLLBACK TRAN

By Craig Farrell 2012/02/06 | Category: recovery

Rating: (not yet rated) |

Briefcase | 1,736 reads

Aggregate Function Product()

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition. Read more...

By Paul McPherson 2012/02/06 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 7,242 reads

Do you know your getdate()?

This article takes a closer look at SQL Server getdate() and sysdatetime() functions. Read more...

By Jacek Osuchowski 2012/02/03 (first published: 2010/05/12) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 26,476 reads

Twist in ISNULL function

Be careful while using the ISNULL function Read more...

By Ashutosh Pandey 2012/02/02 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 22,346 reads

INSERT OUTPUT

By Steve Jones 2012/02/02 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,929 reads

Post a Twitter Status Update using T-SQL

Learn how to post a Twitter status update with 5 lines of T-SQL using a third party library. Read more...

By Michael Malmgren 2012/02/02 | Source: SQLServerCentral.com | Category: twitter

Rating:

|

Briefcase | 1,900 reads

Old Dog, New Tricks

Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well. Read more...

By Steve Jones 2012/02/02 | Source: SQLServerCentral.com | Category: editorial

Rating: (not yet rated) |

Briefcase | 310 reads

SET option hierarchy

By Sandip Pani 2012/02/01 | Category: set option

Rating: (not yet rated) |

Briefcase | 1,576 reads

Computed Columns 1

By bitbucket 2012/01/31 | Category: computed columns

Rating: (not yet rated) |

Briefcase | 1,769 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery

Rating: (not yet rated) |

Briefcase | 1,705 reads

Solving the Running Total and 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 2012/01/27 (first published: 2009/11/10) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 22,232 reads

Strings and Defaults

By Gail Shaw 2012/01/26 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,929 reads

Hashing

By Steve Jones 2012/01/24 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 1,981 reads

How to get monthly YTD data

This article presents an easy method to get YTD data grouped by months in T-SQL. Read more...

By Kautuk 2012/01/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 10,114 reads

Sub query expressions vs. Joins.

Do sub query expressions introduce a performance penalty on retrieving large data sets? Read more...

By Brian Ellul 2012/01/20 (first published: 2010/07/22) | Source: SQLServerCentral.com | Category: table spool operator

Rating:

|

Briefcase | 27,758 reads

Multiple Inserts

By Steve Jones 2012/01/17 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 2,201 reads

Items 1 to 20 of 1817 Next 20 >>

Tags

advanced querying (180)

miscellaneous (113)

sql server 7 (113)

administration (98)

sql server 2005 (95)

performance tuning (94)

stored procedures (77)

programming (60)

sql server 2008 (38)

date manipulation (36)

sql puzzles (36)

string manipulation (35)

t-sql aids (29)

indexing (28)

utility (27)

security (26)

maintenance and management (25)

xml (23)

maintenance (21)

user defined function (udf) (21)

blogs (20)

strategies (20)

aggregates (18)

database design (17)

configuring (16)

triggers (16)

cte (15)

development (15)

visual basic 6 (14)

data types (13)

identity (13)

monitoring (13)

search (13)

ado (12)

backup / restore (10)

basics (10)

pivot (10)

crosstab (9)

stairway series (9)

editorial (8)

nums (8)

recursion (8)

row_number() (8)

sqlinsider scripts (8)

storage (8)

table of numbers (8)

tally (8)

video (8)

automated dba (7)

common table expression (cte) (7)

counter (7)

delete (7)

delimited strings (7)

insert (7)

null (7)

sql spackle (7)

sys.dm_db_partition_stats (7)

tables (7)

tally table (7)

transactions (7)

arrays (6)

datetime manipulation (6)

foreign keys (fk) (6)

performance (6)

sql-dmo (6)

system development life cycle (6)

udf (6)

best practices (5)

computed column (5)

cursors (5)

datetime (5)

dynamic sql (5)

grouping sets (5)

list indexes (5)

merge (5)

output clause (5)

paging (5)

parse (5)

ranking functions (5)

select (5)

union (5)

views (5)

.net (4)

auto-growth (4)

automation (4)

best and worst practices (4)

data file management (4)

design and theory (4)

dts (4)

error handling (4)

except (4)

for xml path (4)

installation (4)

integration services (ssis) (4)

intersect (4)

linked server (4)

openxml (4)

order by (4)

routine database growth (4)

routine growth (4)

schema (4)

sql server 6.5 (4)

string comparison (4)

synonyms (4)

sys.allocation_units (4)

table (4)

truncate (4)

updategrams (4)

xsl (4)

administrator (3)

constraints (3)

convert (3)

data warehousing (3)

distinct (3)

execution plans (3)

function (3)

group by (3)

like (3)

management studio (ssms) (3)

naming standards (3)

performance testing (3)

replication (3)

running totals (3)

scalar-valued functions (3)

script (3)

space usage (3)

spatial data (3)

statistics (3)

temp tables (3)

text matching (3)

top (3)

2-dimensional arrays (2)

4-4-5 accounting (2)

alias (2)

analysis services (ssas) (2)

apply (2)

asp (2)

auditing (2)

between (2)

buffer cache (2)

checksum (2)

coalesce (2)

collation (2)

column (2)

comma seperated (2)

common language runtime (clr) (2)

common table expressions (2)

cross join (2)

database weekly (2)

date (2)

ddl (2)

dml (2)

dmv (2)

duplicate records (2)

editorial - mp3 (2)

encryption (2)

etl (2)

excel (2)

extract, transform, load (etl) (2)

fiscal year (2)

full join (2)

games (2)

grant (2)

hierarchies (2)

hierarchyid (2)

indexed views (2)

information_schema (2)

inner join (2)

isnull (2)

jobs (2)

joe celko (2)

join (2)

joins (2)

lock and connection management (2)

locking (2)

math (2)

matrix (2)

news (2)

ntile (2)

outer joins (2)

output (2)

pagination (2)

parsing delimited string (2)

permissions (2)

primary key (pk) (2)

puzzle (2)

random (2)

recursive function (2)

regular expressions (2)

reporting services (ssrs) (2)

reverse (2)

schemas/dtds (2)

scripting (2)

scripts (2)

smtp (2)

sql server (2)

sql server 2012 (2)

sql_variant (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)

tips & tricks (2)

troubleshooting (2)

t-sql dml (2)

tuning (2)

tvp (2)

update (2)

worst practices (2)

::fn_listextendedproperty (1)

@@error (1)

access (1)

active directory (1)

advanced (1)

alias data types (1)

alter table (1)

array (1)

backup (1)

backup/restore (1)

barcode (1)

bi (1)

bigint (1)

bitwise operators (1)

blob manipulation (1)

book reviews (1)

boomerang (1)

bug (1)

business days (1)

c# (1)

case (1)

cast and convert (1)

charindex (1)

check constraint (1)

check constraints (1)

clean garbage data (1)

closing balances (1)

clr functions (1)

clr stored procedures (1)

clr udt (1)

cmdshell (1)

column description wi sql (1)

column permissions (1)

common table expression (1)

compare data (1)

compare dataset (1)

comparing (1)

computed columns (1)

connectivity (1)

constraint (1)

contest (1)

conversion (1)

conversions (1)

copying structure (1)

copyright (1)

correlated subqueries (1)

count (1)

create (1)

cross apply (1)

csv (1)

cube (1)

current activity (1)

cursor (1)

data manipulation (1)

data mining (1)

data profiling (1)

data quality (1)

data warehouse (1)

database (1)

database mail (1)

database mirroring (1)

database size (1)

databases (1)

datatype (1)

date dimension (1)

dateadd (1)

datediff (1)

dba (1)

deadlock (1)

deduplicate (1)

default (1)

defensive programming (1)

delta (1)

dense_rank() (1)

deny select (1)

depreciated features (1)

derived table (1)

derivedtables (1)

description (1)

developers sql (1)

diagnostic (1)

dimensional modeling (1)

distributed queries (1)

dm_db_index_physical_stats (1)

documentation (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 (1)

execute as (1)

exponents (1)

extended stored procedures (1)

factor (1)

fall on friday (1)

filegroups (1)

filestream (1)

find foreign key using sql (1)

friday poll (1)

functional dependency (1)

fuzzy match (1)

generic sql (1)

geometry (1)

gettablename (1)

gps (1)

grantee (1)

grantor (1)

groouping (1)

grouping varchar columns (1)

growth trend (1)

guest user (1)

guid (1)

hash (1)

hashbytes (1)

hcf (1)

hexadecimal (1)

hexadecimal conversion numeric inline fast (1)

hierarchy (1)

history (1)

holiday (1)

humor (1)

ids to table (1)

implicit conversion (1)

insert update stored procedure generation (1)

interstorm (1)

inventory problem (1)

ip addresses (1)

ipv4 addresses (1)

isnumber (1)

isnumeric (1)

isolation level (1)

isolation levels (1)

jaro winkler (1)

javascript (1)

json (1)

kimball (1)

large udt (1)

left join (1)

len (1)

len() (1)

linked servers (1)

list (1)

local variables (1)

logging (1)

logins (1)

lookups (1)

macd (1)

magnetic tape (1)

maintenance and management sql server 2005 (1)

management (1)

max() (1)

mds (1)

mdx (1)

median (1)

meta data (1)

michael davis (1)

microsoft office (1)

missing indexes (1)

mobile devices (1)

modulus (1)

moving average (1)

msdb (1)

mstvf (1)

multi language (1)

multi process (1)

mutex (1)

network (1)

newid (1)

next 13th (1)

notification services (1)

nth occurance of day in a month/year (1)

nth occurrence of a weekday in a month and year (1)

numbers table (1)

object (1)

object permissions (1)

objects (1)

odbc functions (1)

operators (1)

or (1)

oracle (1)

ordinal rank (1)

outer apply (1)

over (1)

palalelism (1)

parallel (1)

parallel processing (1)

parameterized queries (1)

parameters (1)

partition by (1)

partitioned sets (1)

partitioned tables (1)

password (1)

patindex (1)

performance & optimization (1)

performance & optimization (1)

performance and tuning (1)

performance optimisation (1)

permission (1)

pl/sql (1)

powershell (1)

precision (1)

prime (1)

prime number (1)

procedural programming (1)

procedure (1)

product reviews (1)

public (1)

purge (1)

qa-taskpad (1)

query optimization (1)

query plans (1)

queue processing (1)

quick tip (1)

raffle (1)

random numbers (1)

range (1)

ranking (1)

ratio (1)

rebind and rewinds (1)

record linkage (1)

recovery (1)

referential integrity (1)

remote servers (1)

replace (1)

replicate (1)

report (1)

reporting (1)

restore (1)

revert (1)

reviews (1)

right join (1)

role (1)

rollback (1)

rollup (1)

round (1)

row count (1)

running aggregate (1)

running count (1)

sample chapters (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)

set option (1)

sieve (1)

similarity (1)

sma (1)

software development (1)

solo (1)

soundex (1)

source control (1)

sp (1)

sp_msforeachdb (1)

sp_who2 (1)

spherical coordinates (1)

split (1)

sql agent (1)

sql server 2000 (1)

sql server 2011 (1)

sql server agent (1)

sqlclr (1)

ss2k5 - xml (1)

star schemas (1)

stp_cleangarbagedata (1)

stress test (1)

string formatting (1)

string match (1)

string to table (1)

strings (1)

strored procedure (1)

structure (1)

subquery (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 functions (1)

table metadata (1)

table spool operator (1)

table valued function (1)

table variable (1)

table variables (1)

tablediff utility (1)

table-valued function (1)

ted (1)

temp table (1)

tempdb (1)

test-driven development (1)

time (1)

time zone (1)

to us (1)

tools (1)

triangular joins (1)

try-catch (1)

t-sql challenges (1)

twitter (1)

type (1)

ucc/ean (1)

undocumented stored procedures (1)

unicode (1)

unique (1)

uniqueidentifier (1)

url (1)

user (1)

user defined table type (1)

user group (1)

uuid (1)

varchar (1)

vb.net (1)

where (1)

window functions (1)

xquery (1)

zip codes (1)