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

Dynamic Sudoku for 3X3

it is a 3X3 dynamic sudoku  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 805 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2015/07/10 (first published: 2013/07/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 20,361 reads

A new set-based T-SQL solution for Sudoku puzzle

New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.   Read more...
By Kevin Duan 2015/07/09 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 1,118 reads

Views

By Shiva N 2015/07/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,745 reads

integer lengths (II)

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

Dependency between tables

By Junior Galvão - MVP 2015/07/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,738 reads

Integer lengths (I)

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

Who is the odd man out?

By Shiva N 2015/06/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,027 reads

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2015/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 974 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2015/06/26 (first published: 2013/07/09) | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 21,503 reads

Date Predence

By Steve Jones 2015/06/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,653 reads

What is the Output?

By Shiva N 2015/06/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,782 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2015/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,085 reads

Truncate Table

By Rembert Caro 2015/06/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,054 reads

Not so obvious COALESCE behaviour

By Phil Parsons 2015/06/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,719 reads

Column manipulation with ALTER TABLE

By Arno Kwetters 2015/06/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,757 reads

How Many Rows Returned

By G. C. 2015/06/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,806 reads

What will happen with below code???

By Shiva N 2015/06/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,085 reads

Error handling

By Junior Galvão - MVP 2015/06/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,825 reads

Insert without a PK

By Steve Jones 2015/06/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,020 reads
<< Newer    Items 21 to 40 of 3405    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 (85)    
indexing (64)    
programming (60)    
date manipulation (59)    
backup / restore (49)    
blogs (49)    
string manipulation (49)    
sql server 2008 (42)    
sql puzzles (36)    
security (33)    
xml (33)    
aggregates (31)    
data warehousing (29)    
identity property (29)    
utility (27)    
transactions (26)    
triggers (23)    
cte (22)    
user defined function (udf) (22)    
datatypes (21)    
maintenance (21)    
stairway series (21)    
views (21)    
strategies (20)    
null (19)    
database design (18)    
common table expressions (cte) (17)    
search (17)    
configuring (16)    
lock and connection management (16)    
pivot (16)    
development (15)    
merge (14)    
monitoring (14)    
visual basic 6 (14)    
computed columns (13)    
datetime (13)    
error handling (13)    
sql server (13)    
ado (12)    
delete (12)    
editorial (12)    
replication (12)    
window functions (12)    
coalesce (11)    
datetime manipulation (11)    
dynamic sql (11)    
tally table (11)    
basics (10)    
cursors (10)    
except (10)    
foreign keys (fk) (10)    
performance (10)    
recursion (10)    
temp tables (10)    
truncate table (10)    
collation (9)    
crosstab (9)    
insert (9)    
ranking functions (9)    
row_number() (9)    
sql server 2012 (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)    
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)    
select (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)    
management studio (ssms) (6)    
order by (6)    
outer joins (6)    
schemas (6)    
sql-dmo (6)    
system development life cycle (6)    
try..catch (6)    
update (6)    
.net (5)    
apply (5)    
cast and convert (5)    
checksum (5)    
count() (5)    
cross join (5)    
excel (5)    
function (5)    
group by (5)    
grouping sets (5)    
hashbytes (5)    
lead (5)    
list indexes (5)    
rand() (5)    
reporting services (ssrs) (5)    
scalar udf (5)    
select into (5)    
string comparison (5)    
table (5)    
alter table (4)    
analysis services (ssas) (4)    
auto-growth (4)    
best and worst practices (4)    
check constraints (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)    
join (4)    
joins (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)    
str (4)    
sys.allocation_units (4)    
throw (4)    
truncate (4)    
tvp (4)    
updategrams (4)    
xquery (4)    
xsl (4)    
administrator (3)    
aggregate function (3)    
alias (3)    
backup (3)    
between (3)    
bitwise operations (3)    
columns (3)    
common language runtime (clr) (3)    
create sequence (3)    
datatype (3)    
dbcc checkident (3)    
ddl (3)    
dml (3)    
dmv (3)    
filestream (3)    
fiscal year (3)    
float (3)    
full-text search (2005) (3)    
hierarchy (3)    
hierarchyid (3)    
implicit conversion (3)    
inner join (3)    
lag (3)    
len() (3)    
locking (3)    
naming standards (3)    
ntile (3)    
patindex (3)    
performance testing (3)    
precedence (3)    
random numbers (3)    
regular expressions (3)    
replicate (3)    
script (3)    
scripting (3)    
sequence (3)    
soundex (3)    
space usage (3)    
sql server 2014 (3)    
statistics (3)    
string (3)    
string functions (3)    
strings (3)    
stuff (3)    
subqueries (3)    
syntax (3)    
table valued function (3)    
text matching (3)    
unit testing (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
advanced t-sql (2)    
alter column (2)    
analytical functions (2)    
asp (2)    
auditing (2)    
bigint (2)    
binary_checksum (2)    
bit data type (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)    
logins (2)    
math (2)    
matrix (2)    
max() (2)    
mdx (2)    
median (2)    
mirroring (2)    
mssql (2)    
mysql (2)    
nested sets (2)    
news (2)    
nullif (2)    
nvarchar (2)    
openquery (2)    
order (2)    
outer apply (2)    
output (2)    
over (2)    
pagination (2)    
parsename (2)    
parsing delimited string (2)    
partition (2)    
password (2)    
patrick leblanc (2)    
powershell (2)    
puzzle (2)    
random (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 (2)    
set based (2)    
set options (2)    
set-based (2)    
smtp (2)    
sp_executesql (2)    
sparse columns (2)    
split (2)    
sql_variant (2)    
stored procedure (2)    
sudoku (2)    
sum (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 parameters (2)    
temp table (2)    
temporary tables (2)    
tips & tricks (2)    
troubleshooting (2)    
tsqlt (2)    
tuning (2)    
unicode (2)    
union all (2)    
unique constraint (2)    
user (2)    
varchar (2)    
window aggregate (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)    
analytic 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 data (1)    
binary flags (1)    
bit operations (1)    
bitwise (1)    
bitwise and (1)    
bitwise operator (1)    
book reviews (1)    
boomerang (1)    
bug (1)    
bulk (1)    
bulk import (1)    
business days (1)    
business intelligence (1)    
calculation (1)    
calendar table (1)    
career (1)    
cartesian product (1)    
case expression (1)    
case statement (1)    
ceiling (1)    
certificates (1)    
changing (1)    
checksum() (1)    
clean garbage data (1)    
closing balances (1)    
cmdshell (1)    
column aliases (1)    
columnstore index (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)    
cryptography (1)    
cube (1)    
cumulative (1)    
current activity (1)    
cursor (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 conversion (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)    
default constraint (1)    
default constraints (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)    
floor (1)    
for xml (1)    
format (transact-sql) (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)    
inline table valued function (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)    
itvf (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)    
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)    
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)    
object (1)    
object permissions (1)    
object_id (1)    
objects (1)    
odbc functions (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)    
pdf (1)    
percent_rank (1)    
percentile_cont (1)    
percentile_disc (1)    
performance and tuning (1)    
permission (1)    
permutation (1)    
persisted (1)    
pl/sql (1)    
precision (1)    
primary key (1)    
prime (1)    
prime number (1)    
print (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)    
real (1)    
rebind and rewinds (1)    
recompilation (1)    
recompile (1)    
record linkage (1)    
recursive cte (1)    
referential integrity (1)    
regex (1)    
remote servers (1)    
rename (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)    
rtrim (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
sargable (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 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)    
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 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)    
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)    
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)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)