Viewing 15 posts - 9,316 through 9,330 (of 49,552 total)
What's the exact version you're working with (output of SELECT @@version)?
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
April 14, 2014 at 6:54 am
tony28 (4/14/2014)
I added to WHERE clause also, but there is still Hash Match.Which another recommendation are for this ?
Hash matches aren't a problem, and without an execution plan nothing useful...
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
April 14, 2014 at 6:18 am
Oooh, a sharepoint content database...
Switch the database into simple recovery, checkpoint, checkpoint, checkpoint, (and a few more just to be sure), switch the DB back to full recovery and take...
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
April 14, 2014 at 4:22 am
I'm done.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Error loading execution plan XML file C:\Users\REDACTED\Downloads\plan.sqlplan_1.sqlplan. (SQLEditors)
------------------------------
ADDITIONAL INFORMATION:
There is an error in XML document (599, 33). (System.Xml)
------------------------------
The 'Sort' start tag on line...
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
April 14, 2014 at 4:16 am
What does the error log say?
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
April 14, 2014 at 3:59 am
It's still an estimated plan. Please can you post the actual execution plan of an execution of that query which is 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
April 14, 2014 at 3:43 am
That's an estimated plan, it has no actual row counts or values, and it doesn't even load into Management Studio
TITLE: Microsoft SQL Server Management Studio
------------------------------
Error loading execution plan XML file...
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
April 14, 2014 at 3:18 am
Well the execution plan you posted was from a query which returned 0 rows. If the query you want help with doesn't return 0 rows, then please post an execution...
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
April 14, 2014 at 2:39 am
CheckDB won't fix that.
Either you have metadata corruption or the DB was upgraded from SQL 2000 and someone went messing with the system tables back then.
Script all objects, export 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
April 14, 2014 at 2:38 am
I believe that the default date settings are based on the server's regional settings.
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
April 14, 2014 at 2:25 am
yuvipoy (4/14/2014)
GilaMonster (4/14/2014)
So the query, when run in production, returns 0 rows?
Not everytime that is the problem.
Most of the time it is some millisecond but some time it is nearly...
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
April 14, 2014 at 2:23 am
So the query, when run in production, returns 0 rows?
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
April 14, 2014 at 1:24 am
Last try...
GilaMonster (4/7/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
April 14, 2014 at 1:00 am
SQL doesn't use the page file, and memory usage is capped by max server memory.
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
April 14, 2014 at 12:54 am
Truncate table doesn't affect restores in any way. What exactly are you looking for, proof that truncate table is logged (and hence is rolled forward by a log restore)?
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
April 13, 2014 at 3:08 pm
Viewing 15 posts - 9,316 through 9,330 (of 49,552 total)