R.P.Rozema (12/20/2011)

---

Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best...

Hmmm.

Visual Studio is developed by Microsoft.

.NET is developed by Microsoft.

SQL Server...

Second this one. If you are well versed in the BI suite, the number of possible positions for you doubles.

Also,...

edit: it's 17 hours of video. At that time, I have read the book twice 🙂

Take a look at CBT Nuggets:

http://www.cbtnuggets.com/it-training-videos/series/msft_70_432

Ah, I forgot:

to do the inserts in the multimillion table, you're probably best off doing partition switching, instead of direct inserts in the table.

http://technet.microsoft.com/en-us/library/ms191160.aspx

(I hope you have Enterprise edition!)

The "right way" in SSIS:

* use fast-load in the destination, but I see you already figured that one out

* do not use the SORT component. 200 million rows and it...

pallavi.unde (12/19/2011)

---

currently i am using MSSQL R2 2008 sp2

I need to know which is powerful database MSSQL or ORACLE.....?

we are using .net technology is oracle compatible with .net???????

i wanted to...

forsqlserver (12/19/2011)

---

During installation I get...

May I know the different use of:

1. Clients tools connectivity.

2. Clients tools Backward Compatibilty

3. Clients toll SDK

4. SQL Clients Connectivity SDK

I only want to install sql...

Nice question and I definately learned something, but quite an awful format 🙂

(I had to copy paste each answer into SSMS so I could read it better)

Jeff Moden (12/19/2011)

---

VIG (12/19/2011)

---

Jeff Moden (12/19/2011)

---

Just thought I'd throw these in... they get rid of the behind-the-scenes operation of parenthetical grouping and remove one extra subtraction (for the month end...

Ahem. You all are older than me.

I'm a child of the...

http://msdn.microsoft.com/en-us/library/ms173763.aspx

For example: read committed - which is the default if I'm not mistaken - prevents dirty reads,...

kramaswamy (12/16/2011)

---

I just don't know how I'd go about doing that. If I encased the DTEXEC command that I'm using in my stored proc to launch the SSIS task with...

kk.86manu (12/19/2011)

---

Hi All,

I used a FTP task to read a text file from a FTP destination and i was able to successfully download a single file to my local path.My...