I found that i can add:

@StatisticsSample = 100 ,

to the script.  I run this script on Fridays at 10PM.  Is there any reason I shouldn't set the...

I finally found what i was doing that had sped up the query.  I rebuilt the index manually.  Normally, my indexing is done by Ola Hallengren's maintenance scripts, but it...

Now I'm really confused. The problem seems to have come back.  It's taking 4 to 5 seconds again.  If I remove the TOP 1 part it returns 32 rows.   When...

• This reply was modified 4 years ago by  Jackie Lowery.

Oddly enough, rebuilding the indexes on the wspkg and wspkglin tables fixed the issue.

If the value passed matches the histogram for 66,000 rows, wouldn't the estimate  be high not low.  Again, I'm stupid on this, so sorry if I'm not asking the wrong...

Again.  Thanks for the help.  I don't understand why the estimate is so low.  There's a big difference between 1200 rows and 66,000 rows.  It causes a problem when displaying...

I did a statistics up date with FULLSCAN, so the statistics should be good.  Can you elaborate on recompiling or picking a different plan for the lower row counts?

These are the queries i ran.  Is this correct?

SELECT ddsp.last_updated

FROM sys.dm_db_stats_properties(OBJECT_ID('dbo.gbkmut'), 19) AS ddsp;

SELECT *

FROM sys.dm_db_stats_histogram(OBJECT_ID('dbo.gbkmut'), 19) AS ddsh;

The stats last updated:  2020-07-08 15:58:45.7233333

Histogram is attached.

• This reply was modified 4 years, 5 months ago by  Jackie Lowery.
• This reply was modified 4 years, 5 months ago by  Jackie Lowery.

Thanks for in info.  That helps greatly.  Which system databases can i restore?  I would assume i can't restore the 2012 system databases to the 2016 server.  Is there any...

Like a visual studio code store?

Also. If your parsing EDI docs for an ERP you should look for an EDI system that already has templates built to import the data in the format your ERP...

I do EDI for work. You should look for a solution that can parse the docs for you. We use datamasons. Trying to build a solution to parse all of...

To add to Phil,

You can also highlight and object in the object explore and then hit F7 to open Object Explorer Details.

Once in the OED you can navigate to...

Crap.  I googled it, but didn't search for the right terms apparently.  Thanks guys.

The only way i know to transfer a query right now is to select each one individually in SSMS and use the Script View As functionality.  Is there a way...