L' Eomot Inversé (7/27/2012)

---

GSquared (7/27/2012)

---

Brandie Tarvin (7/27/2012)

---

Back to the semi-technical discussion...

If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

I'm not speaking in the...

Brandie Tarvin (7/27/2012)

---

Back to the semi-technical discussion...

If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

I'm not speaking in the context of the splitter...

PaulB-TheOneAndOnly (7/27/2012)

---

GSquared (7/26/2012)

---

PaulB-TheOneAndOnly (7/26/2012)

---

Lucky9 (7/26/2012)

---

I have to redesign the database based on the new business requirements

Could someone please help me with the steps that needs to be followed

when redesigning...

The sudden cut-off at 7 characters will be something specific to the use of memory addressing, most likely. Nothing you can do about that in the code.

CELKO (7/26/2012)

---

>> I have to create an update and insert trigger for a table based on the value of a column on the same table I.e. I have to add...

The usual way I do things like that is grab the queries out of Profiler (or out of a server-side trace, either one), and have devs find those queries in...

Unless it's always 4 values (or some other static number), you probably need to use a string-parsing function. There are several out there that you can use. Look...

Are any of the queries on it dynamic? Either full-on dynamic SQL, or Linq or anything like that?

The trigger is probably failing because of the NULL bit already mentioned, but I want to suggest that you move the code out of a trigger and into a stored...

Computed column won't work for a value that's based on GetDate(). Value of the column would change every...

PaulB-TheOneAndOnly (7/26/2012)

---

Either...

If you want to update the first column so that it's the last 3 characters of the second column, it would look like this:

Update dbo.MyTable

set Col1 = right(Col2, 3);

Is that...

Is it something where you could use full-text indexing? Like looking in a string made up of separate words, as opposed to a solid string.

FTI will work on, "Today,...

It makes sense in the same way a reserve tank made sense on old VWs. Sure, you could consolidate it all into one fuel tank and get the same...

Back up the registry and edit away. In a test environment. That's all I can suggest.

I usually just stick with using instance names in the standard format. ...