Reply, SQL Server 2019 and the latest version of SSMS. I changed the length of the output for the media_path column in the import and ensured the length of...

Understood on the SSIS thing but the Op wasn't using SSIS.  For that matter, I typically try to make it so that I never have to use SSIS anywhere.

Having had...

The whole reason for the RBAR of a cursor here is so that you can call the Capture_Inline_Quality stored procedure for each and every bloody row.  That, good sir, is...

FYI made changes in the import wizard and the data imported just fine. I do suggest that when you post a problem, whether here or another site, that you...

I have to ask (as in seriously curious)... you have a half million individually programmed ASP web pages?  What kind of...

Have any of you good folks used the "Automatic Tuning" feature of SQL Server 2016 for on-prem?  If so, how'd it work out for you?

I ask because I have this...

Don't worry about it.  I won't be coming back here for help since all you guys want to do is make excuses for a tool that turns a simple...

Very cool... can you post the code you used to replace the FORMAT function? 😉

And don't use the FORMAT function.  Even relatively complicated functionality created by CONVERT is 38 times (in this case) faster than FORMAT.  Take the time to figure out the alternative...

You didn't have anything like that in the sample data in your original post.

Like Jeff Williams stated, that's not a...

Oh yes... I love Dagwood sandwiches for lunch. 😀

So here's my chance! I'm helping write up a job description for a "Jack of all trades" DBA position. Unfortunately, no, I can't put DBCC TIMEWARP() on it. I've...

Hi Guys,

Problem solved.  Rather than pull my hair out trying to figure out why MS had to take something so simple and turn it into a complicated Charlie Foxtrot,...

Hi all

I use the Ola Hallengren Index Optimize script for rowstore index maintenance in my SQL estate. Recently we have been looking into an issue with our data warehouse...

I don't think including the column name in the PK is a bad idea especially since I do tend to include column names in other indexes.  The only reason why...