IanSinclair (3/5/2014)

---

And if the Maximum Insert Commit Size in the OLEDB destination is already set to a reasonable value you.....

This option might not work - so plitting a source stream...

Hey Dwain,

Excellent usage explanation article, thanks for that.

The issue with table parameters is the big reason you'd want to use one, cross database or cross server data table pollination, fails....

Included columns are stored alongside the clustered index key lookup information at the leaf level, thus widening the storage for that index. It's a powerful tool, but easy to...

DaveDB (2/24/2014)

---

Thanks for your response. I agree with you that transparency is paramount, but I want to make sure that I do not sound too limited. I never try to...

Never personally used it. Haven't even booted up the interface. Never had to.

One of my vendors who runs our SoR seems to use it pretty heavily. Haven't...

Sounds like a data, network, or request timeout.

What you see is what's called 'firehosing'. Basically the system starts returning data even though it's not finished getting all of it...

ghitpro (2/21/2014)

---

Team,

I would like to include few columns (varchar and int data types) from same table in below query without adding in group clause, i do not want these column...

Please link the site to the competition so we can see all the rules at once instead of you feeding...

ericjorg (2/20/2014)

---

Thanks Evil Kraig! There are actually business reasons for the T-SQL requirement that I can't discuss on this forum. Your solution works for this specific requirement, but...

Just to clarify...

You're updating 500 gigs of data and wondering why you have growth of 400 gigs, or did I misunderstand that part?

In SSIS, on your destination, what's your commit...

SELECT CONVERT( INT, LEFT( column, CHARINDEX( column, '\') - 1))?

What chapter in which textbook are you guys working on? That'll help us know what they're trying to get you...

This may sound silly but when you login to the target server with the login you're logged into your local as, and look at the database, you can see tables/procs/etc,...

You need to adjust your wildcard usage.

1/2 is handled via the %mydata and mydata%. You can't use an anchor character but that will function. For #3, you need...

To confirm, you're sa/dbo on production with your NT login?

Go to security in the linked server. What is the default setting for a login not defined? Is it...

Really it depends on how fine you want your error controls, and if you're doing bulk or singleton inserts.

If your inserts come down one at a time, that's fine. ...