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 21 to 40 of 1094    Older >>
 

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,915 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,500 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,414 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,817 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,096 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,578 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,296 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,331 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,164 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 | 593 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,817 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,842 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 | 956 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 Sekhar Mynam 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,315 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,817 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: |  Discuss |   Briefcase | 1,917 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 | 21,038 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 | 35,278 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 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,266 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 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,340 reads
<< Newer    Items 21 to 40 of 1094    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)    
statistics (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)    
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 (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-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.