Evil Kraig F (10/5/2012)

---

Noone can know...

Hmmm... I made a lame attempt to answer the 8 questions. I then researched the answers online.

You wouldn't have hired me! Lol 😀

Jeff Moden (10/5/2012)

---

I inform each candidate that I'm going to start out with easy questions to break the ice and relaxe a bit. When I asked this guy how...

Thanks Jason.

I'm officially an idiot. The domain account is just fine but I forgot to create the login on each SQL Server I'm connecting to (in the trusted domain).

But I'm...

avdhut.k (10/4/2012)

---

Now,I want Sql source Query to be dynamically change based on the iteration of For Loop

and also Excel File also change accordingly ...

Not the easiest exercise to start your adventure with SSIS but this is possible to do yes.

1) Create a stored procedure which will accept your parameter (let's call it Employee...

hearty (10/3/2012)

---

Hello Everyone, I am newbee to ssis. I was asked to create a SSIS Pacakage which contains parameterised report (say it contains a parameter called persons). I am supposed...

No, no log shipping.

I've done a bit more checks and it appears to be very old data. In fact the entries relate to databases that no longer exist in master.dbo.sysdatabases

I'm...

Zilch!

This issue has now been resolved.

D.Post, Thank you very much for this. Very useful indeed!

I've got my Utilities Server setup with SQL Server 2008 installed on it and I've just setup my DBA Repository database.

Now...

KTG (9/26/2012)

---

Or better yet, is there a query or command I can run to see how much space each object is taking up in the DB? That approach might be...

I've messed around with this for a bit now and it's been a good learning exercise but I'm going to stick with the following (takes 3 seconds to work through...

Your solution works great but unfortunately the rCTE isn't scaling well enough. With 150000 rows it takes 7 seconds to process. With 160000 records it takes 17 seconds. But when...

Luis Cazares (9/25/2012)

---

I know it could be a bad solution, and maybe you had tought about it.

But since the rCTE is not scaling well (and it sure won't) why don't...