Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag sql server 7 Rss

Search for any content tagged sql server 7

   Items 1 to 20 of 941    Older >>

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: | Category: administration
Rating: |  Discuss |   Briefcase | 10,507 reads

SQL Server 7 Build List

A list of builds and versions for SQL Server 7.  Read more...
By Steve Jones 2010/08/26 | Source: | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 285 reads

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,514 reads

Sending E-mail from SQL Server 200X

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.   Read more...
By Additional Articles 2009/07/01 | Source: DevX | Category: database mail
Rating:  Rate this |   Briefcase | 4,736 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: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,840 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: | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,029 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: | Category: error handling
Rating: |  Discuss |   Briefcase | 6,631 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,865 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: | Category: perl
Rating: |  Discuss |   Briefcase | 2,767 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 336 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,713 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: | Category: administration
Rating: |  Discuss |   Briefcase | 40,497 reads

SQL Server Security: Pros and Cons of Application Roles

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.   Read more...
By Brian Kelley 2008/07/25 (first published: 2003/08/27) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 39,995 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: | Category: sql server 7
Rating: |  Discuss |   Briefcase | 7,719 reads

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.   Read more...
By Randy Dyess 2008/07/18 (first published: 2005/05/30) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 37,157 reads

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...
By Paul Ibison 2008/06/27 (first published: 2004/06/17) | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 59,982 reads

Oracle and SQL Server Data Interoperability Issues - Part 1

As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.   Read more...
By Haidong Ji 2008/06/06 (first published: 2004/04/14) | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 45,610 reads

XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000)

SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.  Read more...
By Jacob Sebastian 2008/06/04 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 3,995 reads

Is a Temporary Table Really Necessary?

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.   Read more...
By Randy Dyess 2008/05/30 (first published: 2002/04/09) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 65,548 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 66,023 reads
   Items 1 to 20 of 941    Older >>