SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag T-SQL Rss

   Items 1 to 20 of 3921    Older >>
 

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,336 reads

Manipulating Filetable Files Programatically

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer  Read more...
By Steve Jones 2019/01/18 (first published: 2016/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,893 reads

Reducing the Identity

By Steve Jones 2019/01/17 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 676 reads

Saving Data to Various Formats, Using SQL

You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.  Read more...
By Additional Articles 2019/01/17 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,829 reads

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR  Read more...
By Additional Articles 2019/01/17 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,086 reads

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.  Read more...
By Additional Articles 2019/01/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,007 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,336 reads

The Identity Select

By Steve Jones 2019/01/11 | Category: identity()
Rating: (not yet rated) |  Discuss |   Briefcase | 853 reads

Identity Property Fun

By Steve Jones 2019/01/10 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 784 reads

The Basics of iTVFs

Learn the basics of inline table valued functions in this short article.  Read more...
By Steve Jones 2019/01/10 | Source: SQLServerCentral.com | Category: itvf
Rating: |  Discuss |   Briefcase | 1,027 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2018/12/27 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,000 reads

Primary keys for an OLTP database

OLTP database performance with different clustered indexes.  Read more...
By Evgeny Garaev 2018/12/27 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 824 reads

The Bones of SQL - The Holiday Table

This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.  Read more...
By Bob Hovious 2018/12/25 (first published: 2016/09/19) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,457 reads

Christmas 2018 Trivia

By Steve Jones 2018/12/24 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 683 reads

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?  Read more...
By Mike Byrd 2018/12/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,504 reads

Invalid Parsename

By Steve Jones 2018/12/10 | Category: parsename()
Rating: (not yet rated) |  Discuss |   Briefcase | 726 reads

An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: string_split()
Rating: |  Discuss |   Briefcase | 1,477 reads

Finding the database

By Steve Jones 2018/12/06 | Category: parsename()
Rating: (not yet rated) |  Discuss |   Briefcase | 756 reads

Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.  Read more...
By Additional Articles 2018/12/05 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,939 reads

Fun addition

By Steve Jones 2018/12/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 976 reads
   Items 1 to 20 of 3921    Older >>
 
Tags
miscellaneous (498)    
maintenance and management (237)    
advanced querying (181)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (106)    
sql server 2005 (97)    
stored procedures (91)    
date manipulation (73)    
indexing (70)    
programming (60)    
string manipulation (56)    
backup and restore (52)    
blogs (49)    
aggregates (46)    
sql server 2008 (42)    
xml (41)    
security (38)    
sql puzzles (36)    
identity property (32)    
data warehousing (30)    
transactions (30)    
utility (28)    
views (28)    
cte (25)    
triggers (25)    
count() (23)    
datatypes (23)    
null (22)    
stairway series (22)    
user defined function (udf) (22)    
database design (21)    
maintenance (21)    
window functions (21)    
strategies (20)    
common table expressions (cte) (18)    
search (17)    
tally table (17)    
configuring (16)    
development (16)    
foreign keys (fk) (16)    
lock and connection management (16)    
pivot (16)    
sql server (16)    
temporary tables (16)    
computed columns (15)    
merge (15)    
coalesce() (14)    
datetime (14)    
datetime manipulation (14)    
editorial (14)    
monitoring (14)    
visual basic 6 (14)    
delete (13)    
error handling (13)    
humor (13)    
ado (12)    
dynamic sql (12)    
except (12)    
replication (12)    
cast and convert (11)    
execution plans (11)    
output clause (11)    
performance (11)    
round() (11)    
top (11)    
try_convert() (11)    
basics (10)    
collation (10)    
cursors (10)    
encryption (10)    
insert (10)    
like (10)    
recursion (10)    
sql server 2012 (10)    
truncate table (10)    
crosstab (9)    
group by (9)    
intersect (9)    
isnull (9)    
json (9)    
ranking functions (9)    
row_number() (9)    
sqlclr (9)    
case (8)    
implicit conversion (8)    
nums (8)    
order by (8)    
outer joins (8)    
select (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
table variables (8)    
tally (8)    
union (8)    
video (8)    
alter table (7)    
automated dba (7)    
column sets (7)    
constraints (7)    
counter (7)    
cross apply (7)    
delimited strings (7)    
grouping sets (7)    
integration services (ssis) (7)    
mail (7)    
management studio (ssms) (7)    
paging (7)    
parse (7)    
primary key (pk) (7)    
query answers with sql server (7)    
rand() (7)    
schemas (7)    
subquery (7)    
synonyms (7)    
sys.dm_db_partition_stats (7)    
tables (7)    
udf (7)    
update (7)    
.net (6)    
arrays (6)    
automation (6)    
best practices (6)    
check constraints (6)    
compress() (6)    
convert (6)    
date data types (6)    
function (6)    
isnumeric() (6)    
lead (6)    
patindex (6)    
powershell (6)    
scalar udf (6)    
sql-dmo (6)    
system development life cycle (6)    
table (6)    
try..catch (6)    
apply (5)    
charindex (5)    
checksum (5)    
cross join (5)    
data types (5)    
datetimeoffset (5)    
excel (5)    
filestream (5)    
hashbytes() (5)    
len (5)    
linked server (5)    
list indexes (5)    
over clause (5)    
quotename() (5)    
random numbers (5)    
reporting services (ssrs) (5)    
select into (5)    
set options (5)    
set-based (5)    
spatial data (5)    
sql server 2016 (5)    
string comparison (5)    
stuff() (5)    
table value constructor (5)    
xquery (5)    
analysis services (ssas) (4)    
analytic functions (4)    
auto-growth (4)    
backup (4)    
best and worst practices (4)    
columns (4)    
create table (4)    
data file management (4)    
datatype (4)    
date (4)    
datediff (4)    
ddl (4)    
design and theory (4)    
distinct (4)    
drop column (4)    
dts (4)    
etl (extract, transform, and load) (4)    
for xml path (4)    
formatting (4)    
friday poll (4)    
hierarchies (4)    
installation (4)    
join (4)    
joins (4)    
ntile (4)    
objects (4)    
openxml (4)    
output (4)    
permissions (4)    
precedence (4)    
replicate (4)    
routine database growth (4)    
routine growth (4)    
running totals (4)    
sql server 6.5 (4)    
str (4)    
sys.allocation_units (4)    
throw (4)    
truncate (4)    
tvp (4)    
unicode (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
advanced t-sql (3)    
agent jobs (3)    
alias (3)    
auditing (3)    
between (3)    
binary (3)    
bitwise operations (3)    
ceiling() (3)    
common language runtime (clr) (3)    
concat() (3)    
create sequence (3)    
csv (3)    
cube (3)    
database weekly (3)    
date conversion (3)    
dbcc checkident (3)    
dml (3)    
dmv (3)    
duplicate records (3)    
execute (3)    
fiscal year (3)    
float (3)    
floor() (3)    
full-text search (2005) (3)    
hierarchy (3)    
hierarchyid (3)    
inner join (3)    
isolation levels (3)    
lag (3)    
last_value (3)    
len() (3)    
linked servers (3)    
locking (3)    
max() (3)    
naming standards (3)    
openquery (3)    
percent_rank (3)    
performance testing (3)    
puzzle (3)    
regular expressions (3)    
restore (3)    
reverse (3)    
rollback (3)    
rollup (3)    
row count (3)    
script (3)    
scripting (3)    
scripts (3)    
sequence (3)    
soundex (3)    
sp_executesql (3)    
space usage (3)    
split (3)    
sql querying (3)    
sql server 2014 (3)    
sql_variant (3)    
statistics (data) (3)    
string (3)    
string function (3)    
string functions (3)    
strings (3)    
subqueries (3)    
substring (3)    
sudoku (3)    
sum (3)    
sum() (3)    
syntax (3)    
table valued function (tvf) (3)    
text matching (3)    
try_cast() (3)    
unit testing (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
age calculation (2)    
alter column (2)    
ansi_nulls (2)    
ascii (2)    
asp (2)    
azure (2)    
azure sql data warehouse (asdw) (2)    
azure sql database (2)    
bi (2)    
bigint (2)    
binary_checksum (2)    
bit data type (2)    
bitwise operators (2)    
blob manipulation (2)    
blocked process report (2)    
break (2)    
buffer cache (2)    
bulk insert (2)    
c# (2)    
calendar table (2)    
career (2)    
cascade (2)    
cascade deletes (2)    
cast (2)    
change detection (2)    
change tracking (2)    
checksum() (2)    
choose (2)    
comma seperated (2)    
conflict resolution (2)    
contest (2)    
context_info() (2)    
correlated subqueries (2)    
cursor (2)    
data generation (2)    
data integrity (2)    
data mining (2)    
data profiling (2)    
data warehouse (2)    
database (2)    
database dependencies (2)    
database mail (2)    
database size (2)    
databases (2)    
datalength (2)    
dateadd (2)    
datetime conversions (2)    
datetime functions (2)    
datetime2 (2)    
dbcc clonedatabase (2)    
dense_rank() (2)    
deterministic (2)    
distributed queries (2)    
editorial - mp3 (2)    
execute as (2)    
explain (2)    
extract, transform, load (etl) (2)    
first_value (2)    
format() (2)    
full join (2)    
game (2)    
games (2)    
geography (2)    
geometry (2)    
grant (2)    
grouping (2)    
having (2)    
hexadecimal (2)    
html (2)    
identity_insert (2)    
indexed views (2)    
information_schema (2)    
inline table valued function (itvf) (2)    
itvf (2)    
job history (2)    
joe celko (2)    
left() (2)    
list (2)    
logins (2)    
math (2)    
matrix (2)    
mdx (2)    
median (2)    
metadata (2)    
microsoft r services (2)    
mirroring (2)    
modulus (2)    
mssql (2)    
mysql (2)    
nested sets (2)    
news (2)    
newsequentialid() (2)    
nolock (2)    
nullif (2)    
nvarchar (2)    
objectproperty() (2)    
openjson (2)    
or (2)    
order (2)    
outer apply (2)    
over (2)    
pagination (2)    
parameters (2)    
parsename (2)    
parsename() (2)    
parsing delimited string (2)    
partition (2)    
partitioning (2)    
password (2)    
patrick leblanc (2)    
query optimizer (2)    
r language (2)    
raiserror (2)    
rank() (2)    
recursive function (2)    
replace() (2)    
row_number (2)    
rowversion (2)    
schemas+dtds (2)    
semaphore (2)    
sequence objects (2)    
set (2)    
set based (2)    
smtp (2)    
sparse columns (2)    
sql (2)    
sql agent (2)    
statistics (2)    
string_split() (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)    
table value constructor (tvc) (2)    
table valued parameters (tvp) (2)    
temporal tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tsqlt (2)    
tuning (2)    
union all (2)    
unique constraint (2)    
update() (2)    
user (2)    
user-defined functions (2)    
varchar (2)    
waitfor (2)    
where (2)    
worst practices (2)    
(cross) apply (1)    
@@datefirst (1)    
abs() (1)    
access (1)    
ace (1)    
active directory (1)    
actual execution plan (1)    
advanced (1)    
advantage (1)    
affinity (1)    
age (1)    
algorithm (1)    
alias data types (1)    
always on (1)    
analytics (1)    
and (1)    
ansi_warnings (1)    
array (1)    
assembly (1)    
async (1)    
at time zone (1)    
automatic (1)    
barcode (1)    
bcp (1)    
bcp (bulk copy program) (1)    
binary data (1)    
binary flags (1)    
bit operations (1)    
bitwise (1)    
bitwise and (1)    
bitwise operator (1)    
book reviews (1)    
boomerang (1)    
bug (1)    
built in function (1)    
bulk (1)    
bulk import (1)    
business days (1)    
business intelligence (1)    
calculation (1)    
calendar (1)    
cartesian product (1)    
case expression (1)    
case sensitive (1)    
case statement (1)    
certificates (1)    
changing (1)    
char (1)    
characters (1)    
checksum_agg (1)    
choose() (1)    
clean garbage data (1)    
closing balances (1)    
closure tables (1)    
cmdshell (1)    
coalesce (1)    
coaslece (1)    
colaesce (1)    
collationproperty() (1)    
column aliases (1)    
columnproperty() (1)    
columnstore index (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
compression (1)    
concatenate (1)    
conditional joins (1)    
configuration (1)    
connectivity (1)    
constants (1)    
conversion (1)    
conversions (1)    
converter (1)    
copying structure (1)    
copyright (1)    
correlation (1)    
cpu (1)    
create (1)    
create a folder (1)    
create database (1)    
create index (1)    
create type (1)    
create xml index (1)    
cryptography (1)    
cumulative (1)    
current activity (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data analysis (1)    
data dictionary (1)    
data manipulation (1)    
data mart (1)    
data pump task (1)    
data quality (1)    
data type (1)    
database development (1)    
database master key (dmk) (1)    
database mirroring (1)    
database performance (1)    
database restore (1)    
database restore history (1)    
datatype conversion (1)    
datatype conversion precedence (1)    
date calculations (1)    
date datatypes (1)    
date dimension (1)    
date functions (1)    
datepart (1)    
db_name() (1)    
dba (1)    
dbase (1)    
dbcc (1)    
ddl trigger (1)    
deadlocks (1)    
decimal (1)    
decimal datatype (1)    
declaration (1)    
declare (1)    
decompress() (1)    
deduplicate (1)    
default (1)    
default constraint (1)    
default constraints (1)    
defaults (1)    
defensive programming (1)    
delete rows (1)    
deleted (1)    
delta (1)    
denormalize (1)    
deny select (1)    
dependencies (1)    
dependency (1)    
deprecated features (1)    
derived table (1)    
derived tables (1)    
derivedtables (1)    
description (1)    
developers sql (1)    
diagnostic (1)    
difference (1)    
dimensional modeling (1)    
dm_db_index_physical_stats (1)    
dml triggers (1)    
documentation (1)    
dom (1)    
drives (1)    
drop constraint (1)    
dry (1)    
dsql (1)    
duplicate (1)    
duplicate data (1)    
duplicate indexes (1)    
duration (1)    
dwh (1)    
dynamic data masking (1)    
dynamic management functions (dmf) (1)    
dynamic query (1)    
dynamic t-sql code (1)    
easter sunday (1)    
editorial - ipod (1)    
editorial - wmv (1)    
effective dates (1)    
elements (1)    
ema (1)    
emonth (1)    
encode (1)    
encryptbypassphrase() (1)    
english query (1)    
enterprise (1)    
enterprise environment (1)    
eomonth() (1)    
error messages (1)    
error_message() (1)    
exclude pattern (1)    
exec() (1)    
exponents (1)    
expressions (1)    
extended properties (1)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
fifo queues (1)    
file copy (1)    
filegroups (1)    
filetable (1)    
financial rounding (1)    
find foreign key using sql (1)    
fiscal quarter (1)    
fn_listextendedproperty (1)    
for json (1)    
for xml (1)    
format (transact-sql) (1)    
fox (1)    
framing (1)    
functional dependency (1)    
fuzzy match (1)    
gdpr (1)    
general (1)    
generate scripts (1)    
generic sql (1)    
geo-replication (1)    
gettablename (1)    
gps (1)    
grantee (1)    
grantor (1)    
graphs (1)    
groouping (1)    
growth trend (1)    
guest user (1)    
guid (1)    
hash (1)    
hash match (1)    
hcf (1)    
hex (1)    
hexadecimal conversion numeric inline fast (1)    
high availability (ha) (1)    
hints (1)    
hipaa (1)    
histogram chart (1)    
history (1)    
holiday (1)    
holidays (1)    
humour (1)    
identifiers (1)    
identity (1)    
identity() (1)    
ids to table (1)    
iff (1)    
iif (transact-sql) (1)    
in operator (1)    
insert into (1)    
insert update stored procedure generation (1)    
inserted (1)    
int (1)    
internals (1)    
interstorm (1)    
inventory problem (1)    
ip addresses (1)    
ipv4 addresses (1)    
isnumber (1)    
iso (1)    
iso week (1)    
jaro winkler (1)    
javascript (1)    
kimball (1)    
lag function (1)    
large udt (1)    
lazy spool (1)    
left join (1)    
library (1)    
linked (1)    
local variables (1)    
logging (1)    
logic (1)    
logon triggers (1)    
lookup table (1)    
lookups (1)    
loop (1)    
macd (1)    
magnetic tape (1)    
management (1)    
mandelbrot (1)    
map (1)    
maximum capacity (1)    
mds (1)    
memory optimized tables (1)    
michael davis (1)    
microsoft azure (1)    
microsoft office (1)    
microsoft r server (1)    
min() (1)    
missing indexes (1)    
mobile devices (1)    
mod (1)    
modeling (1)    
moving average (1)    
msdb (1)    
mstvf (1)    
multi language (1)    
multi process (1)    
multi threaded (1)    
mutex (1)    
name value pairs (dictionary) data (1)    
network (1)    
new feature of sql server 2008 (1)    
newid (1)    
newid() (1)    
next 13th (1)    
n-grams (1)    
nitesh dedhia (1)    
nodes (1)    
nodes() (1)    
not in (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)    
numeric (1)    
object (1)    
object permissions (1)    
object_id (1)    
odbc functions (1)    
operator precedence (1)    
operators (1)    
optimization (1)    
options (1)    
oracle (1)    
ordering (1)    
ordinal rank (1)    
orm (1)    
other (1)    
ouput (1)    
paging data (1)    
palalelism (1)    
parallel (1)    
parallel processing (1)    
parameter (1)    
parameter sniffing (1)    
parameterized queries (1)    
parse() (1)    
partition by (1)    
partitioned sets (1)    
partitioned tables (1)    
pass virtual chapters (1)    
passwords (1)    
pattern exclude (1)    
pattern replace (1)    
pattern search (1)    
pdf (1)    
percentile rank (1)    
percentile_cont (1)    
percentile_disc (1)    
performance and tuning (1)    
performance comparison (1)    
permission (1)    
permutation (1)    
persisted (1)    
pl/sql (1)    
precision (1)    
prediction (1)    
primary key (1)    
prime (1)    
prime number (1)    
print (1)    
pro (1)    
procedural programming (1)    
procedure (1)    
process synchronization (1)    
product reviews (1)    
prompt (1)    
public (1)    
purge (1)    
qa-taskpad (1)    
queries (1)    
query (1)    
query compliation (1)    
query optimization (1)    
query plans (1)    
query processing (1)    
query tuning (1)    
queue processing (1)    
quick tip (1)    
r package (1)    
r studio (1)    
r tools for visual studio (1)    
raffle (1)    
random dates (1)    
range (1)    
rank distribution function (1)    
ratio (1)    
rbar (1)    
r-bar (1)    
real (1)    
rebind and rewinds (1)    
recompilation (1)    
recompile (1)    
record linkage (1)    
recursive cte (1)    
recursive queries (1)    
redgate (1)    
referential integrity (1)    
regex (1)    
relational databases (1)    
remote servers (1)    
rename (1)    
render (1)    
replace pattern (1)    
report (1)    
reserved words (1)    
return (1)    
revert (1)    
reviews (1)    
right join (1)    
role (1)    
rounding (1)    
routine (1)    
row compression (1)    
row constructor (1)    
rowcount (1)    
rows and range (1)    
rows to columns (1)    
rtrim (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
sargable (1)    
scd (1)    
schedulers (1)    
schema (1)    
scope of variables (1)    
scope_identity (1)    
script generator (1)    
select * (1)    
select query (1)    
selectivity (1)    
semi-additive measures (1)    
sequence object (1)    
sequence of letters (1)    
server (1)    
service broker (1)    
service packs (1)    
session_context() (1)    
set dateformat (1)    
set functions (1)    
set implicit transactions (1)    
set rowcount (1)    
sieve (1)    
sign() (1)    
similarity (1)    
simpson's paradox (1)    
single (1)    
slowly changing dimensions (1)    
sma (1)    
smalldatetime (1)    
software development (1)    
solo (1)    
some (1)    
sorting (1)    
source control (1)    
sp (1)    
sp_configure (1)    
sp_helptext (1)    
sp_helptext() (1)    
sp_msforeachdb (1)    
sp_rename (1)    
sp_sproc_columns (1)    
sp_who2 (1)    
sparse column sets (1)    
special characters (1)    
spherical coordinates (1)    
split delimited string. (1)    
split function (1)    
split string (1)    
split_string() (1)    
sql clr (1)    
sql dynamic search query (1)    
sql effective dates (1)    
sql effective start end dates (1)    
sql jobs (1)    
sql n-tuples (1)    
sql performance (1)    
sql prompt (1)    
sql script (1)    
sql search (1)    
sql server 2000 (1)    
sql server 2011 (1)    
sql server 2017 (1)    
sql server agent (1)    
sql startup parameters (1)    
sql2012 (1)    
sqlcmd (1)    
sqldom (1)    
sqlprep (1)    
star schemas (1)    
statistical analysis (mathematics) (1)    
storage management (1)    
stp_cleangarbagedata (1)    
stream (1)    
stress test (1)    
string formatting (1)    
string match (1)    
string operations (1)    
string splitter (1)    
string to table (1)    
string_escape() (1)    
strored procedure (1)    
structure (1)    
stuff (1)    
summer time (1)    
surround (1)    
survey (1)    
swap data (1)    
sybase (1)    
synonym (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_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
sys.dm_tran_session_transactions (1)    
sys.fn_physlocformatter (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.objects (1)    
sys.sql_modules (1)    
syscolumns (1)    
sysobjects (1)    
system tables (1)    
table field information (1)    
table function (1)    
table functions (1)    
table metadata (1)    
table spool operator (1)    
table to html conversion (1)    
table variable (1)    
tablediff utility (1)    
table-valued function (1)    
table-valued parameter (1)    
ted (1)    
tempdb (1)    
templates (1)    
temporary objects (1)    
test data (1)    
test-driven development (1)    
text manipulation (1)    
text mining (1)    
the (1)    
three valued logic (1)    
time (1)    
time calculation (1)    
time conversion (1)    
time duration (1)    
time zone (1)    
timestamp (1)    
tinyint (1)    
tips (1)    
tips & tricks (1)    
to us (1)    
tools (1)    
transaction (1)    
translate() (1)    
transparent data encryption (tde) (1)    
triangular joins (1)    
trigger (1)    
trim() (1)    
truncation (1)    
try_parse() (1)    
t-sql challenges (1)    
t-sql tuesday (1)    
tvf (1)    
twitter (1)    
type (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
unique (1)    
unique key (1)    
uniqueidentifier (1)    
unix (1)    
unpivot (1)    
unused (1)    
update with case (1)    
url (1)    
user defined functions (1)    
user defined table type (1)    
user groups (1)    
user-defined data types (1)    
user-defined function (1)    
user-defined table type (1)    
uuid (1)    
value (1)    
vardecimal (1)    
variable naming (1)    
variables (1)    
vb.net (1)    
visualizer (1)    
webinar (1)    
where clause (1)    
wildcard (1)    
wildcards (1)    
windowing functions (1)    
windows functions (1)    
with check option (1)    
without ssis (1)    
workdays (1)    
xml datasource (1)    
xp_cmdshell (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)