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

<< Previous 20    Items 21 to 40 of 164    Next 20 >>
 

True or False

Read more...
By Arup Chakraborty 2010/11/26 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 2,982 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,034 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,575 reads

SP and function dependencies

Extracts all calls to SPs and functions (down to depth of 32)  Read more...
By Peter Sloboda 2010/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,769 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 | 31,933 reads

Get default values of parameters in stored procedures

Helps to get the default value of parameters from stored procedures and functions.   Read more...
By Atif-ullah Sheikh 2010/06/22 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,895 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,499 reads

Stored Procedure Execution

Read more...
By Jason Shadonix 2010/06/09 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 3,989 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,799 reads

Stored Procedure to maintain RSExecutionLog

An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft  Read more...
By Perry Dyball 2010/05/21 | Source: SQLServerCentral.com | Category: rsexecutionlog
Rating: |  Discuss |   Briefcase | 1,614 reads

Slow SP with date parameters solved.

when you use datetime parameters in SPs in the where clause the SP becomes very slow  Read more...
By Virgilio Licovali Bustos Ramirez 2010/04/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,750 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 | 25,027 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,636 reads

Optimization

Read more...
By Paul Randal 2010/03/01 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,005 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 | 3,645 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 | 7,870 reads

Generate stored procedure parameter list based on table order by table

this script does the same as the one publish on 04-12-2009 plus add the number of table you need and it will be sort by table name and ordinal position.  Read more...
By Lebrasseur Jean-Pierre 2009/12/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 740 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,100 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,001 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,495 reads
<< Previous 20    Items 21 to 40 of 164    Next 20 >>
 
Tags
t-sql (78)    
miscellaneous (21)    
programming (18)    
administration (17)    
sql server 7 (17)    
performance tuning (13)    
advanced querying (9)    
ado (7)    
sql server 2005 (7)    
xml (7)    
security (6)    
parameters (5)    
strategies (5)    
triggers (5)    
configuring (4)    
metadata (4)    
sql-dmo (4)    
visual basic 6 (4)    
dts (3)    
dynamic sql (3)    
insert (3)    
installation (3)    
integration services (ssis) (3)    
linked server (3)    
reporting services (ssrs) (3)    
select (3)    
update (3)    
3-tier design (2)    
autogenerate (2)    
backup / restore (2)    
blogs (2)    
chris morton (2)    
codrakon (2)    
database design (2)    
development (2)    
excel (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
search (2)    
sql server 2008 (2)    
temporary tables (2)    
user defined function (udf) (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)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
encryption (1)    
english query (1)    
error handling (1)    
execute (1)    
execution plan (1)    
extended procedures (1)    
find foreign key using sql (1)    
function (1)    
functions (1)    
indexed views (1)    
information_schema.routines (1)    
input (1)    
insert update stored procedure generation (1)    
matrix (1)    
mkproc_createupdate (1)    
mkproc_get (1)    
multiple server (1)    
naming standards (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)    
replication (1)    
report (1)    
resultset (1)    
rsexecutionlog (1)    
schemas/dtds (1)    
script (1)    
semaphore (1)    
service broker (1)    
source control (1)    
split (1)    
splog (1)    
sql puzzles (1)    
sql server (1)    
sql server 6.5 (1)    
sqlclr (1)    
stack (1)    
stress test (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)    
unused (1)    
updategrams (1)    
utility (1)    
video (1)    
views (1)    
with encryption (1)    
worst practices (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.