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

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

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/02/26 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 1,570 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,315 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,093 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/01/01 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 5,172 reads

SP

By Reema 2012/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,929 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,128 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,168 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,746 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,710 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,866 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: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 24,861 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,786 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,866 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,346 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,918 reads

Stored procedure to script out user permissions

Stored procedure to script out user permissions  Read more...
By Harsha Majety 2011/01/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 4,407 reads

True or False

By Arup Chakraborty 2010/11/26 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 3,025 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,210 reads
<< Newer    Items 21 to 40 of 182    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)    
strategies (5)    
triggers (5)    
configuring (4)    
metadata (4)    
sql-dmo (4)    
visual basic 6 (4)    
backup / restore (3)    
development (3)    
dts (3)    
dynamic sql (3)    
insert (3)    
installation (3)    
integration services (ssis) (3)    
linked server (3)    
reporting services (ssrs) (3)    
select (3)    
temporary tables (3)    
update (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)    
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)    
dependency (1)    
distributed queries (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)    
execution plans (1)    
extended procedures (1)    
find foreign key using sql (1)    
function (1)    
functions (1)    
indexed views (1)    
information_schema.routines (1)    
in-memory oltp (1)    
input (1)    
insert update stored procedure generation (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)    
replication (1)    
report (1)    
resultset (1)    
rsexecutionlog (1)    
schemas/dtds (1)    
script (1)    
semaphore (1)    
service broker (1)    
set options (1)    
source control (1)    
sp_rename (1)    
split (1)    
splog (1)    
sql puzzles (1)    
sql server 2014 (1)    
sql server 6.5 (1)    
sqlclr (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)    
try..catch (1)    
unused (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
video (1)    
with encryption (1)    
worst practices (1)