I get an error if there is a disabled index.

Msg 2530, Level 16, State 1, Line 15

The index "IX_[index name]" on table "" is disabled.

Saw AI at FabCon this week. It can be helpful, but it is nothing to worry about yet. Unless everything you develop can be done by a consultant who knows...

It might be a good idea to SET NOCOUNT ON.

I don't know how many resources that takes, but I don't need to see 10,000 messages.

We started using GitHub about 6 months ago. I like it simply because it backs up my work off site. And I like the ability to document with a wiki;...

• This reply was modified 7 months ago by dplaut 49149.

The documentation you point to does not agree with your explanation.

We have a big database. I had to make this change:

SUM(CAST(size AS BIGINT))

Otherwise, nice compact script.

Someone here imported a large text file using ADF, and all the fields ended up as nvarchar(max). I was livid. I don't think the person who did this even bothered...

This is a topic for which I'd very much appreciate a summary to wrap this up. This is new to me. Something in the form of

- instead of this

- do...

When I run that code I don't get an error.

Are the people who said that RDBMS is becoming obsolete information technology computer grads with no experience? I bet they are.

Have a little exercise/contest at work to create a simple...

I'm curious if the answer to this question on stackexchange affects anyone's performance. We are moving to 2022, and Jeff's comment makes me pause.

https://dba.stackexchange.com/questions/333767/new-sql-server-2022-slower-than-old-2014-server

That is the best description of Rank() and Dense_Rank() I've read. Thank you.

Yes, printing at FedEx. Forgot about that.

I use a flash drive especially when I need to transfer something to someone else's computer. e.g. my wife who insists that I don't mess with her computer because she...

I'd like to try SQLAgent but I get a conversion failed error. Can the author take a look a that?