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

Content with tags Administration, Stored Procedures Rss

<< Newer    Items 21 to 24 of 24   
 

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,837 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,852 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,592 reads

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first published: 2001/05/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,852 reads
<< Newer    Items 21 to 24 of 24   
 
Tags
t-sql (13)    
sql server 7 (10)    
miscellaneous (7)    
configuring (4)    
programming (4)    
installation (3)    
security (3)    
triggers (3)    
advanced querying (2)    
backup / restore (2)    
database design (2)    
dts (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
performance tuning (2)    
sql-dmo (2)    
strategies (2)    
user defined function (udf) (2)    
visual basic 6 (2)    
basics (1)    
dba (1)    
distributed queries (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
english query (1)    
function (1)    
indexed views (1)    
openxml (1)    
replication (1)    
search (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 6.5 (1)    
sqlclr (1)    
tables (1)    
updategrams (1)    
utility (1)    
views (1)    
xml (1)    
xsl (1)