this is one of those times where the query store can really help you (maybe)

if you can find that query in the query store (maybe as a regressed query) then...

100 % you can - all you have to do is make sure the unc path has the correct permissions for the account that is running the backup (normally the...

This really depends on your requirements (you haven't really given us enough to work on)

I would go for a single instance, especially if you are using linked servers in any...

I've had an argument with my ex partner in the past, she claimed that women were discriminated against in the software world.

the truth is that I don't care if you...

it looks like this could be a simple merge statement, maybe that's what they were looking for, but I agree with jeff..

last time I looked the GP data came embedded in the Clinical care group data (CCG) - but it's been 2 years since I touched that stuff - it was...

this might help

https://www.apexsql.com/sql-tools-plan.aspx

if you get Redgate sql prompt , there is an option to expand *

I believe if you look at apexsql website you might also find a free tool that also...

As far as I can see DBCC Dropcleanbuffers won't allow you to specify a database

but dbcc freeproccache can drop individual plans - if you can identify the plan handles by...

I'm sure someone will have a better solution, but I can only see this being done with a cursor and dynamic sql

you'll need a table mapping <fineamount> to whatever the...

• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).
• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).

post the command you are executing , we probably can't help you without the original syntax

try this - its just a guess

IF (DATE_PART('DOW',CURRENT_DATE) IN ('3','6'))

begin

(put brackets around your evaluation)

are you using visual studio or sql management studio ?

I can't replicate the issue

have you tried

declare @result

select @result=substring(@pippo,256,10)

can you post the code  in text format  please - its easier than all of us manually typing it in