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 138    Older >>

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.  Read more...
By Additional Articles 2013/07/16 | Source: | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 3,097 reads

Dynamically Download FTP Files Using SSDT

Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools  Read more...
By Sifiso W. Ndlovu 2013/03/11 | Source: | Category: ftp
Rating: |  Discuss |   Briefcase | 7,914 reads

Re-compilation and Its effects on Performance

How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?   Read more...
By at yazdani 2012/06/07 | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,101 reads

Verify SQL Server Stored Procedures are the same on multiple servers

I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.  Read more...
By Additional Articles 2012/04/09 | Source: | Category: stored procedures
Rating:  Rate this |   Briefcase | 4,199 reads

SQL Server stored procedure to generate random passwords

SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.   Read more...
By Additional Articles 2011/11/25 | Source: | Category: security
Rating:  Rate this |   Briefcase | 3,861 reads

CONTEXT_INFO() and the SQL Calling Stack

Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.   Read more...
By Peter Sloboda 2011/08/29 | Source: | Category: context_info()
Rating: |  Discuss |   Briefcase | 4,801 reads

Reporting Services: Adding extra columns / rows to a matrix

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.  Read more...
By Martin Cremer 2011/06/24 (first published: 2008/07/24) | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 25,001 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,816 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 9,368 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,991 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: | Category: delete
Rating: |  Discuss |   Briefcase | 16,530 reads

Performance testing and tuning for a beginner

How to test and tune a stored procedure? 
By Arup Chakraborty 2010/09/10 (first published: 2008/11/17) | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,278 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,972 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,307 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: | Category: certificates
Rating: |  Discuss |   Briefcase | 7,740 reads

Access variables values from Trigger

Pass variables values from Stored Procedures to Trigger 
By Tejas Shah 2010/06/09 | Source: | Category: triggers
Rating: |  Discuss |   Briefcase | 7,912 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: | Category: sql server
Rating: |  Discuss |   Briefcase | 26,447 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,282 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: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 8,083 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 30,422 reads
<< Newer    Items 21 to 40 of 138    Older >>