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

Content with tag T-SQL Rss

<< Newer    Items 21 to 40 of 3735    Older >>
 

The Floor

By Steve Jones 2017/07/31 | Category: floor()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,034 reads

Converting XML

By Steve Jones 2017/07/28 | Category: try_convert()
Rating: (not yet rated) |  Discuss |   Briefcase | 852 reads

Statistics in SQL: The Kruskal–Wallis Test

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.  Read more...
By Additional Articles 2017/07/27 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,901 reads

The Current Date

By Steve Jones 2017/07/25 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 979 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.  Read more...
By Additional Articles 2017/07/25 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,548 reads

SQL Server User-Defined Functions

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.  Read more...
By Additional Articles 2017/07/21 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,321 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2017/07/19 (first published: 2015/10/21) | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,457 reads

Simple SQL: Attribute Splitting

If the design of a relational database is wrong, no amount of clever DML SQL will make it work well. Dr. Codd’s Information Principle is that you have, inside the entity tables, the columns that model the attributes of that entity. The columns contain scalar values. Tables that model relationships can have attributes, but they must have references to entities in the schema. You split those attributes at your peril. Joe Celko explains the basics.  Read more...
By Additional Articles 2017/07/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,613 reads

The Missing Price

By Steve Jones 2017/07/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,164 reads

Comparing with SQL_VARIANT

By Thomas Franz 2017/07/14 | Category: sql_variant
Rating: (not yet rated) |  Discuss |   Briefcase | 861 reads

TRY_CONVERT and IsNumeric

By Steve Jones 2017/07/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 922 reads

Dropping PKs

By Steve Jones 2017/07/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,099 reads

The Panjandrum Conundrum

With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.  Read more...
By Phil Factor 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads

Dynamic SQL

By Stewart Campbell 2017/07/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,160 reads

The Basics of Good T-SQL Coding Style

TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.  Read more...
By Additional Articles 2017/07/05 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,811 reads

@@rowcount and the OUTPUT clause

By Matt Crowley 2017/06/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 992 reads

SQL Server Row Count for all Tables in a Database

Dattatrey Sindol explains the different ways in which you can get the row counts from all the tables in a SQL Server database.  Read more...
By Additional Articles 2017/06/22 | Source: MSSQLTips.com | Category: row count
Rating: (not yet rated)  Rate this |   Briefcase | 5,253 reads

OUTPUT clause with an update

By Carlo Romagnano 2017/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,028 reads

Raiserror options

By Steve Jones 2017/06/20 | Category: raiserror
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

Use T-SQL to Find Folders Using the Most Disk Space

Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.  Read more...
By Additional Articles 2017/06/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,709 reads
<< Newer    Items 21 to 40 of 3735    Older >>
 
Tags
miscellaneous (498)    
maintenance and management (237)    
advanced querying (181)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (104)    
sql server 2005 (97)    
stored procedures (87)    
date manipulation (69)    
indexing (67)    
programming (60)    
string manipulation (55)    
backup and restore (51)    
blogs (49)    
sql server 2008 (42)    
xml (40)    
security (38)    
sql puzzles (36)    
aggregates (33)    
data warehousing (30)    
identity property (30)    
transactions (30)    
views (28)    
utility (27)    
triggers (25)    
cte (23)    
datatypes (23)    
null (22)    
stairway series (22)    
user defined function (udf) (22)    
maintenance (21)    
strategies (20)    
count() (19)    
database design (19)    
window functions (19)    
common table expressions (cte) (18)    
search (17)    
configuring (16)    
development (16)    
lock and connection management (16)    
pivot (16)    
foreign keys (fk) (15)    
merge (15)    
sql server (15)    
tally table (15)    
computed columns (14)    
datetime (14)    
editorial (14)    
monitoring (14)    
visual basic 6 (14)    
coalesce (13)    
delete (13)    
error handling (13)    
ado (12)    
datetime manipulation (12)    
dynamic sql (12)    
except (12)    
humor (12)    
replication (12)    
aggregate function (11)    
execution plans (11)    
output clause (11)    
temp tables (11)    
basics (10)    
collation (10)    
cursors (10)    
encryption (10)    
insert (10)    
like (10)    
performance (10)    
recursion (10)    
round() (10)    
sql server 2012 (10)    
top (10)    
truncate table (10)    
cast and convert (9)    
crosstab (9)    
intersect (9)    
isnull (9)    
ranking functions (9)    
row_number() (9)    
sqlclr (9)    
try_convert() (9)    
case (8)    
nums (8)    
order by (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
union (8)    
video (8)    
automated dba (7)    
constraints (7)    
counter (7)    
delimited strings (7)    
group by (7)    
mail (7)    
outer joins (7)    
paging (7)    
parse (7)    
primary key (pk) (7)    
schemas (7)    
select (7)    
subquery (7)    
synonyms (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
udf (7)    
update (7)    
.net (6)    
arrays (6)    
automation (6)    
best practices (6)    
check constraints (6)    
convert (6)    
cross apply (6)    
function (6)    
integration services (ssis) (6)    
isnumeric() (6)    
json (6)    
lead (6)    
management studio (ssms) (6)    
patindex (6)    
powershell (6)    
rand() (6)    
scalar udf (6)    
sql-dmo (6)    
system development life cycle (6)    
try..catch (6)    
apply (5)    
charindex (5)    
checksum (5)    
cross join (5)    
excel (5)    
filestream (5)    
grouping sets (5)    
hashbytes() (5)    
len (5)    
linked server (5)    
list indexes (5)    
over clause (5)    
random numbers (5)    
reporting services (ssrs) (5)    
select into (5)    
spatial data (5)    
string comparison (5)    
table (5)    
table value constructor (5)    
xquery (5)    
alter table (4)    
analysis services (ssas) (4)    
auto-growth (4)    
backup (4)    
best and worst practices (4)    
columns (4)    
create table (4)    
data file management (4)    
datatype (4)    
date data types (4)    
ddl (4)    
design and theory (4)    
distinct (4)    
dts (4)    
etl (4)    
for xml path (4)    
friday poll (4)    
hierarchies (4)    
implicit conversions (4)    
installation (4)    
join (4)    
joins (4)    
ntile (4)    
objects (4)    
openxml (4)    
output (4)    
permissions (4)    
replicate (4)    
routine database growth (4)    
routine growth (4)    
running totals (4)    
set options (4)    
set-based (4)    
sql server 2016 (4)    
sql server 6.5 (4)    
str (4)    
stuff() (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)    
bitwise operations (3)    
ceiling() (3)    
common language runtime (clr) (3)    
concat() (3)    
create sequence (3)    
data types (3)    
database weekly (3)    
date conversion (3)    
datediff (3)    
dbcc checkident (3)    
dml (3)    
dmv (3)    
duplicate records (3)    
execute (3)    
fiscal year (3)    
float (3)    
floor() (3)    
formatting (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)    
naming standards (3)    
openquery (3)    
performance testing (3)    
precedence (3)    
regular expressions (3)    
reverse (3)    
rollback (3)    
row count (3)    
script (3)    
scripting (3)    
sequence (3)    
soundex (3)    
sp_executesql (3)    
space usage (3)    
sql server 2014 (3)    
sql_variant (3)    
statistics (data) (3)    
stored procedure (3)    
string (3)    
string function (3)    
string functions (3)    
strings (3)    
subqueries (3)    
substring (3)    
sum (3)    
sum() (3)    
syntax (3)    
table valued function (tvf) (3)    
text matching (3)    
unit testing (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
age calculation (2)    
alter column (2)    
analytic functions (2)    
analytical functions (2)    
ansi_nulls (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)    
correlated subqueries (2)    
csv (2)    
cursor (2)    
data generation (2)    
data mining (2)    
data profiling (2)    
data warehouse (2)    
database (2)    
database dependencies (2)    
database size (2)    
databases (2)    
datalength (2)    
date (2)    
dateadd (2)    
datetime conversions (2)    
datetime2 (2)    
dbcc clonedatabase (2)    
dense_rank() (2)    
distributed queries (2)    
editorial - mp3 (2)    
execute as (2)    
explain (2)    
extract, transform, load (etl) (2)    
first_value (2)    
full join (2)    
game (2)    
games (2)    
geometry (2)    
grant (2)    
identity_insert (2)    
indexed views (2)    
information_schema (2)    
inline table valued function (itvf) (2)    
job history (2)    
joe celko (2)    
left() (2)    
list (2)    
logins (2)    
math (2)    
matrix (2)    
max() (2)    
mdx (2)    
median (2)    
metadata (2)    
microsoft r services (2)    
mirroring (2)    
modulus (2)    
mssql (2)    
mysql (2)    
nested sets (2)    
news (2)    
nolock (2)    
nullif (2)    
nvarchar (2)    
objectproperty() (2)    
openjson (2)    
order (2)    
outer apply (2)    
over (2)    
pagination (2)    
parsename (2)    
parsing delimited string (2)    
partition (2)    
password (2)    
patrick leblanc (2)    
percent_rank (2)    
puzzle (2)    
query optimizer (2)    
r language (2)    
raiserror (2)    
rank() (2)    
recursive function (2)    
replace() (2)    
restore (2)    
row_number (2)    
rowversion (2)    
schemas/dtds (2)    
scripts (2)    
semaphore (2)    
sequence objects (2)    
set (2)    
set based (2)    
smtp (2)    
sparse columns (2)    
split (2)    
sql agent (2)    
statistics (2)    
sudoku (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 valued parameters (tvp) (2)    
temp table (2)    
temporal tables (2)    
temporary tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tsqlt (2)    
tuning (2)    
union all (2)    
unique constraint (2)    
user (2)    
user-defined functions (2)    
varchar (2)    
waitfor (2)    
worst practices (2)    
(cross) apply (1)    
::fn_listextendedproperty (1)    
@@datefirst (1)    
abs() (1)    
access (1)    
ace (1)    
active directory (1)    
actual execution plan (1)    
advanced (1)    
advantage (1)    
affinity (1)    
age (1)    
alias data types (1)    
always on (1)    
analytics (1)    
ansi_warnings (1)    
array (1)    
ascii (1)    
assembly (1)    
async (1)    
at time zone (1)    
automatic (1)    
backup/restore (1)    
barcode (1)    
bcp (bulk copy program) (1)    
binary (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 statement (1)    
certificates (1)    
changing (1)    
char (1)    
characters (1)    
checksum_agg (1)    
choose() (1)    
clean garbage data (1)    
closing balances (1)    
cmdshell (1)    
coaslece (1)    
colaesce (1)    
collationproperty() (1)    
column aliases (1)    
columnproperty() (1)    
columnstore index (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
compress (1)    
compress() (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)    
cryptography (1)    
cube (1)    
cumulative (1)    
current activity (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data analysis (1)    
data dictionary (1)    
data integrity (1)    
data manipulation (1)    
data mart (1)    
data pump task (1)    
data quality (1)    
data type (1)    
database development (1)    
database mail (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)    
datetime functions (1)    
datetimeoffset (1)    
db_name() (1)    
dba (1)    
dbase (1)    
dbcc (1)    
ddl triggers (1)    
deadlocks (1)    
decimal (1)    
decimal datatype (1)    
declaration (1)    
declare (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)    
derivedtables (1)    
description (1)    
deterministic (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 column (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)    
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)    
for xml (1)    
format (transact-sql) (1)    
fox (1)    
framing (1)    
functional dependency (1)    
fuzzy match (1)    
general (1)    
generate scripts (1)    
generic sql (1)    
geography (1)    
geo-replication (1)    
gettablename (1)    
gps (1)    
grantee (1)    
grantor (1)    
graphs (1)    
groouping (1)    
grouping (1)    
grouping varchar columns (1)    
growth trend (1)    
guest user (1)    
guid (1)    
hash (1)    
hash match (1)    
having (1)    
hcf (1)    
hex (1)    
hexadecimal (1)    
hexadecimal conversion numeric inline fast (1)    
high availability (ha) (1)    
hints (1)    
histogram chart (1)    
history (1)    
holiday (1)    
holidays (1)    
html (1)    
humour (1)    
identifiers (1)    
ids to table (1)    
iff (1)    
iif (transact-sql) (1)    
in (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)    
itvf (1)    
jaro winkler (1)    
javascript (1)    
kimball (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)    
mds (1)    
memory optimized tables (1)    
michael davis (1)    
microsoft azure (1)    
microsoft office (1)    
microsoft r server (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)    
network (1)    
new feature of sql server 2008 (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)    
or (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)    
parameters (1)    
partition by (1)    
partitioned sets (1)    
partitioned tables (1)    
partitioning (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)    
permission (1)    
permutation (1)    
persisted (1)    
pl/sql (1)    
precision (1)    
prediction (1)    
prime (1)    
prime number (1)    
print (1)    
pro (1)    
procedural programming (1)    
process synchronization (1)    
product reviews (1)    
public (1)    
purge (1)    
qa-taskpad (1)    
queries (1)    
query (1)    
query compliation (1)    
query optimization (1)    
query plans (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)    
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)    
rollup (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)    
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)    
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)    
software development (1)    
solo (1)    
some (1)    
sorting (1)    
source control (1)    
sp (1)    
sp_configure (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)    
sql (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 script (1)    
sql search (1)    
sql server 2000 (1)    
sql server 2011 (1)    
sql server agent (1)    
sql startup parameters (1)    
sqldom (1)    
sqlprep (1)    
ssms (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 functions (1)    
table metadata (1)    
table spool operator (1)    
table variable (1)    
tablediff utility (1)    
table-valued function (1)    
ted (1)    
tempdb (1)    
templates (1)    
temporary objects (1)    
test data (1)    
test-driven development (1)    
text manipulation (1)    
text mining (1)    
three valued logic (1)    
time (1)    
time calculation (1)    
time zone (1)    
timestamp (1)    
tips (1)    
tips &amp; tricks (1)    
to us (1)    
tools (1)    
transaction (1)    
transparent data encryption (tde) (1)    
triangular joins (1)    
trigger (1)    
truncation (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)    
uuid (1)    
value (1)    
vardecimal (1)    
variable naming (1)    
variables (1)    
vb.net (1)    
visualizer (1)    
webinar (1)    
where (1)    
wildcard (1)    
wildcards (1)    
with check option (1)    
without ssis (1)    
workdays (1)    
xp_cmdshell (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)