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, Advanced Querying Rss

   Items 1 to 17 of 17   
 

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,734 reads

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.  Read more...
By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 3,920 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,543 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

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

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...
By Jeffrey Yao 2004/06/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,607 reads

Creating a System Stored Procedure

Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.   Read more...
By Robert Marda 2004/05/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,226 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,543 reads

The SQL Server Black Box

Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.   Read more...
By Brian Knight 2003/04/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,279 reads

Utilizing fn_virtualfilestats

In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.   Read more...
By Chris Kempster 2002/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,948 reads

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.   Read more...
By Brian Knight 2002/06/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,896 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

Executing a script from SQL Server

Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.   Read more...
By Steve Jones 2001/10/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,371 reads

DBCC SQLPERF (Logspace) Reporting Internals

This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.   Read more...
By Additional Articles 2001/09/17 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,542 reads

Undocumented T-SQL Tricks With Logs

An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.   Read more...
By Brian Knight 2001/06/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,397 reads

Quickly Enabling and Disabling Constraints and Triggers

In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.   Read more...
By Brian Knight 2001/05/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,045 reads
   Items 1 to 17 of 17   
 
Tags
sql server 7 (13)    
monitoring (2)    
stored procedures (2)    
backup / restore (1)    
configuring (1)    
dba (1)    
dts (1)    
maintenance and management (1)    
performance tuning (1)    
sql server 2005 (1)    
sql server 2008 (1)    
strategies (1)    
system development life cycle (1)    
triggers (1)