If you are putting NOLOCK on an INSERT, UPDATE, or DELETE query, that's not going to do anything. SQL doesn't allow NOLOCK on data change operations as it...

My opinion - NOLOCK is not a solution to blocking or deadlocks. NOLOCK is a "band-aid" solution in most cases and in the rare cases it is "needed", there are...

My opinion (note I am NOT a licensing expert) - that falls under an "it depends" scenario. Microsoft probably doesn't care, but your government agency/license may be unhappy with their...

I could be mistaken, but I thought the whole point of backup with checksum meant that the backup would contain a checksum in it for validation of the backup. Basically,...

Possibly a silly question but are the plans exactly the same apart from the estimates? What I mean is are you getting the same seeks and scans across all systems,...

Not quite the same error you got, but same error number - https://dataginger.com/2012/10/07/msg-2555-level-16-state-1-line-1-error-dbcc-shrinkfile-with-emptyfile-option/

Their solution was to restart the SQL instance and try again. It was likely caused by...

That is not a lot to go on. Can you provide sample output and what you have tried? What you provided doesn't tell me enough to give you anything meaningful.

What...

I would recommend asking on a Python forum or a MySQL forum, not a Microsoft SQL Server forum, but that's just me.

But because I'm a sucker, I'll try to help...

You can do that from a stored procedure, but I am pretty sure you can't from a function.

And to be honest, I'm not even sure how you'd do that in...

Brian, just to let you know, I got it to work! The client had not been uploading the correct version of the rdl. I had manually changed one to...

One line makes me shudder:

There is no recipe that does not include some kind of starter (either Poolish or Sourdough starter).

So does Poolish (a recipe) ALSO have a starter? If...

Yeah, so your report builder is too new for that SSRS. Best bet is to change the project configuration to use an older SSRS, which is answer number 2 in...

To add to what Grant says - "generating" a baseline from a point in time is often useless. My recommendation is to use a monitoring tool and gathering metrics over...

A 30 hour rollback kind of makes me think something was using explicit transactions and not committing them and held a connection for a long time. Had that happen on...

To me that sounds like you are using a newer or older version of report builder than the server expects. I would uninstall report builder from your machine, download it...