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, T-SQL Rss

   Items 1 to 20 of 138    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,598 reads

Check Instance Info

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.  Read more...
By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,415 reads

Proc to Rename a file

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.  Read more...
By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,771 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,314 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 | 548 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

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,848 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

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,279 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

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,686 reads

Proc to Rename a file

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.  Read more...
By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,771 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 65,486 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,314 reads

Running a Query Using a Text File for Input

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.   Read more...
By Roy Carlson 2007/03/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,117 reads

Check Instance Info

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.  Read more...
By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,415 reads

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

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).  Read more...
By Yakov Shlafman 2007/11/01 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 1,623 reads

Tracing Deadlocks

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.   Read more...
By Shiv Kumar 2007/04/06 (first published: 2004/04/06) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 43,482 reads
   Items 1 to 20 of 138    Older >>
 
Tags
administration (56)    
miscellaneous (44)    
performance tuning (38)    
advanced querying (25)    
programming (18)    
configuring (16)    
stored procedures (16)    
security (13)    
strategies (13)    
monitoring (12)    
visual basic 6 (8)    
database design (7)    
backup / restore (6)    
indexing (6)    
sql server 2005 (6)    
counter (4)    
development (4)    
dts (4)    
installation (4)    
nums (4)    
sql-dmo (4)    
sqlinsider scripts (4)    
table of numbers (4)    
tally (4)    
triggers (4)    
user defined function (udf) (4)    
.net (3)    
arrays (3)    
basics (3)    
delimited strings (3)    
naming standards (3)    
parse (3)    
sql server 6.5 (3)    
string manipulation (3)    
xml (3)    
ado (2)    
auto-growth (2)    
automated dba (2)    
best and worst practices (2)    
data file management (2)    
maintenance (2)    
maintenance and management (2)    
openxml (2)    
replication (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
updategrams (2)    
utility (2)    
worst practices (2)    
xsl (2)    
alias data types (1)    
databases (1)    
date manipulation (1)    
distributed queries (1)    
english query (1)    
grant (1)    
logins (1)    
news (1)    
permissions (1)    
product reviews (1)    
restore (1)    
reviews (1)    
role (1)    
schemas/dtds (1)    
script (1)    
scripting (1)    
service packs (1)    
sql puzzles (1)    
system development life cycle (1)    
table (1)    
user (1)