<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
SQL Server 2005
,
SQL Server 2008
Items 1 to 20 of 52
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, SQL Server 2008 R2, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,305 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, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,305 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,412 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, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,305 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,227 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, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,305 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,781 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
|
19,201 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
|
32,486 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,278 reads
Check status of active transactions
Script to check status of active transactions.
Read more...
By
Harsha Majety
2011/08/04
|
Source:
SQLServerCentral.com
|
Category:
status
Rating:
|
Discuss
|
Briefcase
|
1,940 reads
SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
Read more...
By
Kevin van der Merwe
2011/05/30 (first published: 2008/05/05)
|
Source:
SQLServerCentral.com
|
Category:
compression
Rating:
|
Discuss
|
Briefcase
|
22,064 reads
Kill all connection to database
Procedure tries to kill all connections to the specified database.
Read more...
By
Rafal Skotak
2011/03/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
3,693 reads
Vote for Me for a PASS SQLRally Precon on SQL Server Security
Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...
Read more...
By
2010/10/28
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,532 reads
What's the best way to count?
Read more...
By
Dave
2010/10/19
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,126 reads
Inside the Optimizer: Constructing a Plan - Part 4
The final part in a series by Paul White exploring the internals of query optimization. Learn how
Read more...
By
Paul White
2010/09/16
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
5,124 reads
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
Read more...
By
Paul White
2010/09/14
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
6,072 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, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,305 reads
Inside the Optimizer: Constructing a Plan - Part 2
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
Read more...
By
Paul White
2010/09/09
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
7,394 reads
Inside the Optimizer: Constructing a Plan - Part 1
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
Read more...
By
Paul White
2010/09/07
|
Source:
SQLServerCentral.com
|
Category:
sql server 2008
Rating:
|
Discuss
|
Briefcase
|
12,176 reads
Items 1 to 20 of 52
Next 20 >>
Tags
blogs
(7)
security
(7)
t-sql
(7)
sql server 2000
(5)
internals
(4)
optimizer
(4)
sql server
(4)
undocumented
(4)
backup / restore
(3)
database security
(3)
integration services (ssis)
(3)
jobs
(3)
performance tuning
(3)
sql server 2008 r2
(3)
apply
(2)
books
(2)
clustering
(2)
database mail
(2)
sql agent
(2)
sql server 7
(2)
sql server architecture
(2)
status
(2)
administration
(1)
auditing
(1)
backup
(1)
compression
(1)
conferences/user groups
(1)
copy_only
(1)
data types
(1)
database mirroring
(1)
database trigger
(1)
ddl
(1)
ddl triggers
(1)
event notifications
(1)
file exists
(1)
hierarchyid
(1)
index maintenance
(1)
indexing
(1)
information
(1)
information_schema
(1)
integrity check
(1)
large data sets
(1)
maintenance
(1)
paging
(1)
parameters
(1)
permissions
(1)
php
(1)
presenting
(1)
professional development
(1)
professional organization for sql server
(1)
proxy accounts
(1)
row_number()
(1)
server trigger
(1)
service broker
(1)
smo
(1)
sql server 2012
(1)
sql university
(1)
sqlsaturday
(1)
statistics
(1)
stored procedures
(1)
syscolumns
(1)
sysobjects
(1)
time range
(1)
tools
(1)
top
(1)
training
(1)
upgrading
(1)
vbscript
(1)
windows security
(1)
xp_sendmail
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
