In order to process a cube, you must first process the dimensions. I start with the rule of processing shared dimensions first, non-shared dimensions second and the fact table last. In order to isolate your problem I suggest processing in this sequence manually. You may get lucky and find the dimension that is causing the […]
2004-05-11
1 reads
We've automated a number of our FTP transmit and receipt jobs using WS_FTP Pro, and it has a a passive mode switch.http://www.ipswitch.com/MattieNH
2004-05-10
If I understand your question correctly (obtain 50 rows via email), have your 'partner' export the 50 rows to a comma or tab delimited text file, zip it and then send it to you. When you receive it, unzip and bcp in or bulk insert into your table. Sounds so easy, I'm almost sure I'm […]
2004-05-10
2004-04-21
In SQL Server there are two large categories of roles: database and server. The sysadmin role is a server role. While we can create user-defined database roles, server roles are fixed. The list of built-in roles: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_6ndx.asp
2004-04-15
Please first tell me. Are you currently using SQL Server Yukon? Here is the answer to your question with assumption of SQL2K in use.Create views with different date ranges. You should able to provide two different column names in the two different views. If you provide more details of what compell you to use different […]
2004-04-09
Hello allJust had a weird thing happen at a client's installation. Long story short, we determined that DBNETLIB.DLL had magically gone missing, causing one of our production applications to fail. No viruses, this was on a secured production server with no access available except to us and the local admin guy.Has anyone ever seen this […]
2004-04-06
11 reads
That would alos be a good solution. Since I have a select statement that defines the tables I need to copy, I can pass the list to a table, temp table, sursor, etc. I am mystified about how I get that result set into DTS so it can use it.
2004-04-01
First, that's NOT a large database. I've restored a 200+ GB database (yes, that's GIGABYTE).Next, how did you do the restore? Can you post your script?It looks like you may have used WITH NORECOVERY which will leave the database in LOADING state awaiting other backup files.WITH NORECOVERY is used when you have to also restore […]
2004-03-30
I used this UDF alot to return only the date part. I got from some site. It is also possible to get the time part mathematically. I just forget the URL though!CREATE FUNCTION fn_Date ( @ADate datetime ) RETURNS datetime AS BEGIN declare @DateVal datetime set @DateVal = CAST(FLOOR(CAST(@ADate AS float)) AS datetime) return @DateVal END
2004-03-29
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers