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 tags
Administration
,
Performance Tuning
,
Configuring
Items 1 to 10 of 10
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
33,837 reads
Economies of Speed Whitepaper
Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.
Read more...
By
Additional Articles
2003/05/08
|
Source:
Other
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
1,452 reads
Auto Close and Auto Shrink - Just Don't
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
Read more...
By
Mike Pearson
2003/05/05
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
19,985 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
Read more...
By
Andy Warren
2003/04/18
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
18,208 reads
AWE Adventures
Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?
Read more...
By
Joseph Sack
2003/04/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
23,734 reads
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
33,837 reads
Middle Tier Application Data Caching with SQL Server 2000
Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.
Read more...
By
Additional Articles
2002/03/08
|
Source:
Microsoft SQL Home
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
2,054 reads
How to Setup Log Shipping with SQL 2000
This white paper outlines the following: -The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition. -The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition. -A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.
Read more...
By
Additional Articles
2002/01/25
|
Source:
Microsoft MSDN
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
1,720 reads
Microsoft SQL Server 2000 Scalability Project
This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware.
Read more...
By
Additional Articles
2002/01/10
|
Source:
Microsoft MSDN
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
1,173 reads
INF: Understanding How to Configure a SQL Server Connection Affinity
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
Read more...
By
Additional Articles
2001/08/28
|
Source:
ASPToday
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
1,402 reads
Items 1 to 10 of 10
Tags
sql server 7
(9)
miscellaneous
(6)
t-sql
(3)
distributed queries
(2)
indexing
(2)
monitoring
(2)
replication
(2)
backup and restore
(1)
dts
(1)
english query
(1)
installation
(1)
openxml
(1)
programming
(1)
security
(1)
stored procedures
(1)
strategies
(1)
triggers
(1)
updategrams
(1)
user defined function (udf)
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.