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 41 to 60 of 3310    Older >>
 

IMPLICIT_TRANSACTIONS & BEGIN TRAN (second)

By Carlo Romagnano 2015/01/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,619 reads

Counting values

By Steve Jones 2015/01/14 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,315 reads

Identity Data Types

By Steve Jones 2015/01/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,173 reads

IMPLICIT_TRANSACTIONS & BEGIN TRAN

By Carlo Romagnano 2015/01/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,742 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2015/01/09 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 30,054 reads

Error messages

By Steve Jones 2015/01/08 | Category: error handling
Rating: (not yet rated) |  Discuss |   Briefcase | 2,292 reads

NULL Aggregates

By Steve Jones 2015/01/07 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 2,108 reads

IsNumeric

By Gaurav Jha 2015/01/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,436 reads

The First Day

By Steve Jones 2015/01/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,144 reads

The End

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

Create Table FAILED!?

By Steve Knox 2014/12/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,202 reads

Synonyms and Temp Tables

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

PatExclude8K

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

Checking meta data

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

Parsing HTML to SQL using SQLDOM

It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM  Read more...
By David Rueter 2014/12/26 (first published: 2012/04/16) | Source: SQLServerCentral.com | Category: html
Rating: |  Discuss |   Briefcase | 14,495 reads

Merry Christmas 2014

By Steve Jones 2014/12/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,031 reads

Lists

By Steve Jones 2014/12/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,071 reads

Linked lists

Learn how you can achieve better performance with linked list instead of a numbering column.  Read more...
By Andreas Bartels 2014/12/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,996 reads

T-SQL

By Anju Renjith 2014/12/19 | Category: string operations
Rating: (not yet rated) |  Discuss |   Briefcase | 1,969 reads

Bit Casting

By Gabe Tower 2014/12/18 | Category: bitwise operations
Rating: (not yet rated) |  Discuss |   Briefcase | 1,693 reads
<< Newer    Items 41 to 60 of 3310    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)    
aggregates (30)    
xml (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)    
configuring (16)    
lock and connection management (16)    
null (16)    
pivot (16)    
common table expressions (cte) (15)    
development (15)    
merge (14)    
monitoring (14)    
visual basic 6 (14)    
datetime (13)    
ado (12)    
editorial (12)    
error handling (12)    
replication (12)    
sql server (12)    
delete (11)    
tally table (11)    
basics (10)    
computed columns (10)    
datetime manipulation (10)    
except (10)    
foreign keys (fk) (10)    
performance (10)    
recursion (10)    
collation (9)    
crosstab (9)    
dynamic sql (9)    
insert (9)    
ranking functions (9)    
row_number() (9)    
sql server 2012 (9)    
top (9)    
case (8)    
coalesce (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)    
temp tables (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)    
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)    
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)    
window functions (5)    
analysis services (ssas) (4)    
apply (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)    
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)    
len() (3)    
locking (3)    
naming standards (3)    
ntile (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)    
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)    
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)    
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)    
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)    
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)    
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)    
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)    
bulk insert (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)    
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)    
create table (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)    
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)    
first_value (1)    
fiscal quarter (1)    
float (1)    
floor (1)    
for xml (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)    
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)    
last_value (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)    
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 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 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 function (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)