Just a heads up about indexed views - in SQL Server Standard, indexed views must be explicitly requested to use the index. In enterprise the query optimizer will use the...

Just wanted to add, I liked the article. I wasn't trying to criticize it, especially since I've never had the guts to post one on here. I just wanted clarification...

Another thing that ties into what Grant said - if this is SSIS, those 22M rows are likely trying to be stored in memory. If you don't have enough memory...

I am slightly confused by the last example - Integrating NTILE with RANK(), DENSE_RANK(), LAG(), and LEAD(). You have both LAG and LEAD partitioned by EmployeeId and EmployeeID is unique...

Another thing it COULD be is do you have that excel file open in any other tool (Excel for example)? If it is on a shared drive, is the excel...

Good advice... do something out of my comfort zone... RELEASE DIRECTLY TO PROD!!!

Just kidding. My goal is to get back into photography. I kind of dropped out of that for...

Stepping away from TLS being the issue, can you run the isql command with the -v parameter? This will give you verbose output and will tell you EXACTLY what is...

Cyrusbaratt, I am a bit confused why you say that monitoring tools slow things down then suggest Idera, which is a 3rd party monitoring tool (plus a ton of other...

Is that the only error? USUALLY an "unable to connect" is followed by some information about a login issue or a cannot find the host or something along those lines.

BUT...

Wanted to throw my hat into the ring on this - I have done both. In-place upgrades and migration upgrades. My biggest factor in deciding the method is "how many...

No can do in SQL Server according to the docs: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Those state we have 1024 columns max in a table.

You'll need to break it up into multiple tables; probably want...

As a random thought, are you fully patched on both SSRS and SQL Server?

Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the...

I could be dumb, but this really sounds like a homework/assignment style question. That being said, if I asked something like this, my first question would be "what does the...

I suppose that is a good point Jeff. In this specific scenario where the OP is trying to write the file to the server itself, having the data flow from...

One nice thing is that with email notifications, things show up how you would expect. The other fun thing is it happens outside of the code block too:

those above...