Re: SQLAgent Memory Usage on SQL 2005
21/10/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
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 |
|
|
|
|
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 |
|