Viewing 15 posts - 1,396 through 1,410 (of 49,552 total)
What happens in the explicit transaction before that Insert Into dbo.TTemp_ActualCreateCPLI?
Because the only way that is holding a lock on TTemp_ChargingCalculationClients, is if there's an explicit transaction and something...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 11:46 am
SELECT TOP(1) <columns>
FROM <table>
WHERE User_Reg_Id_Num_02 = @LoggedInUser and Id_Num > @CurrentId_Num
ORDER BY Id_Num ASC;
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 3:47 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 3:38 am
The only one of those I can definitely answer is the last. If you have SQL Server installed, it must be licensed. If you're not using it, it's your choice. Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We stand on the bridge and no one may pass
May 25, 2017 at 2:45 am
Can you post the actual execution plan please?
Is the query getting blocked? Spending a lot of time waiting?
Those percentages int the plan are not times. They're estimated...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 2:29 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 2:24 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2017 at 2:12 am
The two best kitchen purchases I've made in the last few years: pressure cooker and bread maker.
I can and have made bread by hand, but it was always...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 5:01 pm
Post some examples of what you see and can't interpret, so that we can walk you through the process?
A page contains only rows from a single table, so...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 3:45 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 2:34 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 12:28 pm
What should the query return, based on that sample data?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 6:33 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 6:20 am
Errr...
PAGEIOLATCH_EX is a latch taken when the page is being read into memory so that the insert can occur. If you're seeing these high, there's probably not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 4:34 am
Ok, and you posted it why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2017 at 3:27 am
Viewing 15 posts - 1,396 through 1,410 (of 49,552 total)