Viewing 15 posts - 2,326 through 2,340 (of 2,645 total)
Another thing you could do, provided your database isn't really busy and the stored procedures aren't massive is occasionally force a recompile of all of them by issuing a DBCC...
August 6, 2018 at 6:05 am
Does this qualify as the longest question https://www.sqlservercentral.com/Forums/1982386/Cursor-object-running-when-FETCHSTATUS-0?
August 5, 2018 at 4:19 am
August 5, 2018 at 4:09 am
DECLARE @errorcode NVARCHAR(40);
/********* Cursor definition with outer join of [F03B11Z1] WITH [F0911Z1] ********/
DECLARE @Col1 int,
@Col2 nvarchar(5)
--...
DECLARE Invoices1 CURSOR FOR...
August 5, 2018 at 4:06 am
In SSMS, you can click on the jobs folder of the Object Explorer (press...
August 3, 2018 at 10:00 am
SELECT DB_NAME(st.dbid) DBName,
OBJECT_SCHEMA_NAME(st.objectid, dbid) SchemaName,
OBJECT_NAME(st.objectid,dbid) StoredProcedure,
Max(cp.usecounts) Execution_count
INTO #slowrunningqueries
FROM...
August 3, 2018 at 6:27 am
I found one formatter online, but wanted to know if you use any tools to...
August 2, 2018 at 10:09 am
If it's just stored procedures you are trying to find performance problems with. I use this stored procedure, then execute it.
It lists all the stored procedures with how many...
August 2, 2018 at 9:24 am
August 1, 2018 at 12:00 pm
August 1, 2018 at 8:02 am
I understand what the cross applys are...
August 1, 2018 at 2:47 am
It's producing results on my database.
July 31, 2018 at 6:40 pm
This seems awesome!
The problem is I ended up having to manually create the...
July 31, 2018 at 5:39 pm
Viewing 15 posts - 2,326 through 2,340 (of 2,645 total)