Hello Jeff.

Thanks for the reply and aplogogies for not replying sooner - my account is not linked to my work email and not checked my personal emails for a while...

Thanks Frederico for the quick reply. I will work though that example to understand what it is doing (Not used Outer Apply to date). I think that the Top 1...

OK - I think it is now working as before.

It is working in SSMS 18.8 but not n SSMS 18.4 - I am not sure what has happened to the...

As it turns out a really simple way to see appears to be to open a New query window in SSMS.

I honestly have not noticed until this discussion that it...

Thanks Jeffrey.

I had not come across that before.

Regards

Steve O.

Thanks Brian.

That 2nd link is what confused me as I started with that and I could not find that version listed anywhere and could not figure out what CU level...

Believe me Jeff I know next to nothing - other than what I learn from you guys - and lose the plot a little sometimes when it comes to the...

Hello Jeff.

Sorry, I was referring to the Compatability Level of the individual DB - not the version/patch level of SQL.

A lot of...

Having found multiple references to the statement that FTS is enabled by default in SQL Server 2008 and cannot be disabled, I am wondering if the fact that these databases...

• This reply was modified 3 years, 11 months ago by  SteveOC.

I ran this query - it was sub-second - and returned 4 rows where the word 'blah' had a space before and a space after it

select * from rsitem where...

We hit a problem when our  2014 SQL instance went from Standard to Enterprise to enable more Memory,

Everything was slow - but I had been pushing for DBLEVEL changes forever...

Thanks for the reply Frederico - which gave me a kick in the right direction....

Adding those predicates returned no results - looks like I have been confusing myself and went...

Having thought about this as I pressed send I thin that it is actually just telling me what that Users Default DB is in the Login Properties.

Which seems to imply...

Thanks Grant - I will take a look and have gleaned some clues.

I have identified a number of issues but the Tranactions/Sec Count does not seem to be related it...

Hello.

The Enterprise server has multiple large databases in it and each has 1 or more web portals plus services and a large employee user base hitting it.

The server in question...