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

   Items 1 to 20 of 3216    Older >>
 

Template parameters

By Steve Jones 2014/10/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 551 reads

Random unions

By Steve Jones 2014/10/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,198 reads

Terminating with THROW

By Sean Pearce 2014/10/21 | Category: throw
Rating: (not yet rated) |  Discuss |   Briefcase | 1,229 reads

Exploring Your SQL Server Databases with T-SQL

Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.  Read more...
By Additional Articles 2014/10/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,172 reads

Plan Guides

By Steve Jones 2014/10/20 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,103 reads

Unpivot

By twin devil 2014/10/16 | Category: unpivot
Rating: (not yet rated) |  Discuss |   Briefcase | 1,134 reads

Preventing recompile

By Steve Jones 2014/10/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,351 reads

ROW_NUMBER

By Steve Jones 2014/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,623 reads

THROW formatting

By Steve Jones 2014/10/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,427 reads

Transactions

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

APPLY

By Steve Jones 2014/10/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,644 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric :  Read more...
By Vimal Lohani 2014/10/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,111 reads

THROW defaults

By Steve Jones 2014/10/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,402 reads

Row limits

By Steve Jones 2014/10/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,742 reads

Ranking

By Steve Jones 2014/10/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,704 reads

Filling In Missing Values Using the T-SQL Window Frame

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.  Read more...
By Additional Articles 2014/10/01 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,891 reads

How Many Different Random Numbers?

By Amit Goswami 2014/09/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,646 reads

RAND Unions

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

Calculate Distance in Miles from Latitude and Longitude

A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.  Read more...
By RBarry Young 2014/09/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,587 reads

Random values

By Steve Jones 2014/09/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,775 reads
   Items 1 to 20 of 3216    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 (81)    
programming (60)    
date manipulation (58)    
indexing (57)    
backup / restore (49)    
blogs (49)    
string manipulation (48)    
sql server 2008 (41)    
sql puzzles (36)    
security (31)    
data warehousing (29)    
utility (27)    
xml (27)    
aggregates (25)    
triggers (23)    
identity property (22)    
transactions (22)    
cte (21)    
maintenance (21)    
user defined function (udf) (21)    
stairway series (20)    
strategies (20)    
views (20)    
data types (18)    
database design (18)    
search (17)    
configuring (16)    
lock and connection management (16)    
development (15)    
null (15)    
pivot (15)    
common table expressions (cte) (14)    
merge (14)    
monitoring (14)    
visual basic 6 (14)    
ado (12)    
datetime (12)    
replication (12)    
sql server (12)    
error handling (11)    
tally table (11)    
basics (10)    
computed columns (10)    
datetime manipulation (10)    
delete (10)    
editorial (10)    
foreign keys (fk) (10)    
recursion (10)    
collation (9)    
crosstab (9)    
except (9)    
insert (9)    
performance (9)    
row_number() (9)    
sql server 2012 (9)    
top (9)    
case (8)    
coalesce (8)    
encryption (8)    
execution plans (8)    
isnull (8)    
nums (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
temp tables (8)    
truncate table (8)    
video (8)    
automated dba (7)    
constraints (7)    
count (7)    
counter (7)    
delimited strings (7)    
dynamic sql (7)    
intersect (7)    
like (7)    
mail (7)    
output clause (7)    
paging (7)    
parse (7)    
ranking functions (7)    
sqlclr (7)    
subquery (7)    
synonyms (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
udf (7)    
union (7)    
arrays (6)    
automation (6)    
best practices (6)    
convert (6)    
integration services (ssis) (6)    
order by (6)    
outer joins (6)    
select (6)    
sql-dmo (6)    
system development life cycle (6)    
update (6)    
.net (5)    
checksum (5)    
cursors (5)    
excel (5)    
function (5)    
grouping sets (5)    
hashbytes (5)    
list indexes (5)    
management studio (ssms) (5)    
reporting services (ssrs) (5)    
schema (5)    
select into (5)    
string comparison (5)    
table (5)    
try..catch (5)    
window functions (5)    
analysis services (ssas) (4)    
apply (4)    
auto-growth (4)    
best and worst practices (4)    
cross apply (4)    
cross join (4)    
data file management (4)    
design and theory (4)    
distinct (4)    
dts (4)    
etl (4)    
for xml path (4)    
group by (4)    
hierarchies (4)    
humor (4)    
installation (4)    
lead (4)    
len (4)    
linked server (4)    
openxml (4)    
permissions (4)    
primary key (pk) (4)    
rand() (4)    
routine database growth (4)    
routine growth (4)    
spatial data (4)    
sql server 6.5 (4)    
sys.allocation_units (4)    
throw (4)    
tvp (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
alias (3)    
alter table (3)    
backup (3)    
between (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)    
identity (3)    
inner join (3)    
isnumeric() (3)    
join (3)    
joins (3)    
len() (3)    
locking (3)    
naming standards (3)    
ntile (3)    
over clause (3)    
performance testing (3)    
regular expressions (3)    
replicate (3)    
running totals (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)    
truncate (3)    
xquery (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
advanced t-sql (2)    
aggregate function (2)    
alter column (2)    
asp (2)    
auditing (2)    
bigint (2)    
binary_checksum (2)    
bitwise operators (2)    
buffer cache (2)    
c# (2)    
cascade (2)    
cast (2)    
change detection (2)    
change tracking (2)    
charindex (2)    
choose (2)    
comma seperated (2)    
conflict resolution (2)    
correlated subqueries (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)    
extract, transform, load (etl) (2)    
friday poll (2)    
full join (2)    
games (2)    
geometry (2)    
grant (2)    
identity_insert (2)    
implicit conversion (2)    
indexed views (2)    
information_schema (2)    
isolation levels (2)    
job history (2)    
jobs (2)    
joe celko (2)    
lag (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)    
round (2)    
rounding (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)    
stuff (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)    
temp table (2)    
temporary tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tuning (2)    
unicode (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)    
ansi_nulls (1)    
array (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)    
blob manipulation (1)    
book reviews (1)    
boomerang (1)    
bug (1)    
bulk (1)    
bulk insert (1)    
business days (1)    
business intelligence (1)    
calculation (1)    
career (1)    
cartesian product (1)    
cascade deletes (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)    
concat (1)    
concat (t-sql) (1)    
concatenate (1)    
configuration (1)    
connectivity (1)    
contest (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)    
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)    
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)    
elements (1)    
ema (1)    
emonth (1)    
encode (1)    
english query (1)    
execute (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)    
fox (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)    
histogram chart (1)    
history (1)    
holiday (1)    
html (1)    
identity column (1)    
ids to table (1)    
iff (1)    
iif (transact-sql) (1)    
index (1)    
indexes (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)    
map (1)    
mds (1)    
meta data (1)    
metadata (1)    
michael davis (1)    
microsoft office (1)    
missing indexes (1)    
mobile devices (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)    
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)    
query (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)    
ranking (1)    
ranking function (1)    
ratio (1)    
rbar (1)    
r-bar (1)    
rebind and rewinds (1)    
recompilation (1)    
record count (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)    
rollback (1)    
rollup (1)    
routine (1)    
row constructor (1)    
row count (1)    
rows to columns (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
sargable (1)    
scalar function (1)    
scd (1)    
schedulers (1)    
schemas (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)    
sieve (1)    
similarity (1)    
slowly changing dimensions (1)    
sma (1)    
software development (1)    
solo (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 agent (1)    
sql agent jobs (1)    
sql clr (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 splitter (1)    
string to table (1)    
strings (1)    
strored procedure (1)    
structure (1)    
subqueries (1)    
substring (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 valued parameters (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 & tricks (1)    
to us (1)    
tools (1)    
transaction isolation levels (1)    
triangular joins (1)    
truncation (1)    
try_convert() (1)    
t-sql challenges (1)    
t-sql tuesday (1)    
twitter (1)    
type (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
unique (1)    
uniqueidentifier (1)    
unit testing (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)    
vb.net (1)    
visualizer (1)    
webinar (1)    
where (1)    
wildcard (1)    
window function (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)