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

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/06/10 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 42,101 reads

sp_rename and the procedure definition

By Lowell Izaguirre 2014/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,912 reads

Natively Compiled Stored Procedures: What they are all about!

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?  Read more...
By Edward Pollack 2014/08/04 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 8,560 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/06/10 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 42,101 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/06/10 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 42,101 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/06/10 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 42,101 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,332 reads

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,514 reads

Logging and Error Handling for SQL Stored Procedures

Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure  Read more...
By Dwain Camps 2014/01/20 | Source: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 9,534 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 | 7,102 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,176 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,176 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,406 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,210 reads

Variable Default Values to a Stored Procedure (SQL Spackle)

A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.  Read more...
By Dwain Camps 2013/09/03 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,866 reads

Find the most executed stored procedure(s)

Find the most executed stored procedure(s).  Read more...
By Mehernosh 2015/05/01 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 3,560 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,623 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,069 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,536 reads
<< Newer    Items 21 to 40 of 207    Older >>
 
Tags
t-sql (85)    
miscellaneous (21)    
programming (19)    
administration (17)    
sql server 7 (17)    
performance tuning (13)    
advanced querying (9)    
xml (9)    
security (8)    
ado (7)    
sql server 2005 (7)    
parameters (6)    
triggers (6)    
strategies (5)    
configuring (4)    
dynamic sql (4)    
integration services (ssis) (4)    
metadata (4)    
sql-dmo (4)    
update (4)    
visual basic 6 (4)    
backup / restore (3)    
development (3)    
dts (3)    
indexing (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)    
editorial (2)    
encryption (2)    
error handling (2)    
excel (2)    
execute (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)    
business logic (1)    
call stack (1)    
certificates (1)    
changes (1)    
charindex (1)    
coalesce (1)    
columns (1)    
context_info() (1)    
crosstab (1)    
cursors (1)    
data quality (1)    
date manipulation (1)    
dba (1)    
dba code (1)    
ddl trigger (1)    
delete (1)    
dependency (1)    
distributed queries (1)    
doneproc (1)    
drop function (1)    
drop procedure (1)    
dynamic (1)    
ebook (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
english query (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)    
linked servers (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 improvement (1)    
performance monitoring (1)    
permissions (1)    
pivot (1)    
pivottable (1)    
profiler (1)    
query tuning (1)    
recompile (1)    
remote path (1)    
replication (1)    
report (1)    
resultset (1)    
revert (1)    
review (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 code (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)    
version control (1)    
version tracking (1)    
video (1)    
windows azure sql database (1)    
with encryption (1)    
worst practices (1)