Agreed. if you are staying in the DB engine, I would use service broker. You can use threading if you have any code outside of the engine, but that does...

Is there a reason for only checking for 20 seconds every half hour? I had to followup on a junior DBA who used a similar approach and ended up...

peck

mummy

Lempster (2/27/2014)

---

Thanks for the replies folks. As JustMarie and EricEyster made opposing arguments, I guess the most important point is to be consistent!

Jeff, I don't see it as much of...

You can, and we do, create multi-column PK on a table, but only...

I didn't consider summary data as caching, but if that is the case, then our systems would never function without it. Analyzing customer trends on TB's of raw data would...

It depends.....mostly on the level of tracking data that you want to keep. If you are storing something minor, then it is probably not an issue to keep it in...

Yep, just saying we have field technicians that restore databases and walk away. Then we get a very upset store manager call back in 2 weeks with the same problem...

GilaMonster (2/26/2014)

---

Yup.

I strongly suspect it's not repairable. The page number the error gives is within the range I'd expect system...

Open SSMS

click on the connect drop down and choose integration services

go to "stored packages" => MSDB

Harley Davidson

then the only thing left is @radius

what are the requirements from the auditor?

Is the lat/long stored as float? you want to make sure all the data types are matching to avoid conversions in the query itself