Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag T-SQL Rss

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

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,158 reads

Delete

By Igor Micev 2015/03/24 | Category: foreign key
Rating: (not yet rated) |  Discuss |   Briefcase | 1,845 reads

Common Mistakes

This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.  Read more...
By Steve Jones 2015/03/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 323 reads

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2015/03/17 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 4,369 reads

The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...  Read more...
By Dwain Camps 2015/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,026 reads

Nested Break

By Steve Jones 2015/03/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,677 reads

Secondary XML Indexes

By Steve Jones 2015/03/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,300 reads

Identity Column Datatype

By Sasidhar Pulivarthi 2015/03/09 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 1,773 reads

Foreign Key Fun

By Tom Thomson 2015/03/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,895 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2015/03/06 (first published: 2013/11/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,907 reads

BREAK

By Steve Jones 2015/03/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,673 reads

XML Indexes

By Steve Jones 2015/03/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,361 reads

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2015/02/27 (first published: 2013/11/12) | Source: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 20,624 reads

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...
By Ashutosh Pandey 2015/02/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,391 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 2015/02/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,375 reads

Signing options

By Steve Jones 2015/02/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,577 reads

Not Again!

By Steve Knox 2015/02/18 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 2,247 reads

Recompile in a stored procedure?

By Ben Kubicek 2015/02/17 | Category: recompile
Rating: (not yet rated) |  Discuss |   Briefcase | 1,741 reads
<< Newer    Items 21 to 40 of 3327    Older >>
 
Tags
miscellaneous (497)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (100)    
sql server 2005 (97)    
stored procedures (84)    
indexing (62)    
programming (60)    
date manipulation (59)    
backup / restore (49)    
blogs (49)    
string manipulation (49)    
sql server 2008 (42)    
sql puzzles (36)    
security (33)    
xml (32)    
aggregates (30)    
data warehousing (29)    
identity property (29)    
utility (27)    
transactions (26)    
triggers (23)    
cte (21)    
maintenance (21)    
stairway series (21)    
user defined function (udf) (21)    
data types (20)    
strategies (20)    
views (20)    
database design (18)    
search (17)    
common table expressions (cte) (16)    
configuring (16)    
lock and connection management (16)    
null (16)    
pivot (16)    
development (15)    
merge (14)    
monitoring (14)    
visual basic 6 (14)    
datetime (13)    
ado (12)    
editorial (12)    
error handling (12)    
replication (12)    
sql server (12)    
computed columns (11)    
delete (11)    
tally table (11)    
basics (10)    
datetime manipulation (10)    
dynamic sql (10)    
except (10)    
foreign keys (fk) (10)    
performance (10)    
recursion (10)    
coalesce (9)    
collation (9)    
crosstab (9)    
insert (9)    
ranking functions (9)    
row_number() (9)    
sql server 2012 (9)    
temp tables (9)    
top (9)    
case (8)    
count (8)    
encryption (8)    
execution plans (8)    
humor (8)    
isnull (8)    
nums (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
truncate table (8)    
video (8)    
automated dba (7)    
constraints (7)    
counter (7)    
delimited strings (7)    
intersect (7)    
like (7)    
mail (7)    
output clause (7)    
paging (7)    
parse (7)    
sqlclr (7)    
subquery (7)    
synonyms (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
udf (7)    
union (7)    
window functions (7)    
arrays (6)    
automation (6)    
best practices (6)    
convert (6)    
integration services (ssis) (6)    
order by (6)    
outer joins (6)    
schemas (6)    
select (6)    
sql-dmo (6)    
system development life cycle (6)    
update (6)    
.net (5)    
apply (5)    
checksum (5)    
cross join (5)    
cursors (5)    
excel (5)    
function (5)    
group by (5)    
grouping sets (5)    
hashbytes (5)    
list indexes (5)    
management studio (ssms) (5)    
rand() (5)    
reporting services (ssrs) (5)    
select into (5)    
string comparison (5)    
table (5)    
try..catch (5)    
analysis services (ssas) (4)    
auto-growth (4)    
best and worst practices (4)    
count() (4)    
cross apply (4)    
data file management (4)    
design and theory (4)    
distinct (4)    
dts (4)    
etl (4)    
for xml path (4)    
friday poll (4)    
hierarchies (4)    
installation (4)    
isnumeric() (4)    
joins (4)    
lead (4)    
len (4)    
linked server (4)    
openxml (4)    
over clause (4)    
permissions (4)    
primary key (pk) (4)    
routine database growth (4)    
routine growth (4)    
running totals (4)    
spatial data (4)    
sql server 6.5 (4)    
sys.allocation_units (4)    
throw (4)    
truncate (4)    
tvp (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
aggregate function (3)    
alias (3)    
alter table (3)    
backup (3)    
between (3)    
bitwise operations (3)    
cast and convert (3)    
columns (3)    
common language runtime (clr) (3)    
create sequence (3)    
cursor (3)    
dbcc checkident (3)    
ddl (3)    
dml (3)    
dmv (3)    
filestream (3)    
fiscal year (3)    
full-text search (2005) (3)    
hierarchy (3)    
hierarchyid (3)    
implicit conversion (3)    
inner join (3)    
join (3)    
lag (3)    
len() (3)    
locking (3)    
naming standards (3)    
ntile (3)    
performance testing (3)    
regular expressions (3)    
replicate (3)    
scalar-valued functions (3)    
script (3)    
scripting (3)    
sequence (3)    
soundex (3)    
space usage (3)    
statistics (3)    
string (3)    
string functions (3)    
text matching (3)    
xquery (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
advanced t-sql (2)    
alter column (2)    
asp (2)    
auditing (2)    
bigint (2)    
binary_checksum (2)    
bitwise operators (2)    
blob manipulation (2)    
break (2)    
buffer cache (2)    
bulk insert (2)    
c# (2)    
cascade (2)    
cascade deletes (2)    
cast (2)    
change detection (2)    
change tracking (2)    
charindex (2)    
choose (2)    
comma seperated (2)    
conflict resolution (2)    
contest (2)    
correlated subqueries (2)    
create table (2)    
csv (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)    
dense_rank() (2)    
distributed queries (2)    
duplicate records (2)    
editorial - mp3 (2)    
execute (2)    
extract, transform, load (etl) (2)    
first_value (2)    
foreign key (2)    
full join (2)    
game (2)    
games (2)    
geometry (2)    
grant (2)    
identity_insert (2)    
indexed views (2)    
information_schema (2)    
isolation levels (2)    
job history (2)    
jobs (2)    
joe celko (2)    
last_value (2)    
linked servers (2)    
list (2)    
math (2)    
matrix (2)    
max() (2)    
mdx (2)    
median (2)    
mssql (2)    
mysql (2)    
nested sets (2)    
news (2)    
nullif (2)    
order (2)    
outer apply (2)    
output (2)    
over (2)    
pagination (2)    
parsename (2)    
parsing delimited string (2)    
partition (2)    
patindex (2)    
patrick leblanc (2)    
powershell (2)    
precedence (2)    
puzzle (2)    
random (2)    
random numbers (2)    
rank() (2)    
recursive function (2)    
replace (2)    
restore (2)    
reverse (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 options (2)    
smtp (2)    
sp_executesql (2)    
sparse columns (2)    
split (2)    
sql_variant (2)    
stored procedure (2)    
str (2)    
strings (2)    
stuff (2)    
subqueries (2)    
sum (2)    
syntax (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 function (2)    
table valued parameters (2)    
temp table (2)    
temporary tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tuning (2)    
unicode (2)    
union all (2)    
unique constraint (2)    
unit testing (2)    
user (2)    
varchar (2)    
window function (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)    
analytical functions (1)    
ansi_nulls (1)    
array (1)    
ascii (1)    
assembly (1)    
async (1)    
automatic (1)    
azure (1)    
backup / recovery (1)    
backup/restore (1)    
barcode (1)    
bcp (bulk copy program) (1)    
bi (1)    
binary (1)    
binary flags (1)    
bit data type (1)    
bit operations (1)    
bitwise and (1)    
bitwise operator (1)    
book reviews (1)    
boomerang (1)    
bug (1)    
bulk (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)    
check constraint (1)    
check constraints (1)    
checksum() (1)    
clean garbage data (1)    
closing balances (1)    
cmdshell (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
computed column (1)    
concat (1)    
concat (t-sql) (1)    
concatenate (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)    
cryptography (1)    
cube (1)    
cumulative (1)    
current activity (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data dictionary (1)    
data manipulation (1)    
data mart (1)    
data mining (1)    
data pump task (1)    
data quality (1)    
database development (1)    
database mail (1)    
database mirroring (1)    
database performance (1)    
database restore (1)    
database restore history (1)    
datatype (1)    
datatypes (1)    
date calculations (1)    
date conversion (1)    
date data types (1)    
date dimension (1)    
date functions (1)    
dateadd (1)    
dates and conversion (1)    
datetime functions (1)    
db_name() (1)    
dba (1)    
dbase (1)    
deadlock (1)    
decimal datatype (1)    
declaration (1)    
declare (1)    
deduplicate (1)    
default (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)    
english query (1)    
error messages (1)    
error_message() (1)    
execute as (1)    
execution plan (1)    
exponents (1)    
expressions (1)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
file copy (1)    
filegroups (1)    
financial rounding (1)    
find foreign key using sql (1)    
fiscal quarter (1)    
float (1)    
floor (1)    
for xml (1)    
fox (1)    
framing (1)    
functional dependency (1)    
fuzzy match (1)    
general (1)    
generate scripts (1)    
generic sql (1)    
geography (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)    
insert into (1)    
insert update stored procedure generation (1)    
inserted (1)    
int (1)    
internals (1)    
interstorm (1)    
inventory problem (1)    
ip addresses (1)    
ipv4 addresses (1)    
isnumber (1)    
iso (1)    
iso week (1)    
jaro winkler (1)    
javascript (1)    
json (1)    
kimball (1)    
large udt (1)    
left join (1)    
left() (1)    
linked (1)    
local variables (1)    
logging (1)    
login (1)    
logins (1)    
lookup table (1)    
lookups (1)    
macd (1)    
magnetic tape (1)    
management (1)    
mandelbrot (1)    
map (1)    
mds (1)    
meta data (1)    
metadata (1)    
michael davis (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)    
nitesh dedhia (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)    
nvarchar (1)    
object (1)    
object permissions (1)    
object_id (1)    
objects (1)    
odbc functions (1)    
openquery (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)    
pass virtual chapters (1)    
password (1)    
pdf (1)    
permission (1)    
permutation (1)    
persisted (1)    
pl/sql (1)    
precision (1)    
primary key (1)    
prime (1)    
prime number (1)    
pro (1)    
procedural programming (1)    
procedure (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)    
ratio (1)    
rbar (1)    
r-bar (1)    
rebind and rewinds (1)    
recompilation (1)    
recompile (1)    
record linkage (1)    
recursive cte (1)    
referential integrity (1)    
remote servers (1)    
render (1)    
report (1)    
reserved words (1)    
return (1)    
revert (1)    
reviews (1)    
right join (1)    
role (1)    
rollup (1)    
routine (1)    
row constructor (1)    
rows and range (1)    
rows to columns (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
sargable (1)    
scalar function (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 (1)    
set based (1)    
set dateformat (1)    
set functions (1)    
set implicit transactions (1)    
set rowcount (1)    
set-based (1)    
sieve (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 agent (1)    
sql agent jobs (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 script (1)    
sql search (1)    
sql server 2000 (1)    
sql server 2011 (1)    
sql server 2014 (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)    
substring (1)    
sudoku (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)    
three valued logic (1)    
time (1)    
time zone (1)    
timestamp (1)    
tips (1)    
tips &amp; tricks (1)    
to us (1)    
tools (1)    
transaction isolation levels (1)    
triangular joins (1)    
trigger (1)    
truncation (1)    
try_convert() (1)    
t-sql challenges (1)    
t-sql tuesday (1)    
tsqlt (1)    
tvf (1)    
twitter (1)    
type (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
unique (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)    
variable naming (1)    
vb.net (1)    
visualizer (1)    
webinar (1)    
where (1)    
wildcard (1)    
window aggregate (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)