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
Miscellaneous
,
T-SQL
,
Administration
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,219 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,772 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
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
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,506 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
|
11,050 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,800 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,405 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
|
1,045 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,639 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,612 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,580 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
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,605 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
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
|
1,024 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,758 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,112 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
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,391 reads
Items 1 to 20 of 29
Older >>
Tags
sql server 7
(26)
configuring
(10)
programming
(10)
strategies
(8)
monitoring
(6)
stored procedures
(6)
database design
(5)
indexing
(4)
visual basic 6
(4)
backup and 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)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.