I know it seems like a strange question because the answer may seem obvious but why are you doing this?  If the answer is to do supposed "Best Practice" index...

Depending on AI is like listening to the news.  It is more opinion than fact.  It is by its very nature biased by the beliefs and desires of those...

I want to run this script on the server itself. I don't have a SQL Server for administrative purposes. Can I adapt this script for this purpose or is...

I have a sql statement that checks for certain special characters in a string and returns that.

SELECT

CASE

WHEN (LEN(DSC1) - CHARINDEX(char(1), DSC1)) <> LEN(DSC1) THEN '[DSC1 -...

Not sure but you may also have to for the language to "English", as well.

Heh... Ok... I'll bite.  Is it? 😉

I also wonder why people do this type of thing to perfectly good relational data.

I'd...

Nah... I gotta agree... face time is better than any of that.

I don't mind giving online presentations at all because I don't do much differently.  During in person presentations, I actually tell people not to look at me but, rather, to...

BWAAA-HAAAA!!!  So you've been watching him...

Lordy.  Thanks for the feedback on that.  It's very timely as I was going to actually try column store on a table or two and then put them into...

Hello @jeff

I was referring Oracle in the context to explain how we "were" doing things until date & how the demand from new Solution provider to use WAIT(NOLOCK) with...

I think too many people think that a mentor should be a full time personal instructor.  That's not how it is and that's why a lot of people don't want...

If you look at the agile manifesto it lists the principles in terms of x over y.  For example people and processes over tools and technologies. It is explicit...

Hello @Grant

Thank you very much. I've read about snapshots at StackOverFlow and few other places, however, my primary concern is not truly answered.

I would pry you to give me...