Technical Article

sql7sp4-server (winnt4sp6a) to much paged

  • Topic

Can anyone help me with this one. I'm trying to determine why this sql7sp4-server (winnt4sp6a) is eating op more than 900Mb VM (560MbMemusage).This gradualy grows, but I cannot determine why. There are no open transactions.(Maybe cut and paste this back in notepad) ** syscacheobjects -- prepared objects ** **-------------------------------------** bucketid    cacheobjtype      objtype  objid       dbid   uid    refcounts   […]


4 reads

Technical Article

RE: updating data

  • Reply

How exactly does using NOT EXISTS make it more robust? (Im not saying your wrong, just like to understand it ;)) If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!



InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs


Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers