Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: stored-procedures

MySQL -> Loop through a table, running a stored procedure on each entry

By adminPosted on February 1, 2023

Question : I have a database with ‘books’ (short stories for children) and it would be extremely informative to have […]

stored procedures location influence their performance?

By adminPosted on January 31, 2023

Question : I have a procedure SP_MYPRO that updates data in MYDB1. 1) the performance of SP_MYPRO would be different […]

Facing permission error while trying to execute a stored procedure published through CLR

By adminPosted on January 29, 2023

Question : I’ve created a stored procedure using SQL CLR c# stored procedure in Visual Studio 2017 and I’ve published […]

SQL Server, ServicerBroker for asynchronized execution of stored procedures

By adminPosted on January 29, 2023

Question : I followed this tutorial: https://gallery.technet.microsoft.com/scriptcenter/Using-Service-Broker-for-360c961a and it is working for me, However, I don’t understand some thing: At […]

Inner procedure is rolled back but outer procedure is still committed

By adminPosted on January 28, 2023

Question : I have an outer procedure which calls 5 different inner procedures something like Parent procedure(Tran/try/catch) Inner sp1 (Tran/try/catch) […]

Is ASYNC_NETWORK_IO wait type anything to worry about?

By adminPosted on January 28, 2023

Question : In looking at the list of stored procedures that take long time to execute, one stands out as […]

How to make stored procedure with outputs OUT sys_refcursor, OUT varchar2, and OUT number, then use in c#.net app

By adminPosted on January 26, 2023

Question : What is the syntax for a stored procedure that outputs a refcursor, a varchar2, and a number? I […]

SQL Server Management Send Mail as Part of a Job

By adminPosted on January 25, 2023

Question : I have a SQL Job that I would like to send an email through, but for some reason […]

metadata could not be determined because stored procedure contains dynamic SQL

By adminPosted on January 24, 2023

Question : I have a stored procedure that contains some dynamic SQL. I am trying to execute the stored procedure […]

Can sp_BlitzFirst pass the @ExpertMode parameter to sp_BlitzWho [closed]

By adminPosted on January 23, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

  • 1
  • 2
  • 3
  • …
  • 92

Recent Posts

  • Using postgres to select a filtered array
  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding