2013-12-19 (first published: 2007-08-27)
15,978 reads
Deepthi Viswanathan Nair
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
33,021 reads
2008-09-09
1,051 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,113 reads
Generate Stored Procedure/Functions Script with SP
It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.
2007-03-23 (first published: 2007-03-14)
2,068 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
448 reads
Blogs
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore...
Understanding Disk Performance and IOPS in cloud platform
By nelsonaloor
In the past many years, apart from working as DBA, I was working with...
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...
Forums
How to make join to teams display without join all teams ?
problem How to make left join to only teams displayed dynamically depend on fields...
sql server memory buffer cache building up question
question for DB Gurus when sql server is restarted, it will be slow at...
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Ask SSC