Well, I have been enjoying my time off work, but I haven't been doing much soccer officiating so far. Tournament started on Monday and today was the first time...

Lynn Pettis (7/16/2009)

---

Could be me, but why do I get the feeling that it isn't the transaction log that was growing, but the backup file. Could it be that...

Could be me, but why do I get the feeling that it isn't the transaction log that was growing, but the backup file. Could it be that the daily...

skailey (7/14/2009)

---

While I appreciate the reasoning for why you would like certain questions posted this way, I believe it is overkill for my question. I have 2 tables. ...

While you are figuring out how to post the execution plans, please post the DDL for the table(s) and your code. That will give us something to start with...

I would have to agree with this. It is hard to diagnosis problems without...

It would help if you'd provide the DDL for your table, sample data in a readily consummable format (that can be cut/paste/run in SSMS to load the table created by...

GSquared (7/14/2009)

---

RBarryYoung (7/14/2009)

---

GSquared (7/14/2009)

---

Gaby Abed (7/14/2009)

---

GSquared (7/14/2009)

I must be missing something. You have my screen name on the part that I wrote. Or are you asking if I'm...

I have run into these myself at times. Not really a sqlservercentral.com problem. Other sites may require...

What would help is if you could post the DDL for the tables, some sample data for the tables in a readily consummable format (can be cut/paste/run in SSMS to...

Nope. From the original post:

The other post I referenced reinforces...

JLSSCH (7/14/2009)

---

The STUFF function should only be executed if the 10th character is an 'H'. Therefore, the STUFF function should be used in combination with a SUBSTRING function and...

Fatal Exception Error (7/14/2009)

---

I am modifying some old code and I am running into a strange error when I run the following

select

column1

,column2

,column3

,TollFree# =CASE

WHEN LEFT(a.phone_txt,3) IN ('800','866','877','888') THEN A.phone_txt

WHEN EXISTS...

In an active/active cluster each instance is only active on one node. For instance, you have InstanceA and InstanceB, with InstanceA running on Node1 and InstanceB running on Node2....

Here is some code with the DDL for the table used. I'll let you populate the table with test data, mine has approximately 20,000,000 rows of data. You...