Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
Write for us

  

Content with tag SQL Server 2005 Rss

<< Newer    Items 21 to 40 of 1100    Older >>
 

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2013/07/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,675 reads

SSIS Synchronize Remote FTP Directory

Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.  Read more...
By Tommy Bollhofer 2013/05/17 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,802 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.  Read more...
By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,298 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, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,972 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 19,052 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.  Read more...
By Kenneth Nielsen 2013/01/01 | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 5,968 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005).  Read more...
By RBarry Young 2013/12/26 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 15,991 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,619 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,442 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, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,972 reads

Drop FK For A Specific Table

Drop FK For A Sprecific Table  Read more...
By Danilo Antunez 2012/09/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,119 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
By Tommy Bollhofer 2012/08/09 | Source: SQLServerCentral.com | Category: indexing | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 1,604 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,343 reads

2005 Online Index Rebuild using DMV

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.  Read more...
By Tommy Bollhofer 2012/07/31 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,345 reads

Using DDL Trigger

Using DDL Triggers  Read more...
By Renu Mehta 2012/07/17 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 2,218 reads

Logshipping Backup Files Management

Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.  Read more...
By Vaibhav Mehta 2012/06/28 | Source: SQLServerCentral.com | Category: logshipping
Rating: |  Discuss |   Briefcase | 632 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, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,972 reads

Three Attack Vectors in SQL Server 2005

This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.  Read more...
By Derek Colley 2012/03/07 | Source: SQLServerCentral.com | Category: password
Rating: |  Discuss |   Briefcase | 6,854 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,028 reads

sp_JobSchedule_rpt for SQL 2005/8

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.   Read more...
By Alan Speckman 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,345 reads
<< Newer    Items 21 to 40 of 1100    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 (31)    
maintenance and management (26)    
utility (22)    
maintenance (21)    
news (21)    
xml (21)    
miscellaneous (20)    
smo (20)    
service broker (18)    
backup and 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)    
agent jobs (5)    
arrays (5)    
automated dba (5)    
clustering (5)    
crosstab (5)    
delimited strings (5)    
list indexes (5)    
profiler (5)    
programming (5)    
service packs (5)    
sql server (5)    
.net (4)    
bcp (4)    
data mining (4)    
database mirroring (4)    
editorial (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 warehousing (3)    
database security (3)    
datatypes (3)    
full text searching (3)    
notification services (3)    
space usage (3)    
sql server 2008 r2 (3)    
sql trace (3)    
sqlclr (3)    
statistics (data) (3)    
triggers (3)    
upgrading (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)    
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)    
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)    
database weekly (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)    
friday poll (1)    
generate scripts (1)    
globalization (1)    
growth (1)    
growth trend (1)    
hardware (1)    
hierarchyid (1)    
identity property (1)    
ids to table (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 (1)    
performance dashboard (1)    
performance monitoring (1)    
php (1)    
presenting (1)    
prime (1)    
prime number (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)    
schemas (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 2016 (1)    
sql server 6.5 (1)    
sql server agent (1)    
sql university (1)    
sql server 2000 (1)    
sql-dmo (1)    
sqlsaturday (1)    
stored procedure (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)    
upgrade (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-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.