Culture

Technical Article

RE: Four-part names

  • Reply

Must confess I don't use openquery that much, but from what it looks like, openquery doesn't support four part naming..?-- snip BOL --SyntaxOPENQUERY ( linked_server , 'query' ) Argumentslinked_serverIs an identifier representing the name of the linked server.'query'Is the query string executed in the linked server.-- end BOL --Looks to me the expected format is […]

2005-03-16

Technical Article

RE: CACHE HIT RATIO

  • Reply

How much memory do you have in your server. I dont believe dbcc perfmon will give an accurate cache hit ratio in configurations where AWE is enabled. Have tried monitoring the server the performance monitor using the specific sql objects? I wouldn't advise running this continually it eats resources. If you need a cheap and […]

You rated this post out of 5. Change rating

2004-04-22

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

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