Analysis Services (SSAS)

Optimizing Your Cube's Schema

• by Don Church

• SQLServerCentral.com

• Design and Theory

• Article

This article written by Don Church discusses how to optimize your cubes schema, its worth a read.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-26

9,163 reads

• Discuss

Unknown Full-Text failure

• by JeffBham

• MSDN Communities

• Topic

I am running SQL Server 7.0 and I have about 8 different full-text catalogs; which some are small and some are very large. Basically I run an incremental population every night, which has been running successfully, but recently I've started to get an unknow full-text failure error. Rebooting the server worked last time but that's […]

2002-03-21

Indexes

• by bryan99y

• SearchSQLServer

• Topic

Can a Temporary Table be indexed ? (7.0, 2000)

2002-03-20

2 reads

Error executing from VB a transfer object task

• by gfirpo

• SearchSQLServer

• Topic

Hi, I have this problem: there is a package that executes a transfer object task to copy a db to another; I use a VB program to execute the package; this program handle the events from DTS. executing the package from a VB program I catch this strange error (in the OnError routine): Error code: […]

2002-03-18

Disallowing duplicate entries across columns

• by Raymond-Kim

• Database Journal

• Topic

Greetings . . . I am a newbie to this forum (and relatively new to SQL Server), so please bear with me. I want to import a large number of records into a SQL Server 2000 database. My concern is as follows: I do *not* want to allow import of duplicate data that spans multiple […]

2002-03-13

2 reads

DMO bug - column default is always empty

• by Brian-Lockwood

• JumpStartTV

• Topic

i'm calling sqldmo from vb client. all properties seem to work fine except "Default" if you instantiate a column object Dim objCol as sqldmo.Column set objCol = objSQLServer.Databases(n).Tables(n).Columns(n) msgbox objCol.Default you will get empty string even though column does have a default. all other properties will be fine. PLEASE note that variable instantiation, sql server […]

2002-03-11

12 reads

transaction LOG size

• by NelsonVere

• Database Journal

• Topic

I have a transaction log with 3 GIGA of size and I need to change to 1 GIGA well, I try this: alter database ITHD MODIFY FILE (NAME = 'ITHD_LOG', SIZE = 1000 MB) GO and I'm getting this error: MODIFY FILE failed. Specified size is less than current size. what should I do to […]

2002-03-11

6 reads

Stored Procedure: Date calculations using Datediff

• by sdugan

• SQLServerCentral.com

• Topic

Please excuse my igonorance as I am new to SQL. My question is this: there is a stored procedure that claculates the remaining payments in a lease using the datediff function. datediff(month,@as_of_date, #lease_scheds.end_date) remaining term Unfortunately, it returns negative values that we would like to be = to 0. It seems like it should be […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-04

31 reads

slow connect time with port 137 blocked

• by wardzilla

• SQLServerCentral.com

• Topic

Hello, My firm is developing an Active Server Pages application that connects to SQL Server 2000(SP1) from an IIS web server through a firewall using ADO. My client wishes to block port 137 at the firewall for security reasons. However, this causes performance to degrade dramatically. In this configuration, it takes 5 seconds just to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-04

178 reads

DTS Mail Task

• by cafemar1

• MSDN Communities

• Topic

Add e-mail task to a DTS pkg and the task completed fine, but the e-mail got to the operators blank. Right e-mail, Subject OK, date OK, but text blank. Any suggestion why this could be happening? I tried to add an ActiveX Script task and the task was completed, but the e-mail never got to […]

2002-03-01

2 reads