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

Content with tag Stored Procedures Rss

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

Find the most executed stored procedure(s)

Find the most executed stored procedure(s).  Read more...
By Mehernosh 2013/08/30 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,326 reads

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.  Read more...
By Nakul Vachhrajani 2013/08/29 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,535 reads

usp_tableReference

Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.  Read more...
By Ankush Parab 2013/08/12 | Source: SQLServerCentral.com | Category: sp_depends
Rating: |  Discuss |   Briefcase | 1,042 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,506 reads

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: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 2,987 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,649 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: SQLServerCentral.com | Category: ftp
Rating: |  Discuss |   Briefcase | 7,858 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,054 reads

Search All Stored Procedures in a Database

Search for a text in all the stored Procedures in a Database  Read more...
By George Varkey 2013/01/04 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 3,431 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/10/09 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 2,249 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2013/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,329 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: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,095 reads

Stored Procedures Performance

This script summarizes the execution statistics of the stored procedures which was run on the current database in the last 7 days.  Read more...
By Adnan Korkmaz 2014/10/01 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,816 reads

SP

By Reema 2012/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,940 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: MSSQLTips.com | Category: stored procedures
Rating:  Rate this |   Briefcase | 4,140 reads

System Proc sp_SysMon to monitor sql server health

I created as a system proc but it can be executed individually. It will print some system health counters.  Read more...
By Gokhan Varol 2012/01/31 | Source: SQLServerCentral.com | Category: system health
Rating: |  Discuss |   Briefcase | 2,180 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: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,764 reads

ITX_SP_BAK

Creates a single sql install file for all stored procs in a database.  Read more...
By Sean Brian 2011/10/14 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 509 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: SQLServerCentral.com | Category: context_info()
Rating: |  Discuss |   Briefcase | 4,732 reads

consolidated script generator for multiple stored procedures

Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go  Read more...
By Partha Pal 2011/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,873 reads
<< Newer    Items 21 to 40 of 191    Older >>
 
Tags
t-sql (81)    
miscellaneous (21)    
programming (19)    
administration (17)    
sql server 7 (17)    
performance tuning (13)    
advanced querying (9)    
xml (9)    
ado (7)    
sql server 2005 (7)    
parameters (6)    
security (6)    
triggers (6)    
strategies (5)    
configuring (4)    
integration services (ssis) (4)    
metadata (4)    
sql-dmo (4)    
update (4)    
visual basic 6 (4)    
backup / restore (3)    
development (3)    
dts (3)    
dynamic sql (3)    
insert (3)    
installation (3)    
linked server (3)    
reporting services (ssrs) (3)    
select (3)    
temporary tables (3)    
3-tier design (2)    
autogenerate (2)    
blogs (2)    
chris morton (2)    
codrakon (2)    
database design (2)    
encryption (2)    
error handling (2)    
excel (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
search (2)    
sql server (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
views (2)    
xsl (2)    
.net (1)    
::fn_listextendedproperty (1)    
adventureworks2012 (1)    
arrays (1)    
asp (1)    
autogenerate parameters (1)    
automatic (1)    
automation (1)    
backup / recovery (1)    
basics (1)    
best and worst practices (1)    
call stack (1)    
certificates (1)    
charindex (1)    
coalesce (1)    
columns (1)    
context_info() (1)    
crosstab (1)    
data quality (1)    
date manipulation (1)    
dba (1)    
dba code (1)    
delete (1)    
dependency (1)    
distributed queries (1)    
doneproc (1)    
drop function (1)    
drop procedure (1)    
dynamic (1)    
ebook (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
english query (1)    
execute (1)    
execute sql task (1)    
execution plans (1)    
expressions (1)    
extended procedures (1)    
find foreign key using sql (1)    
foreach loop container (1)    
ftp (1)    
ftp connection (1)    
function (1)    
functions (1)    
indexed views (1)    
information_schema.routines (1)    
in-memory oltp (1)    
input (1)    
insert update stored procedure generation (1)    
local path (1)    
matrix (1)    
mkproc_createupdate (1)    
mkproc_get (1)    
multiple server (1)    
naming standards (1)    
native compiled (1)    
nested loop (1)    
object_id (1)    
openxml (1)    
palalelism (1)    
parsing (1)    
passwords (1)    
performance monitoring (1)    
permissions (1)    
pivot (1)    
pivottable (1)    
profiler (1)    
query tuning (1)    
remote path (1)    
replication (1)    
report (1)    
resultset (1)    
rsexecutionlog (1)    
schemas/dtds (1)    
script (1)    
semaphore (1)    
server name (1)    
server password (1)    
server user name (1)    
service broker (1)    
set options (1)    
source control (1)    
sp_depends (1)    
sp_rename (1)    
split (1)    
splog (1)    
sql puzzles (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server 6.5 (1)    
sql server data tools (1)    
sqlclr (1)    
ssdt (1)    
stack (1)    
statistics (1)    
stress test (1)    
sys.dm_exec_cached_plans (1)    
sys.dm_exec_sql_text (1)    
syscolumns (1)    
sysobjects (1)    
system development life cycle (1)    
system health (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
temp tables (1)    
token stream (1)    
try..catch (1)    
unused (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
variables (1)    
video (1)    
with encryption (1)    
worst practices (1)