Viewing 15 posts - 8,296 through 8,310 (of 49,552 total)
I'm saying that's a pretty extreme statement to make, claiming that all subqueries and derived tables cause TempDB overhead (which, btw, would not show as physical reads, they'd show 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
August 2, 2014 at 11:15 am
Daniel Matthee (8/1/2014)
I have learned not to do Inner select as this creates over head on the tempdb on the server.
You have, of course, a reference or an example showing...
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
August 2, 2014 at 10:29 am
There's no easy way (and the link previously given just shows the queries to fetch the missing index information, which is not what was asked)
Grant has, on his blog somewhere,...
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
August 2, 2014 at 9:01 am
Please post new questions in a new thread, don't hijack an unrelated thread
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
August 2, 2014 at 4:30 am
Sean, do you have the actual execution plan for comparison? I've seen obscene row estimations before, I suspect caused by the optimiser thinking that a one-to-many join was a many-to-many...
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
August 1, 2014 at 3:29 pm
About bloody time too.
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
August 1, 2014 at 3:24 pm
Please post new questions in a new thread. Thank you.
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
August 1, 2014 at 8:54 am
That looks like IO subsystem, the page headers are invalid, not something an import could do. Doesn't have to be the drives, could be anything in the IO stack.
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
August 1, 2014 at 7:21 am
Good luck with that.... You're going to likely have a large number of false positives to clear out, not to mention you don't know whether or not the procedures are...
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
August 1, 2014 at 7:09 am
Like2SQL (7/31/2014)
Any comments or experience on moving the files of VLDB's over the net?
Be patient, take a good book.
Or copy the files to an external drive and courier/drive 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
August 1, 2014 at 7:07 am
No. You can get the queries that currently have cached plans by querying the sys.dm_exec_query_stats and sys.dm_exec_sql_text DMVs, but that's all.
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
August 1, 2014 at 7:04 am
Create a logging table.
Add a line into every procedure which inserts or updates that table (your choice) to indicate is has been called.
A year or so later (an entire...
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
August 1, 2014 at 1:39 am
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
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
August 1, 2014 at 1:11 am
Stored procs:
Add a table which records usage. Add a line to each of the procedures which inserts into that table when called (or updates an existing row) to show when...
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
August 1, 2014 at 1:06 am
Michael Valentine Jones (7/31/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
July 31, 2014 at 4:13 pm
Viewing 15 posts - 8,296 through 8,310 (of 49,552 total)