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

Content with tags Stored Procedures, Administration Rss

   Items 1 to 20 of 22    Older >>
 

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

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,081 reads

Pruning

DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.  Read more...
By Steve Jones 2009/02/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 295 reads

Pruning

DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.  Read more...
By Steve Jones 2009/02/25 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 580 reads

Pruning

DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.  Read more...
By Steve Jones 2009/02/25 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 368 reads

Pruning

DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.  Read more...
By Steve Jones 2009/02/25 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 383 reads

Attach and Detach..Again

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!   Read more...
By Andy Warren 2006/06/23 (first published: 2002/04/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,198 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

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,684 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,643 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,821 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,211 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

Nightly Failed Jobs Report

Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.   Read more...
By Gregory Larsen 2002/09/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,533 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,846 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads

Attach and Detach..Again

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!   Read more...
By Andy Warren 2006/06/23 (first published: 2002/04/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,198 reads

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,684 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,643 reads
   Items 1 to 20 of 22    Older >>
 
Tags
t-sql (13)    
sql server 7 (10)    
miscellaneous (6)    
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)    
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)    
xml (1)    
xsl (1)