Viewing 15 posts - 3,016 through 3,030 (of 49,552 total)
You really wouldn't want no locks at all. Rows deleted while they're still being inserted, updates affecting some of the rows they should because the rest are still being inserted,...
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 27, 2016 at 3:03 am
Short answer, you probably can't.
What's the command you ran to restore and what's the exact output?
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 26, 2016 at 10:25 am
Here you go: http://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/
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 26, 2016 at 3:13 am
Computed columns can't be edited. There's no way to make one that you can edit to entered values.
If you want a column that starts as LASTNAME + FIRSTNAME but...
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, 2016 at 7:04 am
Buffer pool extensions are for the data cache, specifically clean pages, not for memory grants for query execution (which is what resource semaphore waits are for)
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, 2016 at 6:57 am
See if this helps, since you don't need anything from the temp_eligibility table other than the row match, there's no point in a join
UPDATE eligibility
SET primary_plan = 0
WHERE EXISTS (SELECT...
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, 2016 at 6:19 am
You determine whether your IO config is at fault well after looking at other, simper things. Like lack or indexes or badly written queries (most commonly the cause of slow...
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, 2016 at 5:43 am
Ok, but the question still stands
GilaMonster (5/20/2016)
Is there a problem with the query? Are the latch waits excessive? Is the query unacceptable slow?
PageIOLatch waits by themselves are not a cause...
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, 2016 at 5:26 am
More likely to be user-created. SQL caches temp tables. To reduce the work needed to allocate new temp tables, when one is dropped (under some circumstances) it is cached as...
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, 2016 at 4:41 am
jonathanmarenus (5/22/2016)
delete <tablename> a
where exists
(
select a.field1, a.field2.........a.field30
intersect
...
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, 2016 at 6:26 am
jc85 (5/24/2016)
Yes, both tables do not have non clustered index.
Well there's the cause of your performance problem.
Start with an index on each table, columns used in the where clause...
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, 2016 at 6:20 am
jc85 (5/24/2016)
SQL Execution Plan is attached as well.
The actual plan please, not estimated.
Though, from the plan it looks like you need a couple of useful indexes.
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, 2016 at 4:36 am
Henning Rathjen (5/24/2016)
first I would try to useCONVERT(char(10),b.start_time,121)
instead of dateadd(dd, 0, datediff(dd, 0, b.start_time)).
String conversions are slower than the date functions for date manipulation, in my testing close on...
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, 2016 at 3:20 am
mynkdby (5/23/2016)
Yes Its more like an exercise and restriction made me think of using other options available, but not sure how to proceed.
Did you try what I suggested?
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, 2016 at 3:07 am
Table definitions, index definitions and execution plan please.
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, 2016 at 3:06 am
Viewing 15 posts - 3,016 through 3,030 (of 49,552 total)