John Rowan (5/18/2010)

---

So I created a view that joined together all of the lookup tables. The view was used by the analysts and business folks to look at the...

chico_rpereira (5/4/2010)

---

I`m trying to consume a webservice from an oracle procedure using the UTL_http, I build the request print and it`s OK but the request sent in the network is...

Not sure how to do it via SSIS but, if you have access to the Oracle instance...

1- Log on via sqlplus and do... "desc table_owner.your_table_name' OR

2- if logged as owner...

Irfan-358189 (5/16/2010)

---

i am going to start another job/project and in that coming project i heard from my client that they need a guy who is good in queries and reports...

Do you mean... format or content?

For format... search the web -different cultures do it different.

For content... only you know about your credentials including education and working experience.

Try to keep it...

rob 58081 (5/16/2010)

---

I recently perfomed an Index Rebuild using a Maintenance Plan on a large table in my database because it was 91% fragmented. After the Index Rebuild the database...

ASDL (5/16/2010)

---

I don't think there is any set based operation that is required. All I really need to do is:

select * from table_name where col1 = something and col2 =...

Since tempdb gets re-created each time SQL Server is started this shouldn't be a problem.

What's the error you are getting? is it that the failed drive is not...

Let me note that...

This is really basic stuff. Do you have any exposure to maintenance plans?

I do prefer to run my backups using custom scripts but certainly a maintenance plan would be...

Pretty easy to validate... start the job and ask your Oracle DBA to monitor undo tablespace as well as...

I would suggest ROW_NUMBER() OVER() then select RowNumber=1, RowNumber=2, etc.

Check here for details ... http://msdn.microsoft.com/en-us/library/ms186734.aspx

Carl Federl (5/8/2010)

---

Paul Berzukov posted

totally agree with Don Peterson's position on the matter but please note neither original poster nor anybody else in this thread is suggesting the creation...

joemai (5/13/2010)

---

I normally do this:

- Create the exact same table structure with the original one and give it new name

- Copy only data that you need only over to this...

sure, derived tables are a little funny thing - take a look here... http://www.sqlteam.com/article/using-derived-tables-to-calculate-aggregate-values