Sunday, 23 November 2014
       
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: ace
 About  Contact
Joined: 24 Jun 2004 11:43 AM
Last Login: 17 Nov 2014 09:08 PM
Website:
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
Signature:
Email: Unavailable to anonymous users.
MSN IM: Unavailable to anonymous users.
AIM: Unavailable to anonymous users.
Yahoo IM: Unavailable to anonymous users.
ICQ: Unavailable to anonymous users.
 Post Statistics
ace has contributed to 200 out of 1,845 total posts (10.84% of total).
Most Recent Posts:
Re: Importing text files 16/02/2006 5:20:55 PM   (Total replies: 1)
Hi Robyn, I generally never important text files directly into production tables. I generally always recommend to use the following basic methoology when creating a DTS package: 1. Create a staging table using CREATE TABLE 2. Import text file into above table 3. Check / Cleanse / Quality Assure / Massage Data (Whatever needs to be done) 4. Export data from staging table into production table 5. Drop staging table using DROP TABLE So in your case you could also modify the staging ...

Re: SQL Sever Encryption 21/10/2006 3:39:41 PM   (Total replies: 1)
Hi! You have a number of options I suppose. Depends on what you are trying to do. Both encrypt and decrypt or just encrypt, for example. I know of third party products that install DLLs, etc that can be used. An example would be [url]http://www.xpcrypt.com/[/url]. Can't vouch for them. I would be "nervous" about using third party vendors... Alternatively I have see a encrypt and decrypt function implmented as a UDF or SP. I have seen a number of examples over the years, I am sure a ...

Clustering Experts 12/01/2006 6:19:10 PM   (Total replies: 1)
Do we have any clustering experts here. Who would like to provide feedback on some courseware development. Purely voluntary. If so please kontact me via sql[at]informare[dot]com[dot]au Cheers, Victor

Re: Rebuilding Indexes 14/03/2007 4:12:55 AM   (Total replies: 1)
Hi, How did you rebuild the indexes? Victor

SQL Server and SAP 1/09/2006 2:05:20 AM   (Total replies: 1)
Hi all, Does anyone here have any experience with SAP running on SAP. In particular BW 2.0 Regards, Victor

Re: Fillfactor 15/11/2006 8:37:55 PM   (Total replies: 0)
Why do you want to use fillfactor? Not sure I understand you question. Rows that will be filled per page in your case will be variable due to VARCHAR(1000) field. But the basic calculation, leaving aside fillfactor, is 8060/(size of row). In your case the row will be, very roughly, 4 + 4 + 1000 = 1004 bytes. I have, of course assumed that all you rows use the max storage for col3. Also avoided other internal structures such as the Null Blick and Varying Length Block. So then it ...

Re: Learning Analysis Services 27/10/2005 3:47:36 AM   (Total replies: 0)
I'd recommend self-learning to be honest. SQL 2005 courseware is coming out "soon"-ish. SQL 2005 is phenomenally different from SQL 2000. So it's probably not worth your investment to sit on a SQL 2000 ILT course. But the SQL 2005 course will probably not have DW fundamentals. So therefore SQL 2000 OLAP self-learning is the best way to go... Victor

Re: Learning Analysis Services 23/10/2005 12:58:35 PM   (Total replies: 1)
Which version? 2000 or 2005? Are you trying to self-learn or go on a ILT Course? I'd also ask if you've done any reading on DW theory such as Kimball's or Inmon's books and or literature? Victor

Re: DO I need to have enterprise edition of SQL for Ana. services? 28/09/2005 7:59:57 AM   (Total replies: 0)
The price tag is quite significant. You can sort of get around partitioning by using virtual cubes. Otherwise there might be some technical limits on the number of hierarchies, etc that should be documented in Phil's link. Victor

Re: Upgrading SQL Server Express2005 to SQL Server2005 Standard Edition 14/03/2007 4:07:54 AM   (Total replies: 1)
How did you perform the upgrade? Victor

Search for more...