.NET

Technical Article

RE: Joins vs one flat table

  • Reply

I always start normalized, then if I find a problem I can't solve using that structure I look at alternatives. In the scenario you describe, an indexed view might be a good alternative. Andy http://qa.sqlservercentral.com/columnists/awarren/

You rated this post out of 5. Change rating

2003-05-11

1 reads

Technical Article

RE: Not display a text if the DB record is empty

  • Reply

Jeremy 1. unfortunately, it did not accept the "!" before "isNull"! 2. On the other hand, trying -without- the "!", it rejected the "<" and the ">" around the "objRS("faxnr")" expression at the "then" option (but this wouldn't be -The- problem). I really did not "get the idea" of WHY the system rejected it... Sincerely […]

2003-05-09

Technical Article

RE: Merge - Partial record sents

  • Reply

Sub A won't get any of the changes being uploaded from Sub B. The reason is that SQL Server first has to upload all the data from the subscribers and then merge the data and resolve any conflicts the before they can generate new entries in sysmerge_contents, sysmerge_genhistory etc. So when Sub A is starting […]

2003-05-08

Blogs

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...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

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