SQLServerCentral.com Content tagged SQL Server 7, T-SQL

Check Instance Info

Thu, 15 Dec 2011 07:00:00 UT

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.

Restore database with all necessary files

Wed, 13 Jul 2011 06:00:00 UT

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.

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

Thu, 25 Jun 2009 06:00:00 UT

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.

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

Fri, 19 Jun 2009 06:00:00 UT

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.

Yet Another Deleting Duplicate Records (in-place)

Thu, 15 Jan 2009 07:00:00 UT

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.

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

Wed, 12 Nov 2008 07:00:00 UT

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000

Delimited String Parsing Functions - TwoCol set

Mon, 03 Nov 2008 07:00:00 UT

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.

Delimited String Parsing Functions - Basic Set

Mon, 20 Oct 2008 06:00:00 UT

Feed it delimited horizontal data and it returns it back as a vertical table.

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

Delimited String Parsing Functions - Big Set

Wed, 06 Aug 2008 03:03:20 UT

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.

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

Wed, 06 Aug 2008 02:50:45 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.

Return Query Text Along With sp_who2 Using SQL 2000

Fri, 18 Jul 2008 06:00:00 UT

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Is a Temporary Table Really Necessary?

Fri, 30 May 2008 06:00:00 UT

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.

Restore database with all necessary files

Wed, 13 Jul 2011 06:00:00 UT

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.

Running a Query Using a Text File for Input

Mon, 14 Jan 2008 07:00:00 UT

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Check Instance Info

Thu, 15 Dec 2011 07:00:00 UT

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

Thu, 01 Nov 2007 06:00:00 UT

In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).

Tracing Deadlocks

Fri, 06 Apr 2007 06:00:00 UT

New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.

Running a Query Using a Text File for Input

Mon, 14 Jan 2008 07:00:00 UT

Table Variables

Tue, 21 Nov 2006 07:00:00 UT

New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.

Attach and Detach..Again

Fri, 23 Jun 2006 06:00:00 UT

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!

Is a Temporary Table Really Necessary?

Fri, 30 May 2008 06:00:00 UT

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.

Encrypting Data With the Encrypt Function

Mon, 29 May 2006 06:00:00 UT

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.

SQL 2000 DBA Toolkit Part 4

Thu, 04 May 2006 06:00:00 UT

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.

Troubleshooting SQL Server with the Sysperfinfo Table

Fri, 21 Apr 2006 06:00:00 UT

Joe discusses why he prefers command line tools over GUI, then launches into a how-to about querying sysperfinfo to resolve performance issues. Couple nice sample queries included!

Beginning SQL Server - Limit Your Queries

Fri, 14 Apr 2006 06:00:00 UT

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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Stored Procedure vs Triggers

Fri, 31 Mar 2006 06:00:00 UT

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.

Measuring SQL Performance

Fri, 23 Dec 2005 07:00:00 UT

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.