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 1091    Older >>
 

server_config_script_2005_2008_2008R2

Here's a quick query you can run across all your servers (2005_2008_2008R2) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 1,314 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,376 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,376 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,877 reads

SQL 2005 IndexDefrag solution

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night  Read more...
By Kobus van der Walt 2013/12/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,505 reads

Create tables and indexes with a Store Procedure

If you want to get the CREATE TABLES for all your Database tables, now you just need to run this SP.  Read more...
By Dario Palladino 2013/11/27 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,708 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,395 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,562 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,376 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,193 reads

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,589 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,406 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,263 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,376 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 | 18,527 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.  Read more...
Rating: |  Discuss |   Briefcase | 5,726 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,877 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,450 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,395 reads
   Items 1 to 20 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)