Wednesday, November 21, 2018
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: ace
 About  Contact
Joined: 24 Jun 2004 11:43 AM
Last Login: 02 Mar 2015 01:24 PM
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
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 2,686 total posts (7.45% of total).
Most Recent Posts:
Re: SQLAgent Memory Usage on SQL 2005 10/21/2006 6:16:19 AM   (Total replies: 1)
Hi Pammy, This is definitely "not normal", I think ;oP Certainly I have not seen First thing I would check / ensure is whether you are running Service Pack 1. Otherwise, without more information it's hard to know what's causing the problem. A potential solution is to restart the SQL Agent every so often, which can be easily scripted. You really need to investigate what is causing the problem. I would suspect some job that performs a query directly. You might be better off moving ...

Re: Importing text files 2/16/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 10/21/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][/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 1/12/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 3/14/2007 4:12:55 AM   (Total replies: 1)
Hi, How did you rebuild the indexes? Victor

SQL Server and SAP 9/1/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 11/15/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 10/23/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: Learning Analysis Services 10/27/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: DO I need to have enterprise edition of SQL for Ana. services? 9/28/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

Search for more...