How can I track down an issue with a locked table, endless query?

I have a table that is periodically getting locked in a manner that I don’t quite understand. I cannot do the following:

select * from thetable select count(*) from thetable 

There are roughly 2,000 records.

I can do the following:

select top 2000 * from thetable select * from thetable where ID = etc. 

Going backwards to find a new record that perhaps was problematic, incrementing the count in chunks until I can finally reproduce it again:

select top 1500 * from thetable order by ID desc select top 1550.... etc. and eventually it gets locked and never finishes the query. 

Query never finishes… have waited 10 minutes. Only resolution is to restart the service.

The related stored procedure that I thought caused the problem I ran manually (it interacts with this table) and the longest time it took was roughly 45 seconds. This particular procedure goes through many phases and is wrapped in a transaction with a try/catch/rollback/commit. There is no explicit locking set on the procedure.

Any direction or guidance to track down the root issue is greatly appreciated.

How to track botnet?

Recently i was searching about botnets and how it work, but i didn’t understand how malware analysis’s track the malware/botnet by there’s trackers and find the infected device/ and i wanna know how malware/botnet trackers work !

enter image description here

How does my car stereo find the album art and album and track names? And how do I stop it?

When I listen to the radio or a compact disc in the car, the stereo sometimes displays the album art and the title of the album and track. Sometimes instead of album art it displays a genre (like “Country”) and a related graphic (like an anonymous model smiling and wearing a cowboy hat). In the case of a c.d. it also displays other information, like “1/12” for the first track on an album with 12 tracks, information about time, and so on.

Usually, everything it says is correct. Sometimes it gets something wrong. For example here’s a photo of the stereo playing the Beatles “Let It Be” but displaying the album art for another album.

enter image description here

It seems plausible that the stereo is reading some of this information from the disc (or from the radio signal). But it seems unlikely to me that the album art is included on the disc, particularly in this case in which incorrect art is displayed. What seems more plausible to me is that when I put in the disc, my car stereo reads information from the disc to identify the disc and then retrieves this information from some database outside of the car.

Wouldn’t this mean that some agency somewhere is logging what music I listen to? Is it doing this when I listen to radio too? Is there any way for me to listen to radio and c.d.’s in the car without this part of the process? For example can I copy the c.d.’s in some way that strips the identifying information from the copy?

And what WOULD be the correct Stack Exchange, or the correct place on the internet, to seek help with this question?

Can my school track me on my home wifi?

I’m slightly paranoid that my school can see what im doing with my personal account on my home wifi. It is a managed device, but we are permitted to take them home and use them for homework and return them the next morning. Is it possible my school can still be tracking me off of my personal account and home wifi? I’m not doing anything to get me in trouble,I would just prefer to not have my school snooping around through my personal account I needed to access. I’m sorry if this wasn’t enough information.

Track your affiliate sales and expenses automatically!

Knowing your figures is the basis of success!

Your success comes from knowing the market situation well!

Nifty Stats is a desktop utility, which automatically in regular intervals downloads the stats from your affiliate programs, affiliates networks, advertising networks. Nifty Stats brings automated statistics right to your desktop for any time frame pre-defined by you – and it shows these stats in real-time and on a regular basis. It is 100% safe and entire communication runs just between your computer and the server of your affiliate program.

Track tens of thousands of affiliate programs, advertising networks and online campaigns!

All your online advertising campaigns tracked in a single window!

Designed for maximum comfort while browsing your programs’ affiliate statistics 24 hours a day, 365 days a year, for example, if you are going anywhere without your PC Nifty Stats will send alerts to your e-mail about your sales and rebills, also it can send you a daily summary report of your sales. Wherever you go, your statistics go with you; the Nifty Stats Desktop and the mobile app for Android make sure you receive updates on any new situation or changes to your statistics.

Hundreds of analyzed situations in a single window!

All your online advertising campaigns tracked in a single window!

It is programmed in the way that it will give you the maximum comfort reading your affiliate statistics of your programs 24 hours daily 365 days in the year, for example, if you are going anywhere without your PC Nifty Stats will send alerts to your e-mail about your sales and rebills, also it can send you a daily summary report of your sales. So nothing is more pleasant than sit somewhere on the train and receiving an SMS message that you got a new sale.

Graphic analysis of sales, expenses, clicks…

Graphs give you a great visual overview of your business!

Nifty Stats offers several graph types which will immediately paint the picture about your products and tell you which sell well and which do not, how much your total sales are, how many impressions, rebills or chargebacks you’ve had, and all this over any period of time and with any frequency you like. The graphs in Nifty Stats also allow you to compare your trading positions with various affiliate programs and advertising networks. The same goes for expenditures – you can immediately see where and how much you spend. Graphs can even show you histories over several years!

Sales forecasts for the upcoming period!

Sales forecasts are a core feature of Nifty Stats

Who wouldn’t want to know how much they will earn the next month? Every good trader needs as much information as possible and it is very important to be able to estimate your future income. Nifty Stats will analyze your current real data downloaded from your affiliate programs and provide a forecast of your possible future earnings.

Nifty Stats is 100% Safe & Secure

Your stats are safe because they are only stored locally on your hard drive and you are the only person who can access them.

We do things our way and we have not joined the companies which offer similar products on cloud platforms or self-hosted platforms. We care about our users and so we go for quality instead of quantity. Safe statistics and safe data is our priority.

Need way to physically track initiative in face-to-face D&D game

Just DM’d my first ever non-online game. We had an absolute blast, 10/10 would play again, but keeping track of initiative in combat was terrible. I had chosen to just list their character names (and enemies) in order on a single index card but they couldn’t see it easily and I kept forgetting who went next. Plus, I had to rewrite it for each new combat bit and it felt like it took too long.

I’m used to roll20’s turn order feature where you can easily advance the order and have a nice highlight on who’s supposed to go next. I like that it’s visible to all players, and how easy it is to remove monsters when they die.

I’d like to find a way to simulate that feature at the table for easier combat. I want to limit the technology at the table, since I want to keep the focus on the roleplay and would rather they weren’t all on computers.

Based on your personal experience playing, what (preferably low-tech) method of tracking turn order can be used to streamline the initiative process?

How to avoid someone to track you by your SIM [closed]

I made a call to someone I do not want to detect me by my SIM card. That call was mistakenly made. As IMEI number is also sent to towers, I need to know what kind of foolproof precaution should be taken to avoid any kind of tracing & tracking via my SIM or IMEI.

Pulling my SIM out of the cell is not a solution if they can still track me by my IMEI which is already sent to the tower when I made a call…so is there any way?

How many possible ways are there to track the location of a mobile phone?

I really need to know the nearest location (and if possible exact) of a mobile phone (Android or iPhone).

Yes, the simplest answer will be with a Google Maps API, but the mobile GPS must be activated and in addition to this the browser must have permissions. I wonder if today it is possible to obtain the location of a phone without the slightest contact with the user.

I understand that the IP address gives a nearby but not exact location, is this true? Is it possible to use OSINT in this situation?

How might we help customers get back on track from a connection timeout message

I’m designing ‘sad path’ scenarios for checkout and I’m trying to design for helping customers when a connection timeout occurs when the checkout hangs trying to connect to our 3rd party credit card payment form.

When this happens the credit payment form could not get loaded in our checkout environment.

A simple solution is to reload the page.

The UX/UI solution I’m putting forward is an alert message that appears on the page and asks the customer to reload the page.

This is my attempt at making the error message more ‘user-friendly’:


A connection error occurred

An error occurred when we were trying to connect to the system.

Please reload the page to try connecting again.

[ Reload page ] <— button


How do people feel about the above message? Any other solutions you can think of?

Thanks.