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

Articles with tag Stored Procedures Rss

Search for any content tagged stored procedures

<< Newer    Items 21 to 40 of 131    Older >>
 

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,798 reads

Changing Text in Multiple Stored Procedures From a Stored Procedure

In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.  Read more...
By Brian Davey 2011/03/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 9,353 reads

Which of Your Stored Procedures are Using the Most Resources?

Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.  Read more...
By Additional Articles 2011/01/31 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,941 reads

Automated Trigger To Require a WHERE Clause

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.  Read more...
By Rahul Kumar Ghosh 2013/08/09 (first published: 2011/01/25) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 16,508 reads

Performance testing and tuning for a beginner

How to test and tune a stored procedure?  Read more...
By Arup Chakraborty 2010/09/10 (first published: 2008/11/17) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,240 reads

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,931 reads

Dynamic creation of Insert, Update, Delete Stored procedures

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table  Read more...
By Deepthi Viswanathan Nair 2010/07/09 (first published: 2009/07/23) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,237 reads

Using Certificates to Sign Stored Procedures

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...
By Jonathan Roberts 2010/06/21 | Source: SQLServerCentral.com | Category: certificates
Rating: |  Discuss |   Briefcase | 7,666 reads

Access variables values from Trigger

Pass variables values from Stored Procedures to Trigger  Read more...
By Tejas Shah 2010/06/09 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 7,881 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,274 reads

Implement a stack in SQL Server using stored procedures

In this article I will show you how to implement a stack.  In programming, stacks are a great way to...  Read more...
By Josef Richberg 2010/01/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,089 reads

Run SSIS packages from remote client with stored procedure

By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.  Read more...
By Jason Rowland 2010/01/12 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 8,048 reads

Undocumented Extended and Stored Procedures

Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...
By Timothy A Wiseman 2009/11/20 (first published: 2008/05/09) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 30,274 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,798 reads

Calling Stored Procedures from .NET Applications

Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!  Read more...
By Additional Articles 2009/10/22 | Source: SimpleTalk | Category: .net
Rating:  Rate this |   Briefcase | 5,243 reads

Using XML to pass and return values to procs

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...
By Steve McRoberts 2009/10/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 10,195 reads

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,931 reads

Dynamic creation of Insert, Update, Delete Stored procedures

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table  Read more...
By Deepthi Viswanathan Nair 2010/07/09 (first published: 2009/07/23) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,237 reads

The Pros and Cons of Stored Procedures

I saw this mentioned on Twitter, and watched it while doing some light editing and scheduling. It’s from TechEd 2009 in LA, and includes a number of MVPs and consultants and even a Microsoft SQL Server program manager. It’s a video, running about 55 minutes...   Read more...
By Steve Jones 2009/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 5,067 reads

The Multi-valued Parameters problem in Reporting Services

Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.  Read more...
Rating: |  Discuss |   Briefcase | 13,593 reads
<< Newer    Items 21 to 40 of 131    Older >>