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

Happy Monday

By Steve Jones 2014/09/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 561 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 | 16,249 reads

CTE

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

SQL Server 2008 r2?

By Shiva N (AxSys) 2014/08/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,400 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 | 8,464 reads

Functions as predicates and SARGable queries

By Uwe Ricken 2014/08/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,439 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,429 reads

PIVOT

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

Choose only two correct answers?

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

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,850 reads

declarations

By Tom Thomson 2014/08/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,706 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 8,509 reads

Which query will give an error?

By Vimal Lohani 2014/08/15 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,594 reads

Phantoms and isolation

By Tom Thomson 2014/08/14 | Category: transaction isolation levels
Rating: (not yet rated) |  Discuss |   Briefcase | 1,509 reads

sp_rename and the procedure definition

By Lowell Izaguirre 2014/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,640 reads

Implicit transaction mode

By Hardik Doshi 2014/08/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,486 reads

In-line variable assignment 2

By Hugo Kornelis 2014/08/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,811 reads

What was that field name?

By Dave 2014/08/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,162 reads

In-line variable assignment 1

By Hugo Kornelis 2014/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,043 reads

Synonym

By Hardik Doshi 2014/08/01 | Category: synonym
Rating: (not yet rated) |  Discuss |   Briefcase | 1,607 reads
   Items 1 to 20 of 3179    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)    
monitoring (14)    
visual basic 6 (14)    
merge (13)    
ado (12)    
datetime (12)    
replication (12)    
sql server (12)    
tally table (11)    
basics (10)    
datetime manipulation (10)    
delete (10)    
editorial (10)    
foreign keys (fk) (10)    
recursion (10)    
collation (9)    
computed columns (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)    
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)    
synonyms (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)    
xquery (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
advanced t-sql (2)    
aggregate function (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)    
truncate (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)    
alter column (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 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)