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

Content with tag T-SQL Rss

<< Newer    Items 41 to 60 of 3817    Older >>
 

Sending table form HTML emails from a SQL Server database engine

The solution which helps to smiplify delivery of a table content in the HTML form using Database mail  Read more...
By Evgeny Garaev 2018/01/29 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 1,537 reads

Basic COUNTs 2

By Steve Jones 2018/01/26 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,042 reads

The percent ranks

By Steve Jones 2018/01/25 | Category: percent_rank
Rating: (not yet rated) |  Discuss |   Briefcase | 857 reads

Basic COUNTs 1

By Steve Jones 2018/01/19 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,100 reads

GROUPING

By Steve Jones 2018/01/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,044 reads

T-SQL sorting

By Evgeny Garaev 2018/01/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,120 reads

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2018/01/05 (first published: 2016/06/07) | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 5,171 reads

SET the results

By Steve Jones 2018/01/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,121 reads

ReSETting the value

By Steve Jones 2017/12/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,078 reads

Securing Reporting Services Reports

Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.  Read more...
By Mohamed Idttalbe 2017/12/22 (first published: 2010/05/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,904 reads

What are the contents?

By Steve Jones 2017/12/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,162 reads

Holidays and Calendar Generation

Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.  Read more...
By Paul Hunter 2017/12/15 (first published: 2016/02/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,672 reads

Cube v rollup

By Steve Jones 2017/12/14 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 958 reads

Grouping

By Steve Jones 2017/12/12 | Category: group by
Rating: (not yet rated) |  Discuss |   Briefcase | 1,016 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,469 reads

Table variables

By Evgeny Garaev 2017/12/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,088 reads

Bones of SQL - Practical Calendar Queries

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.  Read more...
By Bob Hovious 2017/12/01 (first published: 2016/10/13) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,353 reads

The Difference Between Rollup and Cube

Learn about the fundamental differences between the ROLLUP and CUBE operators.  Read more...
By Ben Richardson 2017/11/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,516 reads

The Nonsensical Count

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

Game Day Planning

By Steve Jones 2017/11/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 936 reads
<< Newer    Items 41 to 60 of 3817    Older >>
 
Tags
miscellaneous (498)    
maintenance and management (237)    
advanced querying (181)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (105)    
sql server 2005 (97)    
stored procedures (87)    
date manipulation (71)    
indexing (67)    
programming (60)    
string manipulation (56)    
backup and restore (51)    
blogs (49)    
sql server 2008 (42)    
xml (40)    
security (38)    
sql puzzles (36)    
aggregates (35)    
data warehousing (30)    
identity property (30)    
transactions (30)    
views (28)    
utility (27)    
triggers (25)    
cte (24)    
count() (23)    
datatypes (23)    
null (22)    
stairway series (22)    
user defined function (udf) (22)    
maintenance (21)    
strategies (20)    
database design (19)    
window functions (19)    
common table expressions (cte) (18)    
search (17)    
configuring (16)    
development (16)    
foreign keys (fk) (16)    
lock and connection management (16)    
pivot (16)    
sql server (16)    
merge (15)    
tally table (15)    
coalesce() (14)    
computed columns (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)    
aggregate function (11)    
cast and convert (11)    
execution plans (11)    
output clause (11)    
temp tables (11)    
try_convert() (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)    
crosstab (9)    
group by (9)    
intersect (9)    
isnull (9)    
ranking functions (9)    
row_number() (9)    
sqlclr (9)    
case (8)    
json (8)    
nums (8)    
order by (8)    
select (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
union (8)    
video (8)    
automated dba (7)    
constraints (7)    
counter (7)    
cross apply (7)    
delimited strings (7)    
integration services (ssis) (7)    
mail (7)    
management studio (ssms) (7)    
outer joins (7)    
paging (7)    
parse (7)    
primary key (pk) (7)    
rand() (7)    
schemas (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)    
date data types (6)    
function (6)    
implicit conversions (6)    
isnumeric() (6)    
lead (6)    
patindex (6)    
powershell (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)    
set options (5)    
spatial data (5)    
sql server 2016 (5)    
string comparison (5)    
stuff() (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)    
data types (4)    
datatype (4)    
date (4)    
datediff (4)    
ddl (4)    
design and theory (4)    
distinct (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)    
set-based (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)    
bitwise operations (3)    
ceiling() (3)    
common language runtime (clr) (3)    
concat() (3)    
create sequence (3)    
cube (3)    
database weekly (3)    
date conversion (3)    
datetimeoffset (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)    
naming standards (3)    
openquery (3)    
percent_rank (3)    
performance testing (3)    
regular expressions (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)    
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)    
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)    
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 (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)    
compress() (2)    
conflict resolution (2)    
contest (2)    
context_info() (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 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)    
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)    
geometry (2)    
grant (2)    
grouping (2)    
having (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)    
or (2)    
order (2)    
outer apply (2)    
over (2)    
pagination (2)    
parsename (2)    
parsing delimited string (2)    
partition (2)    
password (2)    
patrick leblanc (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)    
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 value constructor (tvc) (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)    
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)    
alias data types (1)    
always on (1)    
analytics (1)    
and (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 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)    
compress (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)    
cryptography (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 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 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)    
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)    
geography (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 (1)    
hexadecimal conversion numeric inline fast (1)    
high availability (ha) (1)    
hints (1)    
hipaa (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 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)    
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)    
maximum capacity (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)    
name value pairs (dictionary) data (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)    
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 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)    
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)    
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 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)    
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 functions (1)    
table metadata (1)    
table spool operator (1)    
table to html conversion (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 conversion (1)    
time duration (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)    
trim() (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)    
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)    
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)