R Studio

Technical Article

RE: Easy administration of hundreds of SQL servers?

  • Reply

Hi Steve,we do monitor all the servers with CA TNG Unicenter. That work perfectly by the way. So the DBA-on-24/7-call guy gets the call when something happens to one of the servers and takes care of business.What we really would like is make checking the jobs and logs quicker. Now it takes quite some time to surf […]

You rated this post out of 5. Change rating

2004-11-10

Technical Article

RE: Need help implementing FILO ordering on fixed size database

  • Reply

For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records. To keep the size manageable, we run a job every hour which moves records older than 60 days into an archive database. We used to run it every day […]

You rated this post out of 5. Change rating

2004-06-22

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers