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
Keep up to date - daily newsletter:
Sign up
Content with tags
T-SQL
,
Configuring
Items 1 to 20 of 20
Attach and Detach..Again
Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!
Read more...
By
Andy Warren
2006/06/23 (first published: 2002/04/05)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
24,219 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,838 reads
Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
Read more...
By
Mindy Curnutt
2005/02/04 (first published: 2002/02/11)
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
35,855 reads
Getting the Most Out of SQL Server 2000's Query Analyzer, Part III
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
Read more...
By
Brian Kelley
2005/01/07 (first published: 2002/08/01)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
38,699 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
The SQL Server Black Box
Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.
Read more...
By
Brian Knight
2003/04/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
14,373 reads
Ways to Determine the Version and SP of SQL Server
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
Read more...
By
Dinesh Priyankara
2003/02/28
|
Source:
SQLServerCentral.com
|
Category:
service packs
Rating:
|
Discuss
|
Briefcase
|
21,863 reads
Managing Jobs - Part 1
How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.
Read more...
By
Andy Warren
2003/01/31
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
10,452 reads
Manage Multiple SQL Server Installations and Databases with OSQL
This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.
Read more...
By
Randy Dyess
2002/10/24
|
Source:
SQLServerCentral.com
|
Category:
configuring
Rating:
|
Discuss
|
Briefcase
|
9,816 reads
The Case for SQL Logins - Part Two
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
Read more...
By
Andy Warren
2002/08/19
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,780 reads
Ansi Options Part 3 - ANSI_NULL_DFLT_ON
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
Read more...
By
Steve Jones
2002/08/07
|
Source:
SQLServerCentral.com
|
Category:
configuring
Rating:
|
Discuss
|
Briefcase
|
3,735 reads
Getting the Most Out of SQL Server 2000's Query Analyzer, Part III
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
Read more...
By
Brian Kelley
2005/01/07 (first published: 2002/08/01)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
38,699 reads
Ansi Options Part 1 - ANSI_PADDING
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
Read more...
By
Steve Jones
2002/07/08
|
Source:
SQLServerCentral.com
|
Category:
configuring
Rating:
|
Discuss
|
Briefcase
|
5,818 reads
Review of SQL Server 2000 Programming (MSPress)
Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!
Read more...
By
Andy Warren
2002/06/04
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
6,398 reads
SQL Maintenance Plans - Under the Covers!
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
Read more...
By
Andy Warren
2002/05/21
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
9,208 reads
Version Control for Stored Procedures
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
Read more...
By
Andy Warren
2002/05/10
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
13,424 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,838 reads
Attach and Detach..Again
Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!
Read more...
By
Andy Warren
2006/06/23 (first published: 2002/04/05)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
24,219 reads
Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
Read more...
By
Mindy Curnutt
2005/02/04 (first published: 2002/02/11)
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
35,855 reads
Items 1 to 20 of 20
Tags
sql server 7
(16)
administration
(13)
miscellaneous
(10)
programming
(5)
indexing
(4)
installation
(4)
monitoring
(4)
stored procedures
(4)
strategies
(4)
backup and restore
(3)
database design
(3)
performance tuning
(3)
security
(3)
dts
(2)
triggers
(2)
user defined function (udf)
(2)
visual basic 6
(2)
advanced querying
(1)
basics
(1)
distributed queries
(1)
english query
(1)
naming standards
(1)
openxml
(1)
product reviews
(1)
replication
(1)
reviews
(1)
service packs
(1)
sql-dmo
(1)
updategrams
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.