Viewing 15 posts - 1,141 through 1,155 (of 5,843 total)
nari.koud (4/20/2016)
There are frequent SELECT, UPDATE, BULK INSERTS happening in DatabaseA- Tables and Heavy blocking is...
April 20, 2016 at 9:59 am
Chris-475469 (4/19/2016)
I'm not new to being a DBA, just new to my current role and have been given this process to look at.
The INSERT statements are the biggest offenders...
April 20, 2016 at 7:36 am
1) What you have posted goes WAY WAY WAY WAY beyond free help from a forum.
2) You need to find out which of those steps is taking the longest...
April 19, 2016 at 8:25 pm
tcronin 95651 (4/19/2016)
April 19, 2016 at 6:49 am
Atif-ullah Sheikh: why would you want to pay the price of building two clustered indexes on (potentially hugely fat) temp tables only to hit them once each? That is almost...
April 19, 2016 at 6:36 am
Like I said, you may not be able to do anything about this if the root cause is that your old box had poor IO and the new one is...
April 19, 2016 at 6:31 am
Jeff Moden (4/18/2016)
Good discussion but still off the rails. Anyone going to help the OP? 😉
At 11:09am two days ago I gave the OP 2 things to try (although...
April 18, 2016 at 7:33 pm
tcronin 95651 (4/18/2016)
April 18, 2016 at 7:26 pm
tcronin 95651 (4/18/2016)
April 18, 2016 at 12:27 pm
If the function you mention is a Scalar or Multi-StatementTVF UDF then those will void the use of parallelism, which clearly can make things slower with the volume of data...
April 18, 2016 at 12:22 pm
It's absolutely not coding "laziness". It's simply to allow for data type changes later without causing performance issues in the code.
Completely disagree with the first sentence. And even more vehemently...
April 18, 2016 at 11:14 am
ScottPletcher (4/18/2016)
TheSQLGuru (4/16/2016)
New rule: YOU WILL, ALWAYS WITHOUT EXCEPTION, USE EXACTLY THE SAME DATA TYPE AS THE COLUMN TO THE BEST OF YOUR LANGUAGES ABILITY TO DO SO!
THAT IS A...
April 18, 2016 at 9:39 am
I tell clients to only run statement completed profiler traces for a VERY short period when they want to see just how truly horrific Scalar and Multi-StatementTVF User Defined Functions...
April 17, 2016 at 9:55 am
Jeff Moden (4/15/2016)
The original post is pretty clear. Everything flies when the last condition is removed even though a...
April 16, 2016 at 10:09 am
ScottPletcher (4/15/2016)
TheSQLGuru (4/15/2016)
ScottPletcher (4/15/2016)
Never use ISNULL in a WHERE or JOIN clause.
Whether the column is nullable or not is irrelevant.
The proper way to code this:
where isnull(SalesOrderID,-1) =...
April 15, 2016 at 11:54 am
Viewing 15 posts - 1,141 through 1,155 (of 5,843 total)