Curiouser and curiouser...

I've had too many of those: I get the darn system to work but have no idea how or what did the trick. So you have the relief...

Hey, Brandie,

Glad you worked this out.

I know one problem I sometimes have with SSIS packages is when I make a change to the code, save, but forget to rebuild...

Stefan Krzywicki (4/11/2011)

---

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

I'm likely using the wrong word. the metrics that are gathered by SQL Server to improve performance on subsequent runnings of a query. I knew...

If it's the row-by-row nature of your current process that's creating the performance issues, then staging tables may help you make the process set-based. It sounds like you have a...

For my current company I "evolved" from the catch-all tech guy (sys admin, .NET, and SQL development/dba) to IT director.

Personally, I enjoy it. I've gotten a lot of satisfaction...

I believe that Microsoft has purchased Dundas Charts and Maps and now supply their own version of the .Net library, so Dundas no longer sells licenses to these modules.

David's points definitely make sense, but as he himself mentioned earlier, there may be instances where NULLs are required to represent <unknown>. If you don't need them, scrubbing them in...

2. I use .net for a front end for sql, so I'm not overly concerned about handling nulls... but if there is a caveat with .net and null, I'd...

I'd say the biggest issue is one of trust. From your manager's perspective, (s)he is in a position of needing to trust your judgement on the technical side of things....

Jack,

If I'm following this correctly, the issue is that you have different constraint relationships among the different supportiing documents: you have an OR group (need Doc A OR Doc B),...

That's a good point, Brandie.

It's not hard for a candidate to spend an hour on Google learning some buzz words so they sound like they know how to manage backups,...

I think Tara is...

Hi, Paul,

I'm not clear on what value you're referring to above, but even using a SQLParameter object (I've...

If you follow Paul's suggestion to do dynamic SQL, you should take care to avoid SQL Injection attacks. If you don't protect against this then a line of code like...

One way to write an Update store procedure that can handle one or all columns in the table is this:

In your stored procedure, declare a parameter for every column in...