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

<< Previous 20    Items 41 to 60 of 2892    Next 20 >>
 

New and Basic Result-set Paging functionality in SQL 2012 Version.

Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.  Read more...
By Eli Leiba 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 523 reads

TRIGGERS

Read more...
By Venkat Jonnalagadda 2013/04/09 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 1,701 reads

ISNUMERIC

Read more...
By G C 2013/04/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,864 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 2013/04/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,210 reads

LEFT JOIN

Read more...
By Kapil Singh 2013/04/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,953 reads

Copy Table

Copy tables from one schema to another schema.  Read more...
By Vinay Kumar 2013/04/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 902 reads

Assigning values to Variables with CASE

Read more...
By Sasidhar Pulivarthi 2013/04/03 | Category: case statement
Rating: (not yet rated) |  Discuss |   Briefcase | 1,746 reads

A Hazard of Using the SQL Merge Statement

The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned  Read more...
By Dwain Camps 2013/04/03 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 11,139 reads

TRY...CATCH

Read more...
By Venkat Jonnalagadda 2013/04/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,912 reads

Create Table with T-SQL

Generate create table statement using T-SQL.  Read more...
By Vinay Kumar 2013/04/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,093 reads

TSQL Pivot Rotations using only REPLACE

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.  Read more...
By Additional Articles 2013/04/01 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,152 reads

LEN()

Read more...
By Eduardo Rey 2013/03/29 | Category: len()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,868 reads

Copy Sql Objects

Copy tables, procedures, functions and view from one schema and another schema.  Read more...
By Vinay Kumar 2013/03/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 688 reads

Truncate Table

Read more...
By Vinay Kumar 2013/03/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,018 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2013/03/28 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 627 reads

Re-throw Errors with Logging

This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.  Read more...
By Harsha Majety 2013/03/28 | Source: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 4,994 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,351 reads

Sub query pass through

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...  Read more...
By Dave Ballantyne 2013/03/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,402 reads

CASCADE - 2

Read more...
By bitbucket 2013/03/26 | Category: cascade
Rating: (not yet rated) |  Discuss |   Briefcase | 1,695 reads

Passing Tables as Parameters

Read more...
By Dwain Camps 2013/03/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,850 reads
<< Previous 20    Items 41 to 60 of 2892    Next 20 >>
 
Tags
miscellaneous (496)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (110)    
administration (98)    
sql server 2005 (96)    
stored procedures (78)    
programming (60)    
date manipulation (55)    
indexing (53)    
backup / restore (47)    
string manipulation (45)    
blogs (44)    
sql server 2008 (39)    
sql puzzles (36)    
data warehousing (29)    
security (27)    
utility (27)    
xml (24)    
aggregates (22)    
maintenance (21)    
triggers (21)    
user defined function (udf) (21)    
identity property (20)    
strategies (20)    
views (18)    
cte (17)    
database design (17)    
transactions (17)    
configuring (16)    
lock and connection management (16)    
development (15)    
data types (14)    
search (14)    
visual basic 6 (14)    
monitoring (13)    
pivot (13)    
ado (12)    
replication (12)    
stairway series (12)    
null (11)    
basics (10)    
datetime manipulation (10)    
delete (10)    
foreign keys (fk) (10)    
merge (10)    
tally table (10)    
crosstab (9)    
datetime (9)    
insert (9)    
recursion (9)    
sql server 2012 (9)    
editorial (8)    
nums (8)    
row_number() (8)    
storage (8)    
table of numbers (8)    
tally (8)    
truncate table (8)    
video (8)    
automated dba (7)    
common table expression (cte) (7)    
counter (7)    
delimited strings (7)    
error handling (7)    
mail (7)    
parse (7)    
sql server (7)    
sql spackle (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
arrays (6)    
case (6)    
collation (6)    
computed column (6)    
except (6)    
integration services (ssis) (6)    
intersect (6)    
output clause (6)    
ranking functions (6)    
select (6)    
sql-dmo (6)    
subquery (6)    
system development life cycle (6)    
udf (6)    
union (6)    
.net (5)    
best practices (5)    
checksum (5)    
constraints (5)    
convert (5)    
cursors (5)    
dynamic sql (5)    
grouping sets (5)    
list indexes (5)    
outer joins (5)    
paging (5)    
schema (5)    
string comparison (5)    
temp tables (5)    
update (5)    
apply (4)    
auto-growth (4)    
automation (4)    
best and worst practices (4)    
coalesce (4)    
count (4)    
cross apply (4)    
data file management (4)    
design and theory (4)    
dts (4)    
etl (4)    
for xml path (4)    
group by (4)    
hashbytes (4)    
hierarchies (4)    
installation (4)    
linked server (4)    
management studio (ssms) (4)    
openxml (4)    
order by (4)    
primary key (pk) (4)    
routine database growth (4)    
routine growth (4)    
sql server 6.5 (4)    
synonyms (4)    
sys.allocation_units (4)    
table (4)    
top (4)    
tvp (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
analysis services (ssas) (3)    
cast and convert (3)    
columns (3)    
create sequence (3)    
cross join (3)    
distinct (3)    
dml (3)    
encryption (3)    
excel (3)    
execution plans (3)    
full-text search (2005) (3)    
function (3)    
hierarchy (3)    
hierarchyid (3)    
humor (3)    
inner join (3)    
isnull (3)    
joins (3)    
lead (3)    
like (3)    
locking (3)    
naming standards (3)    
performance testing (3)    
permissions (3)    
reporting services (ssrs) (3)    
running totals (3)    
scalar-valued functions (3)    
script (3)    
select into (3)    
space usage (3)    
spatial data (3)    
sqlclr (3)    
statistics (3)    
text matching (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
aggregate function (2)    
alias (2)    
alter table (2)    
asp (2)    
auditing (2)    
backup (2)    
between (2)    
bigint (2)    
binary_checksum (2)    
bitwise operators (2)    
buffer cache (2)    
cascade (2)    
cast (2)    
change detection (2)    
charindex (2)    
comma seperated (2)    
common language runtime (clr) (2)    
common table expressions (2)    
conflict resolution (2)    
csv (2)    
data generation (2)    
data profiling (2)    
database (2)    
database weekly (2)    
date (2)    
ddl (2)    
distributed queries (2)    
dmv (2)    
duplicate records (2)    
editorial - mp3 (2)    
extract, transform, load (etl) (2)    
fiscal year (2)    
full join (2)    
games (2)    
grant (2)    
indexed views (2)    
information_schema (2)    
job history (2)    
jobs (2)    
joe celko (2)    
join (2)    
len() (2)    
linked servers (2)    
math (2)    
matrix (2)    
mdx (2)    
nested sets (2)    
news (2)    
ntile (2)    
outer apply (2)    
output (2)    
over (2)    
pagination (2)    
parsing delimited string (2)    
patindex (2)    
patrick leblanc (2)    
puzzle (2)    
random (2)    
random numbers (2)    
recursive function (2)    
regular expressions (2)    
replicate (2)    
restore (2)    
reverse (2)    
round (2)    
rounding (2)    
rowversion (2)    
schemas/dtds (2)    
scripting (2)    
scripts (2)    
semaphore (2)    
sequence (2)    
sequence objects (2)    
smtp (2)    
sparse columns (2)    
sql_variant (2)    
str (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)    
tips & tricks (2)    
troubleshooting (2)    
try catch (2)    
tuning (2)    
varchar (2)    
window functions (2)    
worst practices (2)    
(cross) apply (1)    
::fn_listextendedproperty (1)    
abs() (1)    
access (1)    
active directory (1)    
advanced (1)    
alias data types (1)    
alter column (1)    
alwayson (1)    
array (1)    
automatic (1)    
backup / recovery (1)    
backup/restore (1)    
barcode (1)    
bi (1)    
binary (1)    
bit data type (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)    
c# (1)    
cartesian product (1)    
cascade deletes (1)    
case statement (1)    
ceiling (1)    
check constraint (1)    
check constraints (1)    
checksum() (1)    
choose (1)    
clean garbage data (1)    
closing balances (1)    
cmdshell (1)    
common table expression (1)    
compare data (1)    
compare dataset (1)    
comparing (1)    
computed columns (1)    
connectivity (1)    
constraint (1)    
contest (1)    
conversion (1)    
conversions (1)    
converter (1)    
copying structure (1)    
copyright (1)    
correlated subqueries (1)    
correlation (1)    
create (1)    
create a folder (1)    
cube (1)    
current activity (1)    
cursor (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data manipulation (1)    
data mart (1)    
data mining (1)    
data pump task (1)    
data quality (1)    
data type (1)    
data warehouse (1)    
database mail (1)    
database mirroring (1)    
database restore (1)    
database restore history (1)    
database size (1)    
databases (1)    
datatype (1)    
date calculations (1)    
date conversion (1)    
date data types (1)    
date dimension (1)    
date functions (1)    
dateadd (1)    
datediff (1)    
datetime functions (1)    
dba (1)    
dbcc checkident (1)    
deadlock (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)    
deprecated features (1)    
derived table (1)    
derivedtables (1)    
description (1)    
developers sql (1)    
diagnostic (1)    
dimensional modeling (1)    
dm_db_index_physical_stats (1)    
documentation (1)    
dom (1)    
drives (1)    
drop column (1)    
dsql (1)    
duplicate indexes (1)    
dwh (1)    
editorial - ipod (1)    
editorial - wmv (1)    
elements (1)    
ema (1)    
emonth (1)    
encode (1)    
english query (1)    
execute (1)    
execute as (1)    
exponents (1)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
filegroups (1)    
filestream (1)    
financial rounding (1)    
find foreign key using sql (1)    
floor (1)    
friday poll (1)    
functional dependency (1)    
fuzzy match (1)    
generic sql (1)    
geometry (1)    
gettablename (1)    
gps (1)    
grantee (1)    
grantor (1)    
groouping (1)    
grouping varchar columns (1)    
growth trend (1)    
guest user (1)    
guid (1)    
hash (1)    
having (1)    
hcf (1)    
hex (1)    
hexadecimal (1)    
hexadecimal conversion numeric inline fast (1)    
high availability (1)    
histogram chart (1)    
history (1)    
holiday (1)    
html (1)    
identity column (1)    
identity_insert (1)    
ids to table (1)    
implicit conversion (1)    
indexes (1)    
insert update stored procedure generation (1)    
int (1)    
interstorm (1)    
inventory problem (1)    
ip addresses (1)    
ipv4 addresses (1)    
isnumber (1)    
isnumeric (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)    
len (1)    
linked (1)    
list (1)    
local variables (1)    
logging (1)    
logins (1)    
lookups (1)    
macd (1)    
magnetic tape (1)    
management (1)    
max() (1)    
mds (1)    
median (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)    
mssql (1)    
mstvf (1)    
multi language (1)    
multi process (1)    
mutex (1)    
mysql (1)    
network (1)    
newid (1)    
next 13th (1)    
nodes (1)    
notification services (1)    
nth occurance of day in a month/year (1)    
nth occurrence of a weekday in a month and year (1)    
nullif (1)    
numbers table (1)    
nvarchar (1)    
object (1)    
object permissions (1)    
object_id (1)    
objects (1)    
odbc functions (1)    
operators (1)    
options (1)    
or (1)    
oracle (1)    
order (1)    
ordinal rank (1)    
palalelism (1)    
parallel (1)    
parallel processing (1)    
parameterized queries (1)    
parameters (1)    
parsename (1)    
partition by (1)    
partitioned sets (1)    
partitioned tables (1)    
password (1)    
performance (1)    
permission (1)    
permutation (1)    
pl/sql (1)    
powershell (1)    
precedence (1)    
precision (1)    
primary key (1)    
prime (1)    
prime number (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 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)    
rebind and rewinds (1)    
record linkage (1)    
referential integrity (1)    
remote servers (1)    
replace (1)    
report (1)    
revert (1)    
reviews (1)    
right join (1)    
role (1)    
rollback (1)    
rollup (1)    
row constructor (1)    
row count (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
scd (1)    
script generator (1)    
select * (1)    
selectivity (1)    
semi-additive measures (1)    
sequence object (1)    
sequence of letters (1)    
server (1)    
service broker (1)    
service packs (1)    
set based (1)    
set dateformat (1)    
set functions (1)    
set option (1)    
set options (1)    
sieve (1)    
similarity (1)    
slowly changing dimension (1)    
sma (1)    
software development (1)    
solo (1)    
soundex (1)    
source control (1)    
sp (1)    
sp_msforeachdb (1)    
sp_who2 (1)    
sparse column sets (1)    
spherical coordinates (1)    
split (1)    
split function (1)    
sql agent (1)    
sql jobs (1)    
sql n-tuples (1)    
sql script (1)    
sql server 2000 (1)    
sql server 2011 (1)    
sql server agent (1)    
sqldom (1)    
ssas (1)    
star schemas (1)    
storage management (1)    
stp_cleangarbagedata (1)    
stress test (1)    
string formatting (1)    
string match (1)    
string to table (1)    
strings (1)    
strored procedure (1)    
structure (1)    
substring (1)    
sum (1)    
summer time (1)    
surround (1)    
swap data (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_tran_session_transactions (1)    
sys.fn_physlocformatter (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (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)    
tablediff utility (1)    
table-valued function (1)    
ted (1)    
tempdb (1)    
temporary objects (1)    
temporary tables (1)    
test data (1)    
test-driven development (1)    
throw (1)    
time (1)    
time zone (1)    
timestamp (1)    
to us (1)    
tools (1)    
triangular joins (1)    
truncate (1)    
truncation (1)    
try-catch (1)    
t-sql challenges (1)    
twitter (1)    
type (1)    
ucc/ean (1)    
undocumented stored procedures (1)    
unicode (1)    
union all (1)    
unique (1)    
unique constraint (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 functions (1)    
uuid (1)    
vb.net (1)    
where (1)    
without ssis (1)    
workdays (1)    
xp_create_subdir (1)    
xquery (1)    
your own optimizer (1)    
zip codes (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.