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

Content with tags stored procedures, t-sql Rss

<< Newer    Items 41 to 60 of 100    Older >>
 

Implementing a T-SQL semaphore

SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.   Read more...
By Robert Cary 2006/10/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,772 reads

Self Eliminated Parameters

Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.   Read more...
By Alex Grinberg 2006/10/09 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,062 reads

Adding In HTML Links

While the strength of SQL Server is not in string manipulation, it can be very handy when backing a web site to be able to automatically include links for some of your content. New author Grey Wilson brings us an easy technique to easily deliver results to developers with URLs embedded inside.   Read more...
By Grey Wilson 2006/08/08 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 5,556 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

Introduction to the ADO Connection Object

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,956 reads

Stored Procedure vs Triggers

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.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,955 reads

The Zero to N Parameter Problem

T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.   Read more...
By Sloan Holliday 2006/02/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 11,757 reads

How to Build Dynamic Stored Procedures

Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!   Read more...
By Robert Marda 2005/12/16 (first published: 2003/04/25) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 48,981 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

Dynamic SQL or Stored Procedure

We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.   Read more...
By Andy Warren 2005/08/26 (first published: 2003/04/23) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 47,227 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

Customized Output Labels

SQL Server has some great solutions for writing reports easily, ensuring quick service for your customers. However many of the quick ways of generating reports from the database include the column headers in the results. And often clients who expect customized work want to see labels that are more familiar to them. Leo Peysakhovich has developed a way that allows him to easily return custom labels from his stored procedures.   Read more...
By Leo Peysakhovich 2004/10/14 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 5,776 reads

Stored Procedure vs Triggers

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.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,955 reads

Be Prepared - Part 2

Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.   Read more...
By Stefan Popovski 2004/06/08 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,955 reads

Capturing The Error Description In A Stored Procedure

Error handling is one of those things that is simple to do in SQL Server, but most people don't do it and it's not the most rebust thing. Here's another way that you can implement error handling in your stored procedures from a new author Amit Jethva.   Read more...
By Amit Jethva 2004/04/27 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 20,346 reads

How to Make Sure You Have Good Passwords

As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.   Read more...
By Robin Back 2004/03/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,626 reads

Output Parameters

Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.   Read more...
By Robert Marda 2007/10/26 (first published: 2003/11/25) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 31,779 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

Code Stored in Files Instead of Stored Procedures

This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)   Read more...
By Narayana Raghavendra 2003/10/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,068 reads
<< Newer    Items 41 to 60 of 100    Older >>
 
Tags
miscellaneous (20)    
programming (18)    
sql server 7 (16)    
administration (13)    
advanced querying (9)    
performance tuning (9)    
xml (8)    
ado (7)    
security (5)    
strategies (5)    
configuring (4)    
sql server 2005 (4)    
sql-dmo (4)    
triggers (4)    
visual basic 6 (4)    
dts (3)    
installation (3)    
linked server (3)    
backup / restore (2)    
database design (2)    
development (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
xsl (2)    
::fn_listextendedproperty (1)    
asp (1)    
basics (1)    
best and worst practices (1)    
coalesce (1)    
columns (1)    
dba (1)    
distributed queries (1)    
dynamic sql (1)    
english query (1)    
find foreign key using sql (1)    
indexed views (1)    
insert update stored procedure generation (1)    
naming standards (1)    
openxml (1)    
palalelism (1)    
parameters (1)    
replication (1)    
schemas/dtds (1)    
search (1)    
semaphore (1)    
source control (1)    
sql puzzles (1)    
sql server 6.5 (1)    
sqlclr (1)    
stress test (1)    
syscolumns (1)    
sysobjects (1)    
system development life cycle (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
worst practices (1)