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

Content with tag SQL Server 7 Rss

<< Newer    Items 21 to 40 of 987    Older >>
 

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

Enhancing the readability of your code: Table aliasing in sql

When writing SQL, picking good tables aliases can greatly enhance the readability of your code  Read more...
By Sylvia Moestl Vasilik 2009/05/07 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,824 reads

Read_Only Database

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

From the Real World: SQL Server 2000 SP4 Installation Failure

SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes  Read more...
By Praveen Voleti 2009/03/04 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,019 reads

Yet Another Deleting Duplicate Records (in-place)

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.  Read more...
By Peter Petrov 2009/01/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,847 reads

Get Error Description in SQL Server 2000

How to Extract Error Description in SQL Server 2000 based on Error Number  Read more...
By Mudassar Ahmed Khan 2009/01/13 | Source: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 6,580 reads

Tables referenced by a stored proc (2000)

This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.  Read more...
By David McKinney 2008/12/30 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 984 reads

Proxy Accounts in SQL Server

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them  Read more...
By Additional Articles 2008/12/30 | Source: Database Journal | Category: proxy accounts
Rating: (not yet rated)  Rate this |   Briefcase | 3,436 reads

Powering up DTS with PerlDTS

This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.  Read more...
By Alceu Rodrigues de Freitas Junior 2008/12/22 | Source: SQLServerCentral.com | Category: perl
Rating: |  Discuss |   Briefcase | 2,765 reads

The Full Potential of SQL 2000

Attending a conference and hearing about all the latest and greatest new features is a bit like spending holiday sampling exotic seafood and imbibing strange new cocktails. When you return, you're decidedly in the mood for a pie and a pint of beer.  Read more...
By Tony Davis 2008/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 334 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.  Read more...
By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,264 reads

Compare Dates in an iterative manner for a particular set of records

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000  Read more...
By Divya Agrawal 2008/11/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,700 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,138 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,593 reads

Find the port no Get Port SQL Server 2000

This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL  Read more...
By Ganesh Pittala 2008/08/09 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 842 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,277 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 456 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,972 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,251 reads
<< Newer    Items 21 to 40 of 987    Older >>
 
Tags
administration (333)    
miscellaneous (124)    
performance tuning (121)    
t-sql (115)    
security (105)    
news (99)    
configuring (83)    
dts (76)    
programming (69)    
strategies (64)    
monitoring (55)    
sql server 2005 (55)    
replication (44)    
backup / restore (34)    
sql server 6.5 (33)    
indexing (31)    
advanced querying (25)    
visual basic 6 (23)    
installation (21)    
database design (18)    
stored procedures (17)    
disaster recovery (dr) (16)    
best and worst practices (14)    
distributed queries (14)    
service packs (13)    
ado (12)    
basics (12)    
sql-dmo (12)    
triggers (11)    
availability (9)    
worst practices (9)    
xml (8)    
.net (7)    
data warehousing (7)    
reviews (7)    
best practices (6)    
career (6)    
naming standards (6)    
other (6)    
product reviews (6)    
upgrading (6)    
analysis services (ssas) (5)    
bugs (5)    
rants (5)    
system development life cycle (5)    
access (4)    
advanced (4)    
counter (4)    
development (4)    
nums (4)    
sqlinsider scripts (4)    
table of numbers (4)    
tally (4)    
user defined function (udf) (4)    
arrays (3)    
asp (3)    
delimited strings (3)    
maintenance (3)    
maintenance and management (3)    
olap server (3)    
parse (3)    
sqlmail (3)    
state of the business (3)    
string manipulation (3)    
alias data types (2)    
auto-growth (2)    
automated dba (2)    
certifications (2)    
data file management (2)    
databases (2)    
english query (2)    
full-text search (2)    
logins (2)    
openxml (2)    
permissions (2)    
routine database growth (2)    
routine growth (2)    
sql server 2008 (2)    
storage (2)    
updategrams (2)    
utility (2)    
xsl (2)    
backup / recovery (1)    
book reviews (1)    
build list (1)    
capacity planning (1)    
compare t-sql (1)    
content difference table (1)    
data types (1)    
database mail (1)    
database roles (1)    
database weekly (1)    
date manipulation (1)    
dependencies (1)    
design and theory (1)    
differential backup (1)    
dmo (1)    
editorial (1)    
enterprise manager (1)    
error handling (1)    
grant (1)    
integration services (ssis) (1)    
jobs (1)    
linked server (1)    
lock and connection management (1)    
meta data services (1)    
metadata (1)    
notification services (1)    
passwords (1)    
perl (1)    
powershell (1)    
proxy accounts (1)    
random numbers (1)    
registered servers (1)    
restore (1)    
role (1)    
schemas/dtds (1)    
script (1)    
scripting (1)    
scripts (1)    
setup (1)    
sql agent (1)    
sql puzzles (1)    
sql server 2000 (1)    
sqlservercentral (1)    
syscomments (1)    
sysobjects (1)    
system databases (1)    
table (1)    
table aliases (1)    
user (1)    
writing readable code (1)    
xp_sendmail (1)