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

Content with tag T-SQL Rss

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

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2016/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,342 reads

Default OPENJSON

By Steve Jones 2016/06/13 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 1,128 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,925 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2016/06/10 (first published: 2015/04/02) | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 19,979 reads

The altered view

By Steve Jones 2016/06/09 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,334 reads

The Last Order

By Steve Jones 2016/06/07 | Category: last_value
Rating: (not yet rated) |  Discuss |   Briefcase | 1,260 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 2016/06/07 | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 3,324 reads

ISJSON

By Igor Micev 2016/06/06 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 982 reads

Beginning a CTE

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

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,885 reads

Inserting XML

By Steve Jones 2016/06/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,354 reads

Implicit Conversion

By Sasidhar Pulivarthi 2016/05/31 | Category: union
Rating: (not yet rated) |  Discuss |   Briefcase | 1,470 reads

Variable datatype DDL

By Steve Jones 2016/05/30 | Category: ddl
Rating: (not yet rated) |  Discuss |   Briefcase | 1,283 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,490 reads

SUM()

By Sasidhar Pulivarthi 2016/05/20 | Category: sum
Rating: (not yet rated) |  Discuss |   Briefcase | 1,597 reads

Partition elimination and variables

By Thomas Franz 2016/05/19 | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,081 reads

Except

By Sasidhar Pulivarthi 2016/05/18 | Category: except
Rating: (not yet rated) |  Discuss |   Briefcase | 1,484 reads

Binary Compare

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

A Scary Day

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

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2016/05/13 (first published: 2014/03/04) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 12,498 reads
<< Newer    Items 21 to 40 of 3565    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)    
indexing (66)    
date manipulation (64)    
programming (60)    
string manipulation (55)    
backup and restore (50)    
blogs (49)    
sql server 2008 (42)    
xml (37)    
security (36)    
sql puzzles (36)    
aggregates (32)    
identity property (30)    
data warehousing (29)    
transactions (28)    
utility (27)    
views (24)    
triggers (23)    
cte (22)    
datatypes (22)    
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)    
computed columns (14)    
datetime (14)    
merge (14)    
monitoring (14)    
sql server (14)    
tally table (14)    
visual basic 6 (14)    
window functions (14)    
error handling (13)    
ado (12)    
coalesce (12)    
delete (12)    
dynamic sql (12)    
editorial (12)    
foreign keys (fk) (12)    
replication (12)    
datetime manipulation (11)    
except (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)    
execution plans (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)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
union (8)    
video (8)    
automated dba (7)    
cast and convert (7)    
constraints (7)    
counter (7)    
delimited strings (7)    
mail (7)    
outer joins (7)    
output clause (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)    
aggregate function (6)    
arrays (6)    
automation (6)    
best practices (6)    
check constraints (6)    
convert (6)    
group by (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)    
update (6)    
.net (5)    
apply (5)    
charindex (5)    
checksum (5)    
cross apply (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-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)    
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)    
precedence (3)    
regular expressions (3)    
reverse (3)    
script (3)    
scripting (3)    
sequence (3)    
set options (3)    
soundex (3)    
sp_executesql (3)    
space usage (3)    
sql server 2014 (3)    
statistics (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 valued function (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)    
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 profiling (2)    
data warehouse (2)    
database (2)    
database size (2)    
database weekly (2)    
databases (2)    
datalength (2)    
date (2)    
datediff (2)    
datetime2 (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)    
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)    
powershell (2)    
puzzle (2)    
rank() (2)    
recursive function (2)    
replace() (2)    
restore (2)    
rollback (2)    
round (2)    
rounding (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_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 value constructor (2)    
table valued parameters (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)    
window aggregate (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)    
array (1)    
ascii (1)    
assembly (1)    
async (1)    
automatic (1)    
azure (1)    
backup/restore (1)    
barcode (1)    
bcp (bulk copy program) (1)    
bi (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)    
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 mining (1)    
data pump task (1)    
data quality (1)    
data type (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 conversion (1)    
date dimension (1)    
date functions (1)    
dateadd (1)    
datepart (1)    
dates and conversion (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)    
error messages (1)    
error_message() (1)    
exclude pattern (1)    
exec() (1)    
execution plan (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)    
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)    
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)    
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)    
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)    
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 optimizer (1)    
query plans (1)    
queue processing (1)    
quick tip (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)    
round() (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 2016 (1)    
sql server agent (1)    
sql startup parameters (1)    
sqldom (1)    
sqlprep (1)    
star schemas (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)    
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 &amp; 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)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)