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 21 to 40 of 2929    Next 20 >>
 

SELECT INTO FILESTREAM

Read more...
By Steve Jones 2013/05/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,620 reads

Use of Key Column

Read more...
By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,760 reads

Temp Tables

Read more...
By Sergiy 2013/05/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,906 reads

REPLICATE

Read more...
By Mike Bova 2013/05/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 reads

The many uses of CROSS APPLY

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...  Read more...
By Kenneth Fisher 2013/05/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,913 reads

Object Qualification

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...  Read more...
By Chris McGowan 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 851 reads

Paging Data with T-SQL

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.  Read more...
By Additional Articles 2013/05/22 | Source: Database Journal | Category: paging data
Rating:  Rate this |   Briefcase | 4,434 reads

CHARINDEX()

Read more...
By Bill Lantz 2013/05/21 | Category: charindex
Rating: (not yet rated) |  Discuss |   Briefcase | 1,812 reads

EXCEPT - 1

Read more...
By bitbucket 2013/05/20 | Category: except
Rating: (not yet rated) |  Discuss |   Briefcase | 1,727 reads

INSERT

Read more...
By Kapil Singh 2013/05/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,046 reads

Assigning categories to values 2

Read more...
By Hugo Kornelis 2013/05/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,978 reads

Assigning categories to values 1

Read more...
By Hugo Kornelis 2013/05/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,069 reads

INTO Identities

Read more...
By Steve Jones 2013/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,916 reads

Data Type

Read more...
By Yogesh Kumar 2013/05/10 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,870 reads

The Subquery

Read more...
By malls reddy 2013/05/09 | Category: subquery
Rating: (not yet rated) |  Discuss |   Briefcase | 1,892 reads

Nested triggers 2

Read more...
By Tom Thomson 2013/05/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,670 reads

Comparing an inner join vs a subquery

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...  Read more...
By Kenneth Fisher 2013/05/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,849 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 14,345 reads

Distinct

Read more...
By Vinay Kumar 2013/05/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,915 reads

Timestamps

Read more...
By Honza Mensdorff 2013/05/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,755 reads
<< Previous 20    Items 21 to 40 of 2929    Next 20 >>
 
Tags
miscellaneous (496)    
maintenance and management (237)    
advanced querying (180)    
sqlinsider scripts (123)    
sql server 7 (115)    
performance tuning (112)    
administration (98)    
sql server 2005 (96)    
stored procedures (78)    
programming (60)    
date manipulation (55)    
indexing (55)    
backup / restore (48)    
blogs (46)    
string manipulation (45)    
sql server 2008 (40)    
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)    
search (15)    
data types (14)    
monitoring (14)    
visual basic 6 (14)    
null (13)    
pivot (13)    
ado (12)    
replication (12)    
stairway series (12)    
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)    
sql server (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)    
except (7)    
mail (7)    
parse (7)    
sql spackle (7)    
sys.dm_db_partition_stats (7)    
table variables (7)    
tables (7)    
udf (7)    
arrays (6)    
case (6)    
collation (6)    
computed column (6)    
dynamic sql (6)    
integration services (ssis) (6)    
intersect (6)    
output clause (6)    
paging (6)    
ranking functions (6)    
select (6)    
sql-dmo (6)    
subquery (6)    
system development life cycle (6)    
temp tables (6)    
top (6)    
union (6)    
.net (5)    
automation (5)    
best practices (5)    
checksum (5)    
coalesce (5)    
constraints (5)    
convert (5)    
cursors (5)    
excel (5)    
grouping sets (5)    
list indexes (5)    
order by (5)    
outer joins (5)    
reporting services (ssrs) (5)    
schema (5)    
string comparison (5)    
update (5)    
apply (4)    
auto-growth (4)    
best and worst practices (4)    
count (4)    
cross apply (4)    
data file management (4)    
design and theory (4)    
dts (4)    
etl (4)    
execution plans (4)    
for xml path (4)    
group by (4)    
hashbytes (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)    
select into (4)    
sql server 6.5 (4)    
sqlclr (4)    
synonyms (4)    
sys.allocation_units (4)    
table (4)    
tvp (4)    
updategrams (4)    
xsl (4)    
administrator (3)    
alias (3)    
analysis services (ssas) (3)    
cast and convert (3)    
columns (3)    
create sequence (3)    
cross join (3)    
distinct (3)    
dml (3)    
dmv (3)    
encryption (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)    
running totals (3)    
scalar-valued functions (3)    
script (3)    
scripting (3)    
space usage (3)    
spatial data (3)    
statistics (3)    
text matching (3)    
@@error (2)    
2-dimensional arrays (2)    
4-4-5 accounting (2)    
adjacency list (2)    
aggregate function (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)    
choose (2)    
comma seperated (2)    
common language runtime (clr) (2)    
common table expressions (2)    
conflict resolution (2)    
csv (2)    
data generation (2)    
data profiling (2)    
data warehouse (2)    
database (2)    
database weekly (2)    
date (2)    
ddl (2)    
distributed queries (2)    
duplicate records (2)    
editorial - mp3 (2)    
extract, transform, load (etl) (2)    
filestream (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)    
list (2)    
math (2)    
matrix (2)    
mdx (2)    
mysql (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)    
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)    
unique constraint (2)    
varchar (2)    
window functions (2)    
worst practices (2)    
(cross) apply (1)    
::fn_listextendedproperty (1)    
abs() (1)    
access (1)    
ace (1)    
active directory (1)    
advanced (1)    
advantage (1)    
affinity (1)    
alias data types (1)    
alter column (1)    
alwayson (1)    
ansi_nulls (1)    
array (1)    
assembly (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)    
change tracking (1)    
check constraint (1)    
check constraints (1)    
checksum() (1)    
clean garbage data (1)    
closing balances (1)    
clr (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)    
cpu (1)    
create (1)    
create a folder (1)    
create index (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)    
data type (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)    
dbase (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)    
dependency (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)    
execution_plan (1)    
exponents (1)    
extended stored procedures (1)    
factor (1)    
fall on friday (1)    
filegroups (1)    
financial rounding (1)    
find foreign key using sql (1)    
floor (1)    
fox (1)    
friday poll (1)    
functional dependency (1)    
fuzzy match (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)    
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)    
iff (1)    
implicit conversion (1)    
indexes (1)    
insert update stored procedure generation (1)    
int (1)    
internals (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)    
local variables (1)    
logging (1)    
logins (1)    
lookups (1)    
macd (1)    
magnetic tape (1)    
management (1)    
map (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)    
network (1)    
new feature of sql server 2008 (1)    
newid (1)    
next 13th (1)    
nitesh dedhia (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)    
parameter (1)    
parameterized queries (1)    
parameters (1)    
parsename (1)    
partition by (1)    
partitioned sets (1)    
partitioned tables (1)    
password (1)    
pdf (1)    
performance (1)    
permission (1)    
permutation (1)    
pl/sql (1)    
powershell (1)    
precedence (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 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)    
render (1)    
replace (1)    
report (1)    
revert (1)    
reviews (1)    
right join (1)    
role (1)    
rollback (1)    
rollup (1)    
routine (1)    
row constructor (1)    
row count (1)    
running aggregate (1)    
running count (1)    
sample chapters (1)    
scd (1)    
schedulers (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_sproc_columns (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)    
stored procedure (1)    
stp_cleangarbagedata (1)    
stream (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)    
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.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)    
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 functions (1)    
uuid (1)    
vb.net (1)    
visualizer (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.