sherrerk (3/14/2011)

---

By contract they have been asked to separate two of their clients onto separate hardware leaving me in a bit of a bind. My solution is to create...

In your derived column, try: (DT_STR,5)substring([ColumnName],1,5)

You have to force the data down directly to fit your result.

If they're not escaping characters like this on the load, you have to use something other then a quoted identifier for text entries. ...

I've used bitmasks in a similar method before, but it was to shortcircuit bad full-text indexing in 2k and prior. It's very useful, and allows you a reasonable volume...

Gail as usual did her incredibly thorough job of hitting all the things I noticed, and of course, a few I didn't think of at first. 🙂

One thing she didn't...

Salman Shehbaz-340356 (3/14/2011)

---

Guys

Recently I have come across a deadlock scenario on OLTP box (Sql server 2005) of a client

and found that it's caused by two stored procedures being called...

Um, errr...

There are companies that base their entire living on doing financial calculations in large scale for businesses. For example, take a look at Advent Software.

Forget easily transcribed, these...

A bit ignorant here, what's an MLM?

As soon as you leave the base 256 character set of any language, you'll need nVarchar. You've got the jist of the difference. Under most circumstances most english...

Use the TIME datatype instead of DATETIME for higher resolution on timings. It's accurate to 100 nanoseconds.

Edit: Left the window open in the background too long I see, I've...

bruce.b.allen (3/14/2011)

---

Yes, that is all correct. I want to be able to save the new value to the variable I set in the DTS.Variables("Vname").Value and to have that value...

bruce.b.allen (3/14/2011)

---

Quick question maybe someone can answer.

I currently use a script task to set the value of a variable. The script task works and sets the variable correctly.

However, if...

You should be able to get more information in the SQL Server Logs, under the Management Node. Look at the most recent log file.

jude-32296 (3/14/2011)

---

I have a table that has create statements in a column in my table. What I would like to do is test for a certain value in the...

To add to OPC's recommendations, a mediocre workaround that requires no dynamic SQL or code/logic reusage is to use the OPTIMIZE FOR structure. Be warned, it's fraught with peril,...