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

   Items 1 to 20 of 202    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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 reads

Signing options

By Steve Jones 2015/02/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,534 reads

Recompile in a stored procedure?

By Ben Kubicek 2015/02/17 | Category: recompile
Rating: (not yet rated) |  Discuss |   Briefcase | 1,689 reads

Signing Procedures

By Steve Jones 2015/02/09 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,489 reads

Performance Improvement for Cursors in Stored Procedures

Exploring some differences between using cursors, local fast forward cursors and using set logic.  Read more...
By Brian Hibbert 2015/02/03 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 8,614 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: SQLServerCentral.com | Category: version tracking
Rating: |  Discuss |   Briefcase | 5,647 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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 reads

Debugging Natively-Compiled Stored Procedures Statements

Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.  Read more...
By Additional Articles 2014/12/15 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 6,399 reads

EXECUTE

By Steve Knox 2014/12/09 | Category: execute
Rating: (not yet rated) |  Discuss |   Briefcase | 1,833 reads

Using Stored Procedures to Provide an Application’s Business-Logic Layer

When faced with a complex business application, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. Here's how they did it.  Read more...
By Additional Articles 2014/12/01 | Source: SimpleTalk | Category: business logic
Rating:  Rate this |   Briefcase | 8,449 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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 reads

DONEPROC

By Kshitij Satpute 2014/10/22 | Category: doneproc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,435 reads

Create a stored procedure

By Jaime Padrón 2014/10/15 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 2,025 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,316 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,011 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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 reads

sp_rename and the procedure definition

By Lowell Izaguirre 2014/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,884 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,469 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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 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/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,898 reads
   Items 1 to 20 of 202    Older >>
 
Tags
t-sql (84)    
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)    
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 (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)    
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)    
with encryption (1)    
worst practices (1)