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

Logic Precedence

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

Character Field Declaration

By Mark Grout 2014/02/11 | Category: declaration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,088 reads

Temporary table in a batch

By Anoo S Pillai 2014/02/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,221 reads

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,272 reads

The Performance of the T-SQL Window Functions

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it? Dwain gets out the test harness to investigate.  Read more...
By Additional Articles 2014/02/06 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,776 reads

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.  Read more...
By Jeff Moden 2014/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,935 reads

Backup to the right location, by default

How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.   Read more...
By Additional Articles 2014/01/30 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,042 reads

IDENTITY RESEED

By Lokesh Vij 2014/01/24 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 2,205 reads

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.   Read more...
By Additional Articles 2014/01/22 | Source: SimpleTalk | Category: median
Rating:  Rate this |   Briefcase | 2,331 reads

HASHBYTES

By twin devil 2014/01/21 | Category: hashbytes
Rating: (not yet rated) |  Discuss |   Briefcase | 1,506 reads

Fun with Outer Joins

Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.  Read more...
By Kenneth Fisher 2014/01/17 (first published: 2012/09/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,614 reads

Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.   Read more...
By Jeff Moden 2014/01/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,284 reads

Filtered Index vs Indexed View

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

Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause

The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.  Read more...
By Gregory Larsen 2014/01/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,040 reads

Dynamic Management Functions

By Steve Jacobs 2014/01/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 reads

Unravel Some Complex IF Logic

By Dwain Camps 2014/01/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,969 reads

A Simple Recursion Finds Joins

When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.   Read more...
By Kate Luxemburg 2014/01/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,937 reads

DBCC CHECKIDENT

By Uwe Ricken 2014/01/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,889 reads

Hidden Formatting Troubles with STR() (SQL Spackle)

Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.  Read more...
By Jeff Moden 2014/01/02 (first published: 2010/12/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,923 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 14,950 reads
<< Newer    Items 41 to 60 of 3119    Older >>
 
Tags
miscellaneous (496)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (112)    
administration (100)    
sql server 2005 (97)    
stored procedures (80)    
programming (60)    
indexing (57)    
date manipulation (56)    
backup / restore (49)    
blogs (49)    
string manipulation (45)    
sql server 2008 (41)    
sql puzzles (36)    
data warehousing (29)    
security (28)    
utility (27)    
xml (26)    
aggregates (24)    
identity property (22)    
triggers (22)    
maintenance (21)    
user defined function (udf) (21)    
strategies (20)    
transactions (20)    
views (20)    
cte (19)    
database design (18)    
stairway series (18)    
search (17)    
configuring (16)    
data types (16)    
lock and connection management (16)    
development (15)    
null (15)    
monitoring (14)    
pivot (14)    
visual basic 6 (14)    
ado (12)    
datetime (12)    
replication (12)    
sql server (12)    
merge (11)    
tally table (11)    
basics (10)    
datetime manipulation (10)    
delete (10)    
editorial (10)    
foreign keys (fk) (10)    
recursion (10)    
crosstab (9)    
except (9)    
insert (9)    
sql server 2012 (9)    
case (8)    
coalesce (8)    
common table expression (cte) (8)    
error handling (8)    
execution plans (8)    
nums (8)    
row_number() (8)    
sql spackle (8)    
storage (8)    
table of numbers (8)    
tally (8)    
temp tables (8)    
truncate table (8)    
video (8)    
automated dba (7)    
collation (7)    
count (7)    
counter (7)    
delimited strings (7)    
dynamic sql (7)    
encryption (7)    
intersect (7)    
isnull (7)    
mail (7)    
output clause (7)    
parse (7)    
performance (7)    
ranking functions (7)    
sqlclr (7)    
subquery (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
top (7)    
udf (7)    
arrays (6)    
automation (6)    
best practices (6)    
computed column (6)    
convert (6)    
integration services (ssis) (6)    
like (6)    
order by (6)    
outer joins (6)    
paging (6)    
select (6)    
sql-dmo (6)    
system development life cycle (6)    
union (6)    
update (6)    
.net (5)    
checksum (5)    
constraints (5)    
cursors (5)    
excel (5)    
function (5)    
grouping sets (5)    
hashbytes (5)    
list indexes (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)    
installation (4)    
linked server (4)    
management studio (ssms) (4)    
openxml (4)    
primary key (pk) (4)    
routine database growth (4)    
routine growth (4)    
sql server 6.5 (4)    
synonyms (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)    
create sequence (3)    
dbcc checkident (3)    
dml (3)    
dmv (3)    
filestream (3)    
full-text search (2005) (3)    
hierarchy (3)    
hierarchyid (3)    
humor (3)    
inner join (3)    
isnumeric() (3)    
joins (3)    
lead (3)    
len (3)    
len() (3)    
locking (3)    
naming standards (3)    
ntile (3)    
over clause (3)    
performance testing (3)    
permissions (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 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)    
common language runtime (clr) (2)    
common table expressions (2)    
computed columns (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)    
date (2)    
ddl (2)    
distributed queries (2)    
duplicate records (2)    
editorial - mp3 (2)    
extract, transform, load (etl) (2)    
fiscal year (2)    
friday poll (2)    
full join (2)    
games (2)    
grant (2)    
identity (2)    
identity_insert (2)    
indexed views (2)    
information_schema (2)    
job history (2)    
jobs (2)    
joe celko (2)    
join (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)    
outer apply (2)    
output (2)    
pagination (2)    
parsename (2)    
parsing delimited string (2)    
patindex (2)    
patrick leblanc (2)    
powershell (2)    
precedence (2)    
puzzle (2)    
random (2)    
random numbers (2)    
recursive function (2)    
regular expressions (2)    
replace (2)    
restore (2)    
reverse (2)    
round (2)    
rounding (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)    
string (2)    
stuff (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)    
temp table (2)    
tips & tricks (2)    
troubleshooting (2)    
truncate (2)    
tuning (2)    
unique constraint (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)    
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)    
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)    
common language runtime (1)    
common table expression (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
concat (1)    
concat (t-sql) (1)    
concatenate (1)    
configuration (1)    
connectivity (1)    
constraint (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)    
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)    
databases (1)    
datalength (1)    
datatype (1)    
datatypes (1)    
date calculations (1)    
date conversion (1)    
date data types (1)    
date dimension (1)    
date functions (1)    
dateadd (1)    
datediff (1)    
dates and conversion (1)    
datetime functions (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)    
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 data (1)    
duplicate indexes (1)    
duration (1)    
dwh (1)    
dynamic management functions (dmf) (1)    
dynamic query (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)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
file copy (1)    
filegroups (1)    
financial rounding (1)    
find foreign key using sql (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)    
implicit conversion (1)    
index (1)    
indexes (1)    
insert into (1)    
insert update stored procedure generation (1)    
int (1)    
internals (1)    
interstorm (1)    
inventory problem (1)    
ip addresses (1)    
ipv4 addresses (1)    
isnumber (1)    
iso (1)    
iso week (1)    
isolation level (1)    
isolation levels (1)    
jaro winkler (1)    
javascript (1)    
json (1)    
kimball (1)    
lag (1)    
large udt (1)    
left join (1)    
left() (1)    
linked (1)    
local variables (1)    
logging (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)    
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)    
options (1)    
or (1)    
oracle (1)    
order (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 (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)    
row_number (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
scalar function (1)    
scd (1)    
schedulers (1)    
schemas (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)    
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_sproc_columns (1)    
sp_who2 (1)    
sparse column sets (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)    
substring (1)    
sum (1)    
summer time (1)    
surround (1)    
survey (1)    
swap data (1)    
sybase (1)    
syntax (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 function (1)    
table variable (1)    
tablediff utility (1)    
table-valued function (1)    
ted (1)    
tempdb (1)    
temporary objects (1)    
temporary tables (1)    
test data (1)    
test-driven development (1)    
three valued logic (1)    
throw (1)    
time (1)    
time zone (1)    
timestamp (1)    
tips (1)    
tips &amp; tricks (1)    
to us (1)    
tools (1)    
triangular joins (1)    
truncation (1)    
try_convert() (1)    
tsql (1)    
t-sql challenges (1)    
t-sql tuesday (1)    
twitter (1)    
type (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
unicode (1)    
union all (1)    
unique (1)    
uniqueidentifier (1)    
unit testing (1)    
unix (1)    
update with case (1)    
url (1)    
user (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)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
your own optimizer (1)    
zip codes (1)