There is no guarantee of ordering when selecting from a table without an ORDER BY

You are welcome and good luck.

Take notes, and we'd love to see an article if you get this working. Would help others.

Top are GF cookies, and they break apart quickly.

Were you able to create this certificate in master or on any instance? I've had some issues with certificates in SQL Server as it doesn't seem to support every format...

I'm with Jeff. sp_lock or sys.dm_tran_locks should tell you if anyone has a lock on the table, meaning they're using it.

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-ver15

Frederico and Mike have things to think about. This is almost always IO driven, so the more IO you can throw at it, the better. Even if you restore the...

Maybe you (sram24_mca) could explain more about why you asked the question or what you are thinking here.

Is this the type of thing you're looking for?

https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929

LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

Now my FIL, I'm not...

Shifting gears a bit, today's editorial on Routine has a broken discussion link.  The editorial is all about the changes people are having to make because of recent world...

Not sure if you like cooking, but it's something that's...

Good catch. Added the quotes to the SELECT.

That example doesn't need quotes for the connect.  However, in selecting a value, it needs to be valid. In this case, the original...

When we had our cyber attack back in June 2017, everything was offline and it was reported internally that it was costing the business $50m p/h. We were offline...

Going up or down? I wonder these days. For the supermarket,...

I think that query from scdecade might not work with multiple of the same. If I add two rows of  (5,4), I get a return.

This requirement (

"there should only be...