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 2897    Next 20 >>
 

SQL JOINS

Read more...
By Yogesh Kumar 2013/04/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,900 reads

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...  Read more...
By Kenneth Fisher 2013/04/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,022 reads

DateTime data types

Read more...
By Sasidhar Pulivarthi 2013/04/11 | Category: datetime manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,632 reads

Run SQL code on each database

You can use this to run a script/s on multiple databases  Read more...
By Ashley McLellan 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,592 reads

Identity Columns

Read more...
By Bilal Mahmood 2013/04/10 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 1,884 reads

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 | 527 reads

TRIGGERS

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

ISNUMERIC

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

LEFT JOIN

Read more...
By Kapil Singh 2013/04/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,973 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 | 917 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,762 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,169 reads

TRY...CATCH

Read more...
By Venkat Jonnalagadda 2013/04/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,923 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,111 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,179 reads

LEN()

Read more...
By Eduardo Rey 2013/03/29 | Category: len()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,887 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 | 698 reads

Truncate Table

Read more...
By Vinay Kumar 2013/03/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,034 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 | 635 reads
<< Previous 20    Items 41 to 60 of 2897    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)    
temp tables (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)    
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)    
replicate (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)    
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 (ha) (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)    
paging data (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.