Thanks guys.  The coalesce solution is what I needed.  Phils solution would work, except I want to return an empty string if there's less than 2 characters.

I guess i should say the goal here is to do a :

left(column1,len(column1)-2)

and I'm trying to account for Null or Empty fields so the left function doesn't...

I didn't know of the new persisting sample percent feature.  Thanks for that info.  I found a query that shows the date statistics were updated and days since last update. ...

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

I may not have had to rebuild them, but doing a full sample on the statistics definitely fixed the slowness.

Should I have to do a full sample on...

I may not have had to rebuild them, but doing a full sample on the statistics definitely fixed the slowness.

Should I have to do a full sample on the statistics...

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

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 5 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 5 years, 5 months ago by Jackie Lowery.
• This reply was modified 5 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?