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 41 to 60 of 191    Older >>
 

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,899 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,794 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

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,351 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,932 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

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

True or False

By Arup Chakraborty 2010/11/26 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 3,034 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,227 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,922 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,819 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 | 32,230 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 | 2,021 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,656 reads

Stored Procedure Execution

By Jason Shadonix 2010/06/09 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,039 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,876 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,790 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...
Rating: |  Discuss |   Briefcase | 2,794 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 | 26,230 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,745 reads
<< Newer    Items 41 to 60 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)