Analysis Services (SSAS)

Technical Article

TSQL - Encoded Characteristic Functions

  • Topic

A few years back some training emerged on someting called Encoded Characteristic Functions(ECF) The training is offered by DCI (Digital Consulting Institute (formerly Digital Consulting Inc.) I would like to hear from anyone who has taken it on it's usefulness, relevance to SQL 2000.

You rated this post out of 5. Change rating

2001-09-10

42 reads

Technical Article

replicating over WAN's

  • Topic

Hi, I require some assistance on structuring my DB tables for replication. We (hypothetically) have a client with 2 branches, one each side of the country, linked over a WAN and replicating at an unspecified period (1 day OR 1 hours OR ..and so on ). Branch A produces a client record with the primary […]

You rated this post out of 5. Change rating

2001-09-10

Technical Article

Sql Server

  • Topic

I have one table in my database Employee There are three columns in employee table and in table i have 10 records.Now I want to create new table having the columns which are in Employee Table But i don't want when i create table using the employee table the records resides in employee table should […]

2001-09-06

3 reads

Technical Article

DTS Package not running

  • Topic

I have a DTS package in SQL 2000 that uses an Execute process task. Basically, I have a compiled VB app that cleans up data files before they go are loaded into the SQL tables. The job runs fine in the DTS window, but when you schedule it, it seems to get hung up on […]

2001-08-07

3 reads

Technical Article

DSN settings for ODBC connection to SQL 7 Server

  • Topic

I am new to this forum and I have a question regarding ODBC settings. I am trying to set a System DSN connecting to a MSSQL 7 server using local sql server accounts, but I am trying to authenticate using a Domain account that is in active directory. I tried using the format: domain\UID but […]

You rated this post out of 5. Change rating

2001-07-24

14 reads

Technical Article

Last modified date

  • Topic

How do I find out when the table or a database was last modified? I mostly want to find out if my user community is using the database still. The other question is when I tried to sp_addalias 'nhayner' , 'dbo' and got: User or role '\nhayner' already exists in the current database. I don't […]

You rated this post out of 5. Change rating

2001-07-21

4 reads

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