Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, SQL Server 7, Miscellaneous, Configuring Rss

   Items 1 to 20 of 23    Older >>
 

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,209 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,816 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,796 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,043 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,172 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,933 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,205 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,337 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,438 reads

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Review of Real-World SQL-DMO

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,246 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,770 reads

Using the Copy Database Wizard

In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!   Read more...
By Andy Warren 2002/07/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,901 reads

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.   Read more...
By Andy Warren 2002/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,594 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

Maintenance Plans - Behind the Scenes

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!   Read more...
By Andy Warren 2002/05/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,402 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,195 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,382 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,816 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,209 reads
   Items 1 to 20 of 23    Older >>
 
Tags
programming (10)    
t-sql (10)    
strategies (7)    
backup / restore (6)    
performance tuning (6)    
indexing (5)    
monitoring (5)    
replication (5)    
security (5)    
database design (4)    
stored procedures (4)    
visual basic 6 (4)    
dts (3)    
installation (3)    
ado (2)    
distributed queries (2)    
naming standards (2)    
sql-dmo (2)    
triggers (2)    
user defined function (udf) (2)    
availability (1)    
basics (1)    
best and worst practices (1)    
disaster recovery (dr) (1)    
english query (1)    
openxml (1)    
updategrams (1)    
worst practices (1)    
xml (1)    
xsl (1)