Just thought I run this past you guys...

On the subject of generating two years of test data... there's no need for RBAR. The following will run in about 3...

Rob Fisk (3/13/2009)

---

OK, so your total cost is 6-8 times faster than mine.

Tally table example would be great. PM me since we have already crowded this topic somewhat.

Thought I'd...

Goldie Graber (3/13/2009)

---

I have received a requirement to write a trigger that accepts a string and then performs the following actions.

1.Remove Script tags and contents

2.Replace all HTML tags with spaces.

3.Replace...

It simply means that you have data...

Such slowness is normally caused by a mistake somewhere in the query... formulas around columns in the WHERE clause will prevent good use of indexes... misunderstanding of the data may...

Bob Hovious (3/14/2009)

---

Test question?

I've been taking buisness requirements for years,...

Just do 3 simple bulk inserts. It's also one of the fastest ways to...

Florian Reischl (3/14/2009)

---

Hi

I'm using sql_variant alike Jeff stated for logging. I've got a usp_Log like this:

CREATE PROCEDURE dbo.usp_Log

@msg VARCHAR(4000),

@p1 SQL_VARIANT = NULL,

...

Heh... Sergiy... I've learned...

foxjazz (3/13/2009)

---

Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how you...

Steve Jones - Editor (3/13/2009)

---

So I got a question in email (it's not just posters, I get them regularly). I have a sig I paste in that replies and says...

Absolutely not...

Steve Jones - Editor (3/13/2009)

---

I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I...

Yeah... I'm still curious, too. Someone posted a suggestion to use Java on this and, as I asked in a previous post on this thread, I'd really like to...

There are many solutions on this thread, so we're not sure which solution you're talking about.

While I "have you on the phone", can you tell me what the business requirements...