Viewing 15 posts - 3,631 through 3,645 (of 49,552 total)
Mine! (again, unless there's another taker)
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
February 9, 2016 at 11:53 pm
I'll take it, unless there's someone else who wants it desperately. I need a reason to play with it.
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
February 9, 2016 at 11:51 pm
etl2016 (2/9/2016)
Is there a way, a parallel execution of these 10 CTAS statements be enforced programmatically or does the Query optimiser engine take care of this automatically?
The CTAS statements will...
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
February 9, 2016 at 1:53 pm
ScottPletcher (2/9/2016)
That sounds like Oracle not SQL Server. SS doesn't have CTAS syntax.
It's SQL Server Parallel Data Warehouse aka APS, or the Azure version of it, Azure DWH. CTAS...
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
February 9, 2016 at 1:51 pm
There should be a time in the XML, it'll be an attribute of the event tag.
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
February 9, 2016 at 1:48 pm
Work through the method described here: https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Yes, it's out of date, no I haven't got around to updating it with Extended Events. It's still valid, you can use Extended Events...
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
February 9, 2016 at 1:47 pm
Be careful. Data-accessing scalar functions can be horrifically slow. Avoid using it in a select/insert/update/delete and it should be OK.
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
February 9, 2016 at 6:39 am
Have you got any evidence that spinlocks are the problem, as opposed to inefficient queries?
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
February 9, 2016 at 2:04 am
For anyone reading this who doesn't memorise error numbers.
Error 833: SQL Server has encountered <n> occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [<full path...
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
February 9, 2016 at 2:03 am
Err, no. It means exactly what I said, separate IO subsystems.
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
February 8, 2016 at 8:44 am
No. SQL's rules are that data modification statements are atomic, they either complete entirely or fail entirely.
You'll need extra logic in the insert to ensure that SQL only tries to...
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
February 8, 2016 at 8:42 am
DROP_EXISTING and ONLINE aren't properties of an index. They're just options you put onto create or alter index to change the way that statement behaves. They don't persist, they have...
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
February 8, 2016 at 5:22 am
Put a new line inside you code tags (which is a good idea in general, for readability)
select a.*, (select max(Startdate)
from @b-2 b
where b.id=a.id and...
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
February 8, 2016 at 5:07 am
What exactly do you mean by 'relational index options'?
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
February 8, 2016 at 5:04 am
Is that in an MS Access form/report?
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
February 8, 2016 at 4:24 am
Viewing 15 posts - 3,631 through 3,645 (of 49,552 total)