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

Content with tags SQL Server 7, Administration Rss

   Items 1 to 20 of 389    Older >>
 

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,469 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,496 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,250 reads

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 547 reads

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 558 reads

Read_Only Database

By Unknown . 2009/04/10 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 3,919 reads

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.   Read more...
By Brian Knight 2008/08/01 (first published: 2001/07/25) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,916 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,250 reads

Return Query Text Along With sp_who2 Using SQL 2000

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".  Read more...
By Ken Simmons 2008/07/18 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 7,680 reads

usp_SecurCreation - SQL 2k

Creates statements for securables creation.  Read more...
By Pedro Lopes MS 2008/06/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 874 reads

Starting SQL Server in Minimal Configuration

Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.   Read more...
By Jay Dave 2007/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,108 reads

Available bytes for row expansion (adding columns) in a table

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...
By ruchir-628038 2008/04/03 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 788 reads

SQL Server DBA Fights a Demon

An interesting tale of David Bird's fight with tempdb.  Read more...
By David Bird 2008/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,581 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,310 reads

Open Source SQL DDL Scripting Tool

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.   Read more...
By Richard Sutherland 2007/03/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,410 reads

Quickly Moving Databases

This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.   Read more...
By Chris Kempster 2008/02/08 (first published: 2004/05/18) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 147,326 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,876 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,879 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,309 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,498 reads
   Items 1 to 20 of 389    Older >>
 
Tags
configuring (63)    
t-sql (56)    
miscellaneous (52)    
strategies (35)    
security (34)    
programming (30)    
monitoring (27)    
sql server 2005 (26)    
performance tuning (20)    
backup / restore (16)    
sql server 6.5 (16)    
advanced querying (13)    
database design (12)    
visual basic 6 (12)    
installation (11)    
disaster recovery (dr) (10)    
replication (10)    
stored procedures (10)    
dts (9)    
sql-dmo (8)    
best and worst practices (7)    
indexing (7)    
news (7)    
availability (6)    
worst practices (6)    
ado (5)    
.net (4)    
basics (4)    
naming standards (4)    
career (3)    
distributed queries (3)    
service packs (3)    
state of the business (3)    
triggers (3)    
auto-growth (2)    
automated dba (2)    
data file management (2)    
data warehousing (2)    
logins (2)    
maintenance (2)    
maintenance and management (2)    
product reviews (2)    
reviews (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
system development life cycle (2)    
user defined function (udf) (2)    
utility (2)    
advanced (1)    
analysis services (ssas) (1)    
best practices (1)    
bugs (1)    
data types (1)    
databases (1)    
english query (1)    
grant (1)    
olap server (1)    
openxml (1)    
other (1)    
permissions (1)    
rants (1)    
role (1)    
script (1)    
scripting (1)    
sql puzzles (1)    
system databases (1)    
updategrams (1)    
user (1)    
xml (1)    
xsl (1)