It's time to calibrate the people that are sending you the data.

Thanks for posting, sir. I did happen to try that on a development sql box that is version 14.0.2002.14 (2017) and it doesn't seem to work though. At first,...

• This reply was modified 6 years, 9 months ago by Jeff Moden. Reason: EDIT:  Scratch my last about the errors... I now see where you said no errors were produced

NOLOCK isn't to prevent locks... it's to prevent from waiting for locks to be released when you're doing reads.  You've kind of overridden that because the SELECT is in a...

If your presentation layer is SSRS, then using underscores in your column names makes life easier, IMHO.  Now I'm using 2008 SSRS, but when I drop a column name...

I really would recommend that you back up to a different folder, rather than giving access to the Administrator area.  Something on a different server would be best -...

Trigger.

On that same note, I'd also change the datatype for "IsBillable" and "IsActive" to TINYINT and use a 1 for "Yes" and a 0 for "No" along with...

Last but certainly not least, there is no way that I'd ever include spaces or other special characters in the columns so as to make them require brackets....

While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for...

Got it.  Thanks for the feedback.

I know it sounds crazy but I just went through something similar just 15 minutes ago.  The problem was that the SQL Service wasn't started.  When I manually started it,...

I guess my question would be... if you have to keep Postgre in sync with the SQL Server data, why are you using Postgre???

You are more than a year behind on SQL Server cumulative updates.  I can only imagine but would suspect that you're probably behind on Windows Updates, as well.  If for...

Just to be sure, it wasn't meant as any kind of slam for missing something, Phil.  I absolutely thought it excellent emphasis on a problem that would...

You could, however, lookup how...