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, T-SQL, Miscellaneous Rss

   Items 1 to 20 of 29    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,207 reads

Using the Table Data Type in SQL Server 2000

Performing routine database maintenance such as reindexing is important for keeping your databases running at peak performance. When you use INSERT, UPDATE, and DELETE statements to modify table data, indexes can become fragmented. Index fragmentation can happen when the logical sequence of pages is disrupted or when an index page contains less than its maximum amount of data, creating a gap in the data page or index. As indexes become fragmented, you get inefficient data reads when accessing tables and slower database performance.   Read more...
By Additional Articles 2005/03/10 | Source: developer.com | Category: administration
Rating:  Rate this |   Briefcase | 3,379 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,815 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,794 reads

Debugging MSDTC Issues

For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.   Read more...
By Chris Kempster 2004/01/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,483 reads

Alert! Alert! Backup and Restore Baby!

Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading.   Read more...
By Jeremy Kadlec 2004/01/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,855 reads

Using xp_cmdshell

Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.   Read more...
By Haidong Ji 2004/01/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,708 reads

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.   Read more...
By Chris Kempster 2003/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,399 reads

New Table Structure Compare Tool in Beta

Aladdin is an "alter table" script generation tool for SQL Server 7/2000. Aladdin is currently in BETA. They are currently looking for for 25 people willing to use the beta product and report their experiences. Users who fully participate in the beta will get a free, single user license when the product is released. To participate in the Aladdin BETA program, please download the software and send an email to Ken Otto: ottosoft@hotmail.com - Subject: Aladdin Beta Test.   Read more...
By Additional Articles 2003/10/01 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 988 reads

Create Maintenance Job with a Click without using a Wizard

Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.   Read more...
By Robin Back 2003/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,632 reads

Changing Rogue Database Collations

Collations hard to sort out (I know, bad joke)? Mike did what a good DBA gets paid to do, figure out an easy way to fix something and remove the chance of a user mistake at the same time. Good explanation and a couple scripts show how to handle column level collations.   Read more...
By Mike Pearson 2003/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,564 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,235 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,926 reads

Using Query Analyzer Templates

Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!   Read more...
By Gregory Larsen 2003/04/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,568 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

mssqlXpress v1.02 Released

This is a product we haven't reviewed yet, but looks interesting. A SQL editor type app, features listed include integration with Visual SourceSafe, 'intellisense' statement completion, and keyboard macro's.   Read more...
By Additional Articles 2003/04/04 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 992 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,686 reads

Managing Jobs Part 3

This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.   Read more...
By Andy Warren 2003/03/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,109 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,437 reads

Worst Practice - Sorting by Ordinal

If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!   Read more...
By Andy Warren 2002/10/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,380 reads
   Items 1 to 20 of 29    Older >>
 
Tags
configuring (10)    
programming (10)    
strategies (8)    
monitoring (6)    
stored procedures (6)    
database design (5)    
indexing (4)    
visual basic 6 (4)    
backup / restore (3)    
installation (3)    
performance tuning (3)    
security (3)    
dts (2)    
sql-dmo (2)    
triggers (2)    
user defined function (udf) (2)    
.net (1)    
basics (1)    
best and worst practices (1)    
distributed queries (1)    
english query (1)    
naming standards (1)    
openxml (1)    
replication (1)    
updategrams (1)    
worst practices (1)    
xml (1)    
xsl (1)