Viewing 15 posts - 9,316 through 9,330 (of 49,571 total)
What's the exact version you're working with (output of SELECT @@version)?
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...
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...
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...
April 14, 2014 at 4:16 am
It's still an estimated plan. Please can you post the actual execution plan of an execution of that query which is slow
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...
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...
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...
April 14, 2014 at 2:38 am
I believe that the default date settings are based on the server's regional settings.
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...
April 14, 2014 at 2:23 am
So the query, when run in production, returns 0 rows?
April 14, 2014 at 1:24 am
Last try...
GilaMonster (4/7/2014)
April 14, 2014 at 1:00 am
SQL doesn't use the page file, and memory usage is capped by max server memory.
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)?
April 13, 2014 at 3:08 pm
Viewing 15 posts - 9,316 through 9,330 (of 49,571 total)