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

Content with tags T-SQL, Administration, SQL Server 7 Rss

   Items 1 to 20 of 67    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,537 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

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,684 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,202 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.   Read more...
By Michael Coles 2006/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,011 reads

Beginning SQL Server - Limit Your Queries

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...
By Steve Jones 2006/04/14 (first published: 2004/08/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,910 reads

Execution Plans

How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.   Read more...
By Gulappa Vijaya Kumar 2005/10/07 (first published: 2004/05/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 51,541 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,263 reads

Push FTP with SQL Server

DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.   Read more...
By Steve Jones 2005/07/01 (first published: 2001/11/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 36,508 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,374 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,813 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,789 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,690 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part II

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.   Read more...
By Brian Kelley 2004/12/31 (first published: 2002/03/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,624 reads

Getting the Most out of SQL Server 2000's Query Analyzer, Part I

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.   Read more...
By Brian Kelley 2004/12/23 (first published: 2002/02/21) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,607 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,712 reads

Beginning SQL Server - Limit Your Queries

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...
By Steve Jones 2006/04/14 (first published: 2004/08/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,910 reads

Case Sensitivity in Selects - Part 2

In this follow up Andy looks into some of the options available when you're dealing with situations where you're joining a case sensitive column to a case insensitive column. We think after reading this you'll be ready to just say no!   Read more...
By Andy Warren 2004/06/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,319 reads

Case Sensitivity in Selects - Part 3

See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.   Read more...
By Andy Warren 2004/06/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,338 reads
   Items 1 to 20 of 67    Older >>
 
Tags
miscellaneous (26)    
advanced querying (13)    
configuring (13)    
programming (11)    
stored procedures (10)    
strategies (10)    
monitoring (9)    
performance tuning (7)    
database design (6)    
security (5)    
backup / restore (4)    
indexing (4)    
installation (4)    
visual basic 6 (4)    
dts (3)    
sql-dmo (3)    
triggers (3)    
auto-growth (2)    
automated dba (2)    
data file management (2)    
maintenance (2)    
maintenance and management (2)    
naming standards (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
user defined function (udf) (2)    
utility (2)    
.net (1)    
basics (1)    
best and worst practices (1)    
databases (1)    
distributed queries (1)    
english query (1)    
grant (1)    
logins (1)    
openxml (1)    
permissions (1)    
product reviews (1)    
replication (1)    
reviews (1)    
role (1)    
script (1)    
scripting (1)    
service packs (1)    
sql puzzles (1)    
system development life cycle (1)    
updategrams (1)    
user (1)    
worst practices (1)    
xml (1)    
xsl (1)