Well, I hope you both get a little refresh going. I'm feeling a bit more on it today after playing radio all day Saturday (Tour De Tulsa, bike rides...

So which word pairs do...

I wonder why it is that there's always more pressure to "get it done" than there is to "get it done right".

Actually, I know why and the answer generally falls...

can we use the same method in databricks to create group, since for creating workspace local group it doesn't  work as ' create group if not exists group_name ' ...

Had to give this one 5 stars... it should be more.  I've been going through the same thing for quite a while now.  Seems there's no end and I'm starting...

That's pretty much...

It's a telephone system.  They just wanted different ways to evaluate things like doing call duration analysis depending on which client someone was calling about (we handle the calls for...

how big is the table?

if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.

but for anything with volumes BCP or...

As a bit of a sidebar, it's a real shame...

Heh... and so it begins. 🙁

Oh, and the ChatGPT answer suggests using Profiler. That's flat out wrong, assuming SQL Server 2012 or greater....

I'm totally confused...

You must have VIEW DEFINITION permission and I bet I don't. I'm testing this on our cloud based DB from our app provider using my surface laptop and we...

The old article you found in a previous response to your question used sysdepends, which would sometimes miss things depending on the order of creation.  Take a look at the...

1.  I forgot about table partitioning.  That answers my question there.
2. If the database is in the FULL Recovery Model, I recommend temporarily shifting to the BULK LOGGED Recovery Model...

I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job.

CREATE CLUSTERED INDEX...