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


 

Content with tag SQL Server 2005 Rss

   Items 1 to 20 of 1073    Next 20 >>
 

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,805 reads

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs
Rating: (not yet rated) |  Discuss |  Briefcase | 1,120 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |  Briefcase | 16,846 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |  Briefcase | 29,448 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,119 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 3,006 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 3,306 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 0001/01/01 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |  Briefcase | 2,797 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.  Read more...
By Pedro Lopes MS 0001/01/01 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |  Briefcase | 3,073 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By stumbling fish 0001/01/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |  Briefcase | 3,507 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal Skotak 0001/01/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 3,858 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,805 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 0001/01/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 2,627 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...
By Luke Campbell 0001/01/01 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |  Briefcase | 3,040 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |  Briefcase | 6,095 reads

Index Fragmentation

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.  Read more...
By Sergio Govoni 0001/01/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |  Briefcase | 3,681 reads

Adding a Node to a SQL Server 2005 Failover Cluster

Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 instance.  Read more...
By Additional Articles 2011/10/12 | Source: Database Journal | Category: sql server 2005
Rating: (not yet rated)  Rate this |  Briefcase | 1,322 reads

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE.  Read more...
By Rafal Skotak 0001/01/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 1,653 reads

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 3,046 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,969 reads
   Items 1 to 20 of 1073    Next 20 >>
 
Tags
administration (183)    
integration services (ssis) (119)    
t-sql (95)    
development (68)    
security (55)    
sql server 7 (55)    
performance tuning (43)    
sql server 2008 (40)    
indexing (29)    
maintenance and management (27)    
t-sql aids (25)    
utility (22)    
news (21)    
maintenance (20)    
miscellaneous (20)    
smo (20)    
service broker (18)    
backup / restore (17)    
compact edition (13)    
ss2k5 - xml (13)    
advanced querying (12)    
ss2k5 - clr integration (12)    
xml (12)    
analysis services (ssas) (10)    
blogs (10)    
disaster recovery (dr) (9)    
monitoring (9)    
search (9)    
strategies (9)    
powershell (8)    
reporting services (ssrs) (8)    
sql server 2000 (8)    
high availability (7)    
nums (7)    
replication (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)    
counter (6)    
encryption (6)    
parse (6)    
pivot (6)    
ss2k5 - replication (6)    
storage (6)    
string manipulation (6)    
arrays (5)    
auditing (5)    
automated dba (5)    
clustering (5)    
crosstab (5)    
delimited strings (5)    
jobs (5)    
list indexes (5)    
programming (5)    
service packs (5)    
sql server (5)    
ss2k5 - high availability (5)    
ss2k5 - tools (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)    
performance (4)    
profiler (4)    
sql agent (4)    
sys.allocation_units (4)    
undocumented (4)    
data types (3)    
data warehousing (3)    
database security (3)    
notification services (3)    
space usage (3)    
sql server 2008 r2 (3)    
ss2k5 - full text searching (3)    
ss2k5 triggers (3)    
2-dimensional arrays (2)    
advanced (2)    
apply (2)    
auto-growth (2)    
blob manipulation (2)    
books (2)    
buffer cache (2)    
common language runtime (clr) (2)    
data file management (2)    
database design (2)    
database mail (2)    
databases (2)    
dbcc (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)    
sql trace (2)    
sqlclr (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)    
upgrade (2)    
xsl (2)    
access (1)    
ado.net (1)    
aggregates (1)    
alias (1)    
ascii (1)    
automatic (1)    
best practices (1)    
book reviews (1)    
build list (1)    
bulk insert (1)    
clr functions (1)    
clr stored procedures (1)    
clr udt (1)    
column (1)    
columns (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)    
ddl (1)    
ddl event (1)    
ddl trigger (1)    
ddl triggers (1)    
default settings (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 (1)    
ids to table (1)    
indexed views (1)    
information (1)    
information_schema (1)    
job scheduling (1)    
large data sets (1)    
like (1)    
localization (1)    
log directory (1)    
log file (1)    
log path (1)    
logins (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)    
passwords (1)    
performance and tuning (1)    
performance dashboard (1)    
performance monitoring (1)    
php (1)    
presenting (1)    
prime (1)    
prime number (1)    
procedure (1)    
product reviews (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)    
reporting (1)    
reporting system (1)    
row versioning (1)    
running aggregate (1)    
running totals (1)    
schedule (1)    
schedule description (1)    
schema (1)    
scripts (1)    
secure programming (1)    
selectivity (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 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)    
tde (1)    
time range (1)    
tools (1)    
top (1)    
traces (1)    
training (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-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.