SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stored Procedures Rss

   Items 1 to 20 of 268    Older >>
 

String Replace in Stored Procedures with Powershell

Find a string in a stored procedure and replace with powershell  Read more...
By Michael D'Spain 2018/11/13 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Embrace Stored Procedures

Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.  Read more...
By Steve Jones 2018/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 547 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,703 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 reads

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?  Read more...
By Additional Articles 2018/04/13 | Source: MSSQLTips.com | Category: stored procedures
Rating:  Rate this |   Briefcase | 5,176 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2018/10/24 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 76,355 reads

Stored procedure parameters

By Igor Micev 2017/03/30 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 1,409 reads

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 375 reads

EXECUTE as SELF

By Steve Jones 2017/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,199 reads

Execute As Security

By Steve Jones 2017/01/06 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,078 reads

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.  Read more...
By Additional Articles 2016/12/08 | Source: SQLPerformance.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 4,659 reads

Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.   Read more...
By Nicholas Williams 2016/12/05 | Source: SQLServerCentral.com | Category: email
Rating: |  Discuss |   Briefcase | 2,628 reads
   Items 1 to 20 of 268    Older >>
 
Tags
t-sql (91)    
miscellaneous (21)    
programming (19)    
administration (18)    
sql server 7 (17)    
performance tuning (14)    
security (11)    
advanced querying (9)    
xml (9)    
sql server 2005 (8)    
ado (7)    
parameters (7)    
triggers (6)    
integration services (ssis) (5)    
strategies (5)    
temporary tables (5)    
backup and restore (4)    
configuring (4)    
dynamic sql (4)    
indexing (4)    
metadata (4)    
sql-dmo (4)    
update (4)    
visual basic 6 (4)    
development (3)    
dts (3)    
function (3)    
insert (3)    
installation (3)    
linked server (3)    
reporting services (ssrs) (3)    
search (3)    
select (3)    
views (3)    
3-tier design (2)    
autogenerate (2)    
blogs (2)    
chris morton (2)    
codrakon (2)    
crosstab (2)    
database (2)    
database design (2)    
editorial (2)    
encryption (2)    
error handling (2)    
excel (2)    
execute (2)    
functions (2)    
maintenance and management (2)    
monitoring (2)    
pivot (2)    
powershell (2)    
recompile (2)    
scripts (2)    
sp_rename (2)    
sql server (2)    
sql server 2008 (2)    
sqlclr (2)    
statistics (data) (2)    
user defined function (udf) (2)    
xsl (2)    
.net (1)    
adventureworks2012 (1)    
alert (1)    
app_name (1)    
arrays (1)    
asp (1)    
autogenerate parameters (1)    
automatic (1)    
automation (1)    
azure (1)    
basics (1)    
best and worst practices (1)    
big data (1)    
business logic (1)    
call stack (1)    
certificates (1)    
changes (1)    
charindex (1)    
cluster (1)    
cluster analysis (1)    
clustered index (1)    
coalesce() (1)    
columns (1)    
comments (1)    
context_info() (1)    
cursors (1)    
data dictionary (1)    
data flow task (ssis) (1)    
data lake (1)    
data mining (1)    
data quality (1)    
data science (1)    
data warehouse (1)    
database mail (1)    
date manipulation (1)    
db_mail (1)    
dba (1)    
ddl trigger (1)    
delete (1)    
dependency (1)    
disk space (1)    
distributed queries (1)    
doneproc (1)    
drive space (1)    
drop function (1)    
drop procedure (1)    
dynamic (1)    
dynamic email (1)    
ebook (1)    
edis (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
email (1)    
embedded table (1)    
english query (1)    
enhanced data integration suite (1)    
etl (extract, transform, and load) (1)    
execute as (1)    
execute sql task (1)    
execution plans (1)    
expressions (1)    
extended procedures (1)    
find foreign key using sql (1)    
fn_listextendedproperty (1)    
fnord (1)    
foreach (1)    
foreach loop container (1)    
ftp (1)    
ftp connection (1)    
fun (1)    
google (1)    
html (1)    
html table (1)    
indexed views (1)    
information_schema.routines (1)    
in-memory oltp (1)    
input (1)    
insert update stored procedure generation (1)    
last accesses (1)    
linked servers (1)    
list (1)    
local path (1)    
matrix (1)    
merge (1)    
mkproc_createupdate (1)    
mkproc_get (1)    
multiple result sets (1)    
multiple server (1)    
naming standards (1)    
native compiled (1)    
nested loop (1)    
notification (1)    
object_id (1)    
openxml (1)    
output (1)    
palalelism (1)    
parameter (1)    
parsing (1)    
passwords (1)    
performance improvement (1)    
performance monitoring (1)    
permissions (1)    
pivottable (1)    
profiler (1)    
query tuning (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)    
servers (1)    
service broker (1)    
set options (1)    
slowly changing dimension (1)    
source code (1)    
source control (1)    
sp_depends (1)    
sp_sproc_columns (1)    
split (1)    
splog (1)    
sql (1)    
sql puzzles (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server 6.5 (1)    
sql server data tools (ssdt) (1)    
stack (1)    
stress test (1)    
string replace (1)    
sys.dm_exec_cached_plans (1)    
sys.dm_exec_sql_text (1)    
syscolumns (1)    
syscomments (1)    
sysobjects (1)    
system (1)    
system development life cycle (1)    
system health (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
template (1)    
text search (1)    
token stream (1)    
try..catch (1)    
unknown groups (1)    
unused (1)    
updategrams (1)    
user-defined data types (1)    
u-sql (1)    
utility (1)    
variables (1)    
version control systems (vcs) (1)    
video (1)    
windows azure sql database (1)    
with encryption (1)    
worst practices (1)