Stefan Krzywicki (11/3/2011)

---

ricer (11/3/2011)

---

Is the GUID your clustered index key as well?

If so you are probably seeing lots of page splits when you are doing inserts.

Best way of speeding that...

I have not read the white paper yet (I do plan to) and yes, it is probably going to get you some spam so use your spam email account, but...

Stefan Krzywicki (11/3/2011)

---

Anyone know a good source for on-line SSIS help?

I'm having a problem with the speed of my main SSIS load package and would love to find out what...

Brandie Tarvin (11/3/2011)

---

Jack Corbett (9/30/2011)

---

What happens is I will get an error for one row that says "An error has occurred while sending this row to destination data source." ...

I got this one wrong but that's because I considered a Logon trigger part of the DDL trigger family because it was added to SQL Server at the same time...

Also, I've got about 6 weeks left on my current contract, so I'm starting the process again. Not really worried about finding something, but if anyone has any recommendations...

WayneS (11/1/2011)

---

Stefan, Kiera, Chad

Thanks for your replies. The fact that he co-authored a book with Bob Beauchemin does help things a little bit. Still wondering just how much use these...

I'm not sure that you will really gain anything using XML or table-valued parameters. Parsing/shredding XML can be expensive and many SQL Server people don't really understand it and...

Evil Kraig F (10/31/2011)

---

You guys are looking at a race, I'm trying to figure out...

I believe, and I'm not an SSIS expert, that SSIS is doing the compare within SSIS, meaning that .NET comparison rules apply. You need to match case AND trim...

Somebody did one. I can't remember...

Okay, I'm not that smart. I have the answer. Here's the new code:

System.Text.UnicodeEncoding encoding= new System.Text.

byte[] bytes = Row.XMLData.GetBlobData(0, (int)Row.XMLData.Length);

StringReader sr = new StringReader(encoding.GetString(bytes));

System.Xml.Linq.XDocument xDoc= Xdocument.Load(sr);

XNamespace xNs =...

Evil Kraig F (10/27/2011)

---

Needs one additional answer: "It Depends"

Dynamic SQL in the middle of a proc will have little difference to the affect if intelligently parameterized for cache reusage.

Dynamic...

I have an Android phone and I use Google Calendar, especially since it integrates well.

Ninja's_RGR'us (10/26/2011)

---

george sibbald (10/26/2011)

---

no.

if you restore the backup to somewhere with contiguous space, the data file will be contiguous.

So the fragmentation of the file after restore depends on the free...