There are functions like ISNUMERIC() and others that can determine if a given value is of that type. However, they're very dependent on exact formats. Most data imports...

It's probably just evidence of a given query exiting cache for whatever reason it exited cache. All the execution DMVs are cache dependent. Any given query that leaves cache, for...

Or, look at a tool like Redgate SQL Compare. That lived open, and in active use, all day, every day, on my machine until I was hired by the...

Yep, what @johan says.

Think internal and external to the database. External to the database, server and OS level stuff, no. It's not there to worry about. Internal to the database,...

Use Extended Events to capture the metrics. That's how I'd do it.

Wait, a deadlock is an error that will clear immediately. It won't lock the server and prevent access. I think you're saying that you're getting blocking that is preventing access....

But, from what I can see, the Payment_ID column matches to a value 67280309 for Reissued_from_payment_id. How do you related it to 33333 when the payment_id for that is 22222?...

Have you identified what query specifically it's trying to run and the structure of that query? Use Extended Events to track that down.

I'm one of those to push myself to learn. I'm often disappointed with myself for not learning more, faster. I think I'm concerned that if I don't push myself,...

My personal challenge workwise is to learn WhereScape and Snowflake to build a warehouse from our two major Health Care systems plus the myriad of one-off systems we have...

I'm having the same problem time-wise.  As the old saying goes, "So say we all". 😀

I also have to admit there's great incentive in learning something new if you...

Thanks Jeff.

Yeah, I'm still at "barely functional" when it comes to PostgreSQL. I made a few fast leaps and then I just haven't been able to carve out time to...

There really is no easy way to about defining table access. The tools you have can show you the queries that have been run and/or the procedures that have been...

Sorry. I was away. Looks like everyone took good care of you. Glad you tracked down the issue.

You can look at sys.dm_db_wait_stats, note, NOT sys.dm_os_wait_stats, to see network waits from the Azure SQL Database side of things. However, otherwise, you have to measure that from the client.