Yes, you were right.

Thanks for the tips

Actually... The problem came back...

I tried to connect as "sa" through SSMS and that seemed fine.

I had renamed my PC and my login in SQL Server...

Did you check compilation time?

February 20, 2017 at 1:40 am

#1929315

>> "Does this actually matter for any purpose?"

Yes, because this stored procedure is used in an Intranet application and it makes the application very slow occasionally.

The...

Tried it but does not make a difference to what I see in profiler...

Is there any reason to think I might get a different result from extended events?

This is the one my...

Someone at works tells me he has experience of http://www.dpriver.com/pp/sqlformat.htm and likes it.

Since we don't have much time for experimentation, we might give that one a shot first.

I like the...

Very good question!

The honest answer is a mixture of the followings

1) our coding standards is a document of too many pages (IMHO) so it becomes difficult to follow (I wrote...

Thanks 🙂

In 2014, there was no Tabular with Standard Edition, however you got it with "Business Intelligence" edition, which seems to have disappeared in 2016.

And in 2016 Standard Edition, we don't...

This is brilliant for small businesses!

Is it new in 2016, or did I miss it in 2014?

I am still using 2012...

To be entirely honest, the objection is to Automated Unit Testing, not "manual" Unit testing.

So yes, there is a cost...

Maybe one day we will...

Our management gets very upset if they find we spend time writing tests...

:doze:

Thanks Steve,

I indeed investigated tSQLt further and really liked it!

We use Visual Studio development and tSQLt integrates pretty well with it as it would with Redgate I'm sure.

Following best practice...