Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
Write for us

  

Content with tag SQL Server 2005 Rss

<< Newer    Items 61 to 80 of 1091    Older >>
 

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,388 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By Adam Haines 2011/04/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,736 reads

SQL Server 2005 Build List

Build List Updated with SP3 CU14 and SP4 CU3.   Read more...
By Steve Jones 2011/03/24 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 114,662 reads

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...
By Rich Yarger 2011/03/14 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 2,079 reads

Search for a text in all databases

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.  Read more...
By Rafal Skotak 2011/03/02 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,745 reads

Kill all connection to database

Procedure tries to kill all connections to the specified database.  Read more...
By Rafal Skotak 2011/03/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,835 reads

SQL Server 2005 Build List

Build List Updated with SP3 CU14 and SP4 CU3.   Read more...
By Steve Jones 2011/03/24 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 114,662 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,165 reads

SQL Server 2005 SP4 Has Been Released

Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.   Read more...
By Press Release 2010/12/20 | Source: SQLServerCentral.com | Category: sql server 2005
Rating:  Rate this |   Briefcase | 4,005 reads

SQL Server 2005 Build List

Build List Updated with SP3 CU14 and SP4 CU3.   Read more...
By Steve Jones 2011/03/24 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 114,662 reads

SQL Server 2005 Performance Dashboard Using SSRS

A first look at the Performance Dashboard in SQL Server 2005 by new author Robert Griffin.  Read more...
By Robert Griffin 2010/12/03 (first published: 2009/07/29) | Source: SQLServerCentral.com | Category: performance dashboard
Rating: |  Discuss |   Briefcase | 27,762 reads

COLLATION

Read more...
By Anantheswar G 2010/11/03 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 2,538 reads

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...
By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,813 reads

SQL Server 2005 Build List

Build List Updated with SP3 CU14 and SP4 CU3.   Read more...
By Steve Jones 2011/03/24 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 114,662 reads

What's the best way to count?

Read more...
By Dave 2010/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,208 reads

Find data difference between two datasets

Find data difference between two datasets  Read more...
By Atif-ullah Sheikh 2010/10/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,700 reads

backup database

Read more...
By VM-723206 2010/09/22 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,231 reads

Way to Check Multiple LIKE without dynamic SQL

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...
By Atif-ullah Sheikh 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,456 reads

Inside the Optimizer: Constructing a Plan - Part 4

The final part in a series by Paul White exploring the internals of query optimization. Learn how   Read more...
By Paul White 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,184 reads

Inside the Optimizer: Constructing a Plan - Part 3

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.  Read more...
By Paul White 2010/09/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,153 reads
<< Newer    Items 61 to 80 of 1091    Older >>
 
Tags
administration (182)    
integration services (ssis) (119)    
t-sql (97)    
development (68)    
security (56)    
sql server 7 (55)    
performance tuning (46)    
sql server 2008 (43)    
indexing (30)    
maintenance and management (26)    
utility (22)    
maintenance (21)    
news (21)    
xml (21)    
miscellaneous (20)    
smo (20)    
service broker (18)    
backup / restore (16)    
compact edition (13)    
advanced querying (12)    
high availability (ha) (12)    
replication (12)    
sql clr (12)    
analysis services (ssas) (10)    
blogs (10)    
monitoring (10)    
reporting services (ssrs) (10)    
disaster recovery (dr) (9)    
search (9)    
strategies (9)    
powershell (8)    
sql server 2000 (8)    
nums (7)    
sql server express (7)    
sqlinsider scripts (7)    
stored procedures (7)    
sys.dm_db_partition_stats (7)    
table of numbers (7)    
tables (7)    
tally (7)    
auditing (6)    
counter (6)    
encryption (6)    
parse (6)    
pivot (6)    
storage (6)    
string manipulation (6)    
tools (6)    
arrays (5)    
automated dba (5)    
clustering (5)    
crosstab (5)    
delimited strings (5)    
jobs (5)    
list indexes (5)    
profiler (5)    
programming (5)    
service packs (5)    
sql server (5)    
.net (4)    
bcp (4)    
data mining (4)    
database mirroring (4)    
extract, transform, load (etl) (4)    
for xml path (4)    
installation (4)    
internals (4)    
management (4)    
management studio (ssms) (4)    
optimizer (4)    
sql agent (4)    
sys.allocation_units (4)    
undocumented (4)    
data types (3)    
data warehousing (3)    
database security (3)    
full text searching (3)    
notification services (3)    
space usage (3)    
sql server 2008 r2 (3)    
sql trace (3)    
sqlclr (3)    
triggers (3)    
2-dimensional arrays (2)    
advanced (2)    
apply (2)    
auto-growth (2)    
blob manipulation (2)    
books (2)    
buffer cache (2)    
columns (2)    
common language runtime (clr) (2)    
data file management (2)    
database design (2)    
database mail (2)    
databases (2)    
dbcc (2)    
ddl (2)    
ddl triggers (2)    
design and theory (2)    
dmv (2)    
excel (2)    
foreign keys (fk) (2)    
fragmentation (2)    
games (2)    
linked server (2)    
lock and connection management (2)    
log shipping (2)    
mdx (2)    
namespaces (2)    
openxml (2)    
paging (2)    
partitioned tables (2)    
permissions (2)    
random numbers (2)    
report (2)    
restore (2)    
routine database growth (2)    
routine growth (2)    
row_number() (2)    
script (2)    
sql server architecture (2)    
statistics (2)    
status (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)    
sysobjects (2)    
troubleshooting (2)    
upgrading (2)    
xsl (2)    
access (1)    
ado.net (1)    
aggregates (1)    
alias (1)    
ascii (1)    
automatic (1)    
backup (1)    
best practices (1)    
book reviews (1)    
build list (1)    
bulk insert (1)    
compression (1)    
conferences/user groups (1)    
configuring (1)    
copy_only (1)    
corruption (1)    
crossword (1)    
cte (1)    
data compression (1)    
data corruption (1)    
data directory (1)    
data path (1)    
database roles (1)    
database size (1)    
database trigger (1)    
default settings (1)    
default trace (1)    
defragment (1)    
delete (1)    
dependencies (1)    
dm_db_index_physical_stats (1)    
dml (1)    
drop (1)    
dts (1)    
dump (1)    
duplicate indexes (1)    
dynamic (1)    
ebcdic (1)    
embedded edition (1)    
error handling (1)    
etl (1)    
event notifications (1)    
export (1)    
express edition (1)    
extended procedures (1)    
extended stored procedures (1)    
file exists (1)    
files and filegroups (1)    
generate scripts (1)    
globalization (1)    
growth (1)    
growth trend (1)    
hardware (1)    
hierarchyid (1)    
identity property (1)    
ids to table (1)    
index maintenance (1)    
indexed views (1)    
information (1)    
information_schema (1)    
integrity check (1)    
job scheduling (1)    
large data sets (1)    
like (1)    
localization (1)    
log directory (1)    
log file (1)    
log path (1)    
logins (1)    
logshipping (1)    
memory management (1)    
merge data (1)    
merge replication (1)    
merge table data in sql 2005 (1)    
metadata (1)    
microsoft office (1)    
missing indexes (1)    
naming standards (1)    
nodes (1)    
olap (1)    
oltp (1)    
output (1)    
parameters (1)    
partitioned views (1)    
partitioning (1)    
password (1)    
passwords (1)    
performance dashboard (1)    
performance monitoring (1)    
php (1)    
presenting (1)    
prime (1)    
prime number (1)    
procedure (1)    
product reviews (1)    
production support (1)    
professional development (1)    
professional organization for sql server (1)    
proxy accounts (1)    
puzzle (1)    
queries (1)    
query performance (1)    
quotename (1)    
reindex (1)    
remote connection tool (1)    
report builder (1)    
row versioning (1)    
running aggregate (1)    
running totals (1)    
schedule (1)    
schedule description (1)    
schema (1)    
script my tables and indexes (1)    
scripts (1)    
secure programming (1)    
selectivity (1)    
server config 2008 (1)    
server config 2008r2 (1)    
server side trace (1)    
server trigger (1)    
setup (1)    
shrink (1)    
shrink database (1)    
sieve (1)    
size estimation (1)    
slowly changing dimensions (1)    
snapshot (1)    
solo (1)    
sp_msforeachdb (1)    
sp_spaceused (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server 6.5 (1)    
sql server agent (1)    
sql university (1)    
sql server 2000 (1)    
sql-dmo (1)    
sqlsaturday (1)    
string to table (1)    
suspect database (1)    
sybase linked server (1)    
synonyms (1)    
sys.columns (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.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
sys.systypes (1)    
sys.tables (1)    
syscolumns (1)    
system development life cycle (1)    
table (1)    
table aliases (1)    
table search (1)    
tables and indexes (1)    
tables and scripts (1)    
time range (1)    
top (1)    
trace (1)    
traces (1)    
training (1)    
transparent data encryption (tde) (1)    
vbscript (1)    
video (1)    
whitespace (1)    
windows security (1)    
windows vista (1)    
writing readable code (1)    
xp_cmdshell (1)    
xp_sendmail (1)    
 
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.