Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tag
SQL Server 2005
<< Newer
Items 21 to 40 of 1101
Older >>
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,255 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,699 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,814 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,306 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/11/08
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
45,532 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,109 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
|
6,044 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
|
16,008 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,643 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,448 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/11/08
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
45,532 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,122 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,606 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,354 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,347 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,230 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
|
644 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/11/08
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
45,532 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,855 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,037 reads
<< Newer
Items 21 to 40 of 1101
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)
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)
statistics (data)
(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 2017
(1)
sql server 6.5
(1)
sql server agent
(1)
sql university
(1)
sql server 2000
(1)
sql-dmo
(1)
sqlsaturday
(1)
statistics
(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-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.