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 3192    Older >>
 

Which type of Numbers?

By Shiva N (AxSys) 2014/09/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 981 reads

Synonyms 2

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

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 16,599 reads

Truncate table query

By Vimal Lohani 2014/09/11 | Category: truncate
Rating: (not yet rated) |  Discuss |   Briefcase | 1,542 reads

While loop Testing

By Shiva N (AxSys) 2014/09/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,364 reads

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)  Read more...
By j.d.brooks 2014/09/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,836 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2014/09/09 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 4,108 reads

Merge Targets

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

Synonyms 1

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

What will this query return?

By Shiva N (AxSys) 2014/09/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,709 reads

TVP

By Stewart Campbell 2014/09/03 | Category: table valued parameters
Rating: (not yet rated) |  Discuss |   Briefcase | 1,487 reads

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.  Read more...
By Robin Langell 2014/09/03 | Source: SQLServerCentral.com | Category: easter sunday
Rating: |  Discuss |   Briefcase | 506 reads

Persisted Columns

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

Happy Monday

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

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 17,952 reads

CTE

Rating: (not yet rated) |  Discuss |   Briefcase | 1,720 reads

SQL Server 2008 r2?

By Shiva N (AxSys) 2014/08/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,724 reads

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?  Read more...
By Additional Articles 2014/08/27 | Source: SimpleTalk | Category: expressions
Rating: (not yet rated)  Rate this |   Briefcase | 10,344 reads

Functions as predicates and SARGable queries

By Uwe Ricken 2014/08/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,619 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2014/08/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,564 reads
   Items 1 to 20 of 3192    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 (57)    
indexing (57)    
backup / restore (49)    
blogs (49)    
string manipulation (47)    
sql server 2008 (41)    
sql puzzles (36)    
security (31)    
data warehousing (29)    
utility (27)    
xml (27)    
aggregates (25)    
identity property (22)    
triggers (22)    
cte (21)    
maintenance (21)    
transactions (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)    
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)    
sql server 2012 (9)    
case (8)    
coalesce (8)    
encryption (8)    
error handling (8)    
execution plans (8)    
isnull (8)    
nums (8)    
performance (8)    
row_number() (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
temp tables (8)    
top (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)    
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)    
union (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)    
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)    
routine database growth (4)    
routine growth (4)    
sql server 6.5 (4)    
sys.allocation_units (4)    
tvp (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
alias (3)    
alter table (3)    
analysis services (ssas) (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)    
spatial data (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)    
distributed queries (2)    
duplicate records (2)    
editorial - mp3 (2)    
extract, transform, load (etl) (2)    
friday poll (2)    
full join (2)    
games (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)    
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)    
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)    
dense_rank() (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)    
geometry (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)    
rand() (1)    
random dates (1)    
range (1)    
ranking (1)    
ranking function (1)    
ratio (1)    
rbar (1)    
r-bar (1)    
rebind and rewinds (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)    
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 agent (1)    
sql startup parameters (1)    
sqldom (1)    
sqlprep (1)    
ssas (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)    
temporary objects (1)    
test data (1)    
test-driven development (1)    
three valued logic (1)    
throw (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)    
union all (1)    
unique (1)    
uniqueidentifier (1)    
unit testing (1)    
unix (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)