Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag T-SQL Rss

<< Newer    Items 41 to 60 of 3477    Older >>
 

Nested Schemas

By Steve Jones 2015/11/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,328 reads

Nested Types

By Steve Jones 2015/11/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,442 reads

User Defined Data Type Alias

By Steve Jones 2015/11/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,281 reads

Job Schedules

By Steve Jones 2015/11/10 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 1,490 reads

DY

By Steve Jones 2015/11/06 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,547 reads

Risks of NOLOCK, part 2

By Hugo Kornelis 2015/11/03 | Category: nolock
Rating: (not yet rated) |  Discuss |   Briefcase | 1,681 reads

Risks of NOLOCK, part 1

By Hugo Kornelis 2015/11/02 | Category: nolock
Rating: (not yet rated) |  Discuss |   Briefcase | 1,853 reads

Paginating a SQL query result set

How to Paginate a query result set to keep from pulling the whole result set to the client side   Read more...
By Greg Ryan 2015/11/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,538 reads

More wildcard searches

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

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2015/10/23 (first published: 2013/04/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,501 reads

The TOP 10 Count

By Eirikur Eiriksson 2015/10/22 | Category: top
Rating: (not yet rated) |  Discuss |   Briefcase | 1,688 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2015/10/21 | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,671 reads

Counting the Tally Table

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

Finding Azure SQL Database

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

Finding Queries to Tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2015/10/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,335 reads

INTERSECT

By Satish Chaudhary 2015/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,491 reads

Whats the count???

By Umer Akram 2015/10/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,738 reads

Identity Column

By Shiva N 2015/10/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,656 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 6,703 reads
<< Newer    Items 41 to 60 of 3477    Older >>
 
Tags
miscellaneous (497)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (113)    
administration (101)    
sql server 2005 (97)    
stored procedures (85)    
indexing (65)    
date manipulation (62)    
programming (60)    
backup and restore (50)    
string manipulation (50)    
blogs (49)    
sql server 2008 (42)    
security (36)    
sql puzzles (36)    
xml (33)    
aggregates (31)    
identity property (30)    
data warehousing (29)    
transactions (27)    
utility (27)    
triggers (23)    
cte (22)    
datatypes (22)    
stairway series (22)    
user defined function (udf) (22)    
maintenance (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)    
computed columns (14)    
datetime (14)    
merge (14)    
monitoring (14)    
visual basic 6 (14)    
error handling (13)    
sql server (13)    
window functions (13)    
ado (12)    
coalesce (12)    
delete (12)    
editorial (12)    
replication (12)    
tally table (12)    
datetime manipulation (11)    
dynamic sql (11)    
basics (10)    
cursors (10)    
except (10)    
foreign keys (fk) (10)    
humor (10)    
performance (10)    
recursion (10)    
temp tables (10)    
top (10)    
truncate table (10)    
collation (9)    
count (9)    
crosstab (9)    
encryption (9)    
execution plans (9)    
insert (9)    
like (9)    
ranking functions (9)    
row_number() (9)    
sql server 2012 (9)    
case (8)    
count() (8)    
intersect (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)    
mail (7)    
outer joins (7)    
output clause (7)    
paging (7)    
parse (7)    
schemas (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)    
cast and convert (6)    
convert (6)    
integration services (ssis) (6)    
lead (6)    
management studio (ssms) (6)    
order by (6)    
scalar udf (6)    
sql-dmo (6)    
system development life cycle (6)    
try..catch (6)    
update (6)    
.net (5)    
aggregate function (5)    
apply (5)    
check constraints (5)    
checksum (5)    
cross apply (5)    
cross join (5)    
excel (5)    
filestream (5)    
function (5)    
group by (5)    
grouping sets (5)    
hashbytes (5)    
list indexes (5)    
rand() (5)    
reporting services (ssrs) (5)    
select into (5)    
string comparison (5)    
table (5)    
alter table (4)    
analysis services (ssas) (4)    
auto-growth (4)    
best and worst practices (4)    
data file management (4)    
date data types (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)    
advanced t-sql (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)    
duplicate records (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)    
set-based (3)    
soundex (3)    
space usage (3)    
sql server 2014 (3)    
statistics (3)    
stored procedure (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)    
alter column (2)    
analytic functions (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)    
checksum() (2)    
choose (2)    
comma seperated (2)    
conflict resolution (2)    
contest (2)    
correlated subqueries (2)    
create table (2)    
csv (2)    
cursor (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)    
datetime2 (2)    
dense_rank() (2)    
distributed queries (2)    
editorial - mp3 (2)    
execute (2)    
execute as (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)    
nolock (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)    
smtp (2)    
sp_executesql (2)    
sparse columns (2)    
split (2)    
sql agent (2)    
sql_variant (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)    
try_convert() (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)    
ansi_nulls (1)    
array (1)    
ascii (1)    
assembly (1)    
async (1)    
automatic (1)    
azure (1)    
azure sql database (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_agg (1)    
choose() (1)    
clean garbage data (1)    
closing balances (1)    
cmdshell (1)    
column aliases (1)    
columnproperty() (1)    
columnstore index (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
compress (1)    
concat (1)    
concat (t-sql) (1)    
concatenate (1)    
conditional joins (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 type (1)    
cryptography (1)    
cube (1)    
cumulative (1)    
current activity (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data dictionary (1)    
data integrity (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 dimension (1)    
date functions (1)    
dateadd (1)    
datepart (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)    
exponents (1)    
expressions (1)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
file copy (1)    
filegroups (1)    
filetable (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)    
loop (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)    
pattern search (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)    
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)    
relational databases (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)    
round() (1)    
routine (1)    
row constructor (1)    
rowcount (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 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 2016 (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)    
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)    
wildcards (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)