Viewing 15 posts - 6,946 through 6,960 (of 49,552 total)
You've never used Performance Monitor before?
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
December 28, 2014 at 11:53 am
That is about the best index. I'd put ID as an include, as it's a bit wasted in the key.
An index seek operation requires a filter predicate. None of your...
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
December 28, 2014 at 11:50 am
Jeff Moden (12/27/2014)
It's actually difficult for me to believe that the front end can't produce or use a UNION ALL
You'll probably find that the senior guru expert development lead decided...
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
December 28, 2014 at 4:08 am
CROSS APPLY?
I'd be seriously considering throwing out such a restrictive framework tbh.
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
December 28, 2014 at 3:56 am
Did you install it? Depending on what options you selected, the client tools may not have been selected by default in the installer.
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
December 27, 2014 at 2:33 pm
Grant Fritchey (12/27/2014)
Lynn Pettis (12/23/2014)
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
December 27, 2014 at 2:29 pm
farrukhhameed786 (12/27/2014)
By using inner join the issue is solved.
If by 'solved' you mean 'changed the meaning of the query and possibly the results', then sure.
I can't understand though why you've...
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
December 27, 2014 at 2:27 pm
Praxo (12/27/2014)
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
December 27, 2014 at 2:26 pm
Why can't you use UNION ALL? It would be the obvious way. There's alternatives, but they're complex
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
December 27, 2014 at 4:42 am
A full set would be preferable, but since that's several steps (and probably weeks of work) away, it can be discussed and debated while getting the needed baselines.
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
December 26, 2014 at 9:20 am
Welsh Corgi (12/26/2014)
I noticed that Page Life Expectancy and Memory utilization are high.
As one would generally like to see.
It seems that that issue is with Bulk Inserts (data warehouse).
What issue?
The...
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
December 26, 2014 at 8:57 am
goussarova (12/26/2014)
I know that i can an update with NOLOCK
No you can't.
Oh, you can put the hint there, but SQL ignores it. Updates are always, without exception, done with exclusive...
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
December 26, 2014 at 8:50 am
Shafat Husain (12/26/2014)
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
December 26, 2014 at 6:06 am
sextonk (12/23/2014)
It is my understanding that is a best-practice. To have multiple data files which are the same size.
It is, for TempDB and only for TempDB. It is 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
December 25, 2014 at 2:38 pm
Shafat Husain (12/25/2014)
No, Simple insert operations does not come under minimally logged operation.Here is a list of all the minimally logged operations.
http://technet.microsoft.com/en-us/library/ms191244(v=sql.105).aspx
Um...
From the very page you linked:
Bulk import operations (bcp,...
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
December 25, 2014 at 2:34 pm
Viewing 15 posts - 6,946 through 6,960 (of 49,552 total)