Communication

Technical Article

Select statement causing blocking

  • Topic

Problem: Have sp with select statement which is blocking an insert statement in another sp. Sps are being executed via two different instances of the same vendor application running on two different virtual machines using the same ID.  Question:  How can a Select statement cause blocking? Server OS: Windows 2000 Server Sql Version: 8.0.818 Applcation […]

You rated this post out of 5. Change rating

2004-11-04

432 reads

Technical Article

RE: MDX Syntax - please help

  • Reply

Well, I finally figured it out myself. At least, I figured out a way to get what I need. It may not be the best way, but it works.For each dimension I want to see this "ratio" for, I need to create a calculated measure (since I cannot figure out how to get it to […]

You rated this post out of 5. Change rating

2004-09-29

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