statistics (data)

RE: outer-join request that is not permitted

• by Frank Kalis

• SQLServerCentral.com

• Reply

haha, now I can apply a german idiom. Wer nicht will, der hat schon! Happy googling! Cheers, Frank

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-11

1 reads

RE: NULL values in source table don't add up

• by NPeeters

• SimpleTalk

• Reply

Ryan, In my opinion there is no reason at all to not replace NULLs in your fact table by references to a 'N/A' record. I can see your management's point if you're talking about a table that is used in an OLTP environment, but in an OLAP environment NULL values in the dimension fields just […]

2003-07-08

RE: Export from SQL Server to Oracle

• by fromnaija

• SQLServerCentral

• Reply

Have you tried using the Microsoft OLEDB Provider for Oracle or the Microsoft ODBC Driver for Oracle instead of the Oracle driver?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-07

1 reads

RE: Which is the best way to go?

• by Chris Kempster

• MSSQLTips.com

• Reply

Hi there Yep, the KISS methodology is always the best option. Wrapper in and transaction perhaps just in case there are issues, or goto temp tables first then "cutover", its always better not to refresh and have a full db than a partially refreshed one with missing data. Cheers Ck Chris Kempster www.chriskempster.com Author of […]

2003-06-25

RE: How much do you earn?

• by marcusl

• SQLServerCentral.com

• Reply

a5xo3z1 - Yeah, I wouldn't want to feed my family on what I'm making.... My wife is the breadwinner at this point... as I side note, I don't think I'll be in true database work for very long... I work for a small company and I have a feeling I'm going to end up as […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-25

1 reads

RE: unique values

• by supercharlz

• SQLServerCentral.com

• Reply

quote: Oops, should have added the following: Open Query Analyser. Change database to your database. Copy and paste code from previous post. tnx it helped me a lot. another question. what if i have two tables, table1 & table2. table1 contain columns -- table1id [uniqueID], name [varchar] table2 contain columns -- table1id [uniqueid], number [int]. […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-25

RE: Search String on HomePage

• by Frank Kalis

• SQLServerCentral

• Reply

Hi Steve, quote: keep you on your toes? steroids??? Cheers, Frank

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-23

RE: group by optimize

• by Tab-Alleman

• MSSQLTips.com

• Reply

quote: but as long as new rows are inserted into tShortTerm sequentially by date then you should add an identity column to tShortTerm and use that instead. Good point! unless he also frequently has to query on a date-range, in which case I'd think you would want the clustered index on the date column, but […]

2003-06-20

RE: How much do you earn?

• by Frank Kalis

• MSSQLTips.com

• Reply

Hi Antares, quote: I will say less than $60,000 but am looking to fix that. But for my area I am on the 25% portion of the pay scale. top or bottom percentile? quote: I have seen jobs for as much as $130,000 but most want you to know about 40 languages (programming) and be […]

2003-06-18

RE: SQL and XML format

• by ruangerm

• TechNet Blogs

• Reply

Hi Crispin I used the following: Select client_id, cl_fname, cl_lname FROM clients AS Client for XML AUTO, ELEMENTS This gives me: <Client> <client_id>1</client_id> <cl_fname>koos</cl_fname> <cl_lname>Viljoen</cl_lname> </Client> This is ok, but i am actually looking for: <Client client_id="1"> <cl_fname>koos</cl_fname> <cl_lname>Viljoen</cl_lname> </Client> How would I have to change the query if at all it is possible Cheers […]

2003-06-17