Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag T-SQL Rss

   Items 1 to 20 of 3603    Older >>
 

OUTPUT Targets

By Steve Jones 2016/09/30 | Category: output clause
Rating: (not yet rated) |  Discuss |   Briefcase | 593 reads

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.  Read more...
By Tomaž Kaštrun 2016/09/29 | Source: SQLServerCentral.com | Category: r package
Rating: (not yet rated) |  Discuss |   Briefcase | 667 reads

Round averages

By Steve Jones 2016/09/29 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 936 reads

The Christmas CROSS APPLY

By Steve Jones 2016/09/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 872 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 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,235 reads

Complex foreign key

By Carlo Romagnano 2016/09/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,038 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2016/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,019 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 2016/09/19 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,886 reads

VALUES limit

By Steve Jones 2016/09/16 | Category: table value constructor
Rating: (not yet rated) |  Discuss |   Briefcase | 993 reads

Updating a View with CHECK

By Steve Jones 2016/09/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,080 reads

OUTPUT Target Table Restrictions

By Steve Jones 2016/09/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,119 reads

Plans for long rows

By Steve Jones 2016/09/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,069 reads

Small rounding

By Steve Jones 2016/09/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,259 reads

A Case FOR Cursors...

We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."  Read more...
By Chris Jones 2016/09/09 (first published: 2015/06/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 12,578 reads

Stupid Coding Tricks: The T-SQL Mandelbrot

The bar for entry into CodeSOD is pretty straight forward: professionally-developed code that elicits that certain What The— reaction. Though there have been a few exceptions over the years, generally speaking, student code, hobbyist code, and amateur code need not apply. That said, I'd like to try something a little different today. Today's example is not technically professionally-developed, it's a Stupid Coding Trick. "So I was bored at work one day," Graeme Job explains, "and wondered, what's the most useless thing I could do with my time without actually doing anything. Then it hit me. I could use T-SQL to generate... Mandelbrot." Graeme continued, "Following is a single T-SQL SELECT statement that generates a text-representation of a Mandelbrot Set. The results are best viewed in text-mode."  Read more...
By gogulatorul 2016/09/02 | Source: SQLServerCentral.com | Category: humor
Rating: |  Discuss |   Briefcase | 5,259 reads

Where's the error?

By Steve Jones 2016/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,386 reads

DDL and TRANSACTIONS

By Sergey Gigoyan 2016/08/30 | Category: transactions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,217 reads

Union Date/Time Data Types

By David Fundakowski 2016/08/26 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 1,256 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2016/08/26 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 14,054 reads

min Function (XQuery)

By Mikael Eriksson 2016/08/25 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,053 reads
   Items 1 to 20 of 3603    Older >>
 
Tags
miscellaneous (497)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (101)    
sql server 2005 (97)    
stored procedures (85)    
date manipulation (68)    
indexing (66)    
programming (60)    
string manipulation (55)    
backup and restore (50)    
blogs (49)    
sql server 2008 (42)    
xml (38)    
security (36)    
sql puzzles (36)    
aggregates (32)    
identity property (30)    
transactions (30)    
data warehousing (29)    
utility (27)    
views (27)    
cte (23)    
datatypes (23)    
triggers (23)    
stairway series (22)    
user defined function (udf) (22)    
maintenance (21)    
null (20)    
strategies (20)    
count() (19)    
common table expressions (cte) (18)    
database design (18)    
search (17)    
configuring (16)    
lock and connection management (16)    
pivot (16)    
development (15)    
foreign keys (fk) (15)    
tally table (15)    
window functions (15)    
computed columns (14)    
datetime (14)    
merge (14)    
monitoring (14)    
sql server (14)    
visual basic 6 (14)    
error handling (13)    
ado (12)    
coalesce (12)    
delete (12)    
dynamic sql (12)    
editorial (12)    
replication (12)    
datetime manipulation (11)    
except (11)    
execution plans (11)    
humor (11)    
temp tables (11)    
basics (10)    
collation (10)    
cursors (10)    
encryption (10)    
performance (10)    
recursion (10)    
top (10)    
truncate table (10)    
crosstab (9)    
insert (9)    
isnull (9)    
like (9)    
ranking functions (9)    
row_number() (9)    
sql server 2012 (9)    
case (8)    
intersect (8)    
nums (8)    
order by (8)    
output clause (8)    
round() (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
union (8)    
video (8)    
aggregate function (7)    
automated dba (7)    
cast and convert (7)    
constraints (7)    
counter (7)    
delimited strings (7)    
group by (7)    
mail (7)    
outer joins (7)    
paging (7)    
parse (7)    
schemas (7)    
select (7)    
sqlclr (7)    
subquery (7)    
synonyms (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
try_convert() (7)    
udf (7)    
update (7)    
arrays (6)    
automation (6)    
best practices (6)    
check constraints (6)    
convert (6)    
cross apply (6)    
integration services (ssis) (6)    
lead (6)    
management studio (ssms) (6)    
patindex (6)    
primary key (pk) (6)    
rand() (6)    
scalar udf (6)    
sql-dmo (6)    
system development life cycle (6)    
try..catch (6)    
.net (5)    
apply (5)    
charindex (5)    
checksum (5)    
cross join (5)    
excel (5)    
filestream (5)    
function (5)    
grouping sets (5)    
hashbytes (5)    
json (5)    
len (5)    
linked server (5)    
list indexes (5)    
random numbers (5)    
reporting services (ssrs) (5)    
select into (5)    
string comparison (5)    
table (5)    
alter table (4)    
analysis services (ssas) (4)    
auto-growth (4)    
best and worst practices (4)    
data file management (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 conversion (4)    
installation (4)    
isnumeric() (4)    
join (4)    
joins (4)    
ntile (4)    
openxml (4)    
over clause (4)    
permissions (4)    
replicate (4)    
routine database growth (4)    
routine growth (4)    
running totals (4)    
set options (4)    
set-based (4)    
spatial data (4)    
sql server 6.5 (4)    
str (4)    
sys.allocation_units (4)    
throw (4)    
truncate (4)    
tvp (4)    
unicode (4)    
updategrams (4)    
xquery (4)    
xsl (4)    
administrator (3)    
advanced t-sql (3)    
agent jobs (3)    
alias (3)    
auditing (3)    
backup (3)    
between (3)    
bitwise operations (3)    
columns (3)    
common language runtime (clr) (3)    
concat() (3)    
create sequence (3)    
create table (3)    
datatype (3)    
date conversion (3)    
dbcc checkident (3)    
dml (3)    
dmv (3)    
duplicate records (3)    
execute (3)    
fiscal year (3)    
float (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)    
powershell (3)    
precedence (3)    
regular expressions (3)    
reverse (3)    
rollback (3)    
script (3)    
scripting (3)    
sequence (3)    
soundex (3)    
sp_executesql (3)    
space usage (3)    
sql server 2014 (3)    
statistics (data) (3)    
stored procedure (3)    
string (3)    
string function (3)    
string functions (3)    
strings (3)    
stuff() (3)    
subqueries (3)    
substring (3)    
sum (3)    
syntax (3)    
table value constructor (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)    
alter column (2)    
analytic functions (2)    
analytical functions (2)    
ansi_nulls (2)    
asp (2)    
azure sql database (2)    
bi (2)    
bigint (2)    
binary_checksum (2)    
bit data type (2)    
bitwise operators (2)    
blob manipulation (2)    
break (2)    
buffer cache (2)    
bulk insert (2)    
c# (2)    
calendar table (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 size (2)    
database weekly (2)    
databases (2)    
datalength (2)    
date (2)    
datediff (2)    
datetime2 (2)    
dbcc clonedatabase (2)    
dense_rank() (2)    
distributed queries (2)    
editorial - mp3 (2)    
execute as (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)    
job history (2)    
joe celko (2)    
left() (2)    
list (2)    
logins (2)    
math (2)    
matrix (2)    
max() (2)    
mdx (2)    
median (2)    
microsoft r services (2)    
mirroring (2)    
mssql (2)    
mysql (2)    
nested sets (2)    
news (2)    
nolock (2)    
nullif (2)    
nvarchar (2)    
openjson (2)    
order (2)    
outer apply (2)    
output (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)    
rank() (2)    
recursive function (2)    
replace() (2)    
restore (2)    
row count (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)    
sql server 2016 (2)    
sql_variant (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)    
temporary tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tsqlt (2)    
tuning (2)    
union all (2)    
unique constraint (2)    
user (2)    
varchar (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)    
alias data types (1)    
alwayson (1)    
analytics (1)    
ansi_warnings (1)    
array (1)    
ascii (1)    
assembly (1)    
async (1)    
automatic (1)    
azure (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)    
career (1)    
cartesian product (1)    
case expression (1)    
case statement (1)    
ceiling() (1)    
certificates (1)    
changing (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)    
concatenate (1)    
conditional joins (1)    
configuration (1)    
connectivity (1)    
conversion (1)    
conversions (1)    
converter (1)    
copying structure (1)    
copyright (1)    
correlation (1)    
cpu (1)    
create (1)    
create a folder (1)    
create index (1)    
create type (1)    
cryptography (1)    
cube (1)    
cumulative (1)    
current activity (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data dictionary (1)    
data integrity (1)    
data manipulation (1)    
data mart (1)    
data pump task (1)    
data quality (1)    
data type (1)    
data types (1)    
database development (1)    
database mail (1)    
database mirroring (1)    
database performance (1)    
database restore (1)    
database restore history (1)    
datatype conversion (1)    
date calculations (1)    
date dimension (1)    
date functions (1)    
dateadd (1)    
datepart (1)    
datetime functions (1)    
db_name() (1)    
dba (1)    
dbase (1)    
dbcc (1)    
ddl triggers (1)    
deadlocks (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)    
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 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 stored procedures (1)    
factor (1)    
fall on friday (1)    
file copy (1)    
filegroups (1)    
filetable (1)    
financial rounding (1)    
find foreign key using sql (1)    
fiscal quarter (1)    
floor (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)    
identifiers (1)    
ids to table (1)    
iff (1)    
iif (transact-sql) (1)    
in (1)    
inline table valued function (itvf) (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)    
lookup table (1)    
lookups (1)    
loop (1)    
macd (1)    
magnetic tape (1)    
management (1)    
mandelbrot (1)    
map (1)    
mds (1)    
memory optimized tables (1)    
meta data (1)    
metadata (1)    
michael davis (1)    
microsoft azure (1)    
microsoft office (1)    
microsoft r server (1)    
missing indexes (1)    
mobile devices (1)    
modeling (1)    
modulo (1)    
modulus (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)    
object (1)    
object permissions (1)    
object_id (1)    
objects (1)    
odbc functions (1)    
operators (1)    
optimization (1)    
options (1)    
or (1)    
oracle (1)    
ordering (1)    
ordinal rank (1)    
orm (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)    
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)    
queue processing (1)    
quick tip (1)    
r package (1)    
r studio (1)    
r tools for visual studio (1)    
raffle (1)    
raiserror (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)    
slowly changing dimensions (1)    
sma (1)    
software development (1)    
solo (1)    
some (1)    
sorting (1)    
source control (1)    
sp (1)    
sp_configure (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)    
strored procedure (1)    
structure (1)    
stuff (1)    
sum() (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 zone (1)    
timestamp (1)    
tips (1)    
tips & tricks (1)    
to us (1)    
tools (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)    
update with case (1)    
url (1)    
user defined functions (1)    
user defined table type (1)    
user group (1)    
user-defined data types (1)    
user-defined functions (1)    
uuid (1)    
vardecimal (1)    
variable naming (1)    
vb.net (1)    
visualizer (1)    
waitfor (1)    
webinar (1)    
where (1)    
wildcard (1)    
wildcards (1)    
window aggregate function (1)    
window distribution function (1)    
with check option (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)