I think there should be a "not" in there. Right?

Good idea Phil.

Most companies need to actually set up a parallel system, with dummy data, and "tiger team" it, by deliberately hacking the fake site. Any dummy data they...

18 Gig with 2% growth per day will pass the 24 Gig mark in just about 2 weeks. It'll be over 600 Gig in 6 months. Assuming compound...

Well, the thing you most hope to avoid is the one that's most likely to bite you in the ...

🙂

Mike McQueen (6/1/2009)

---

No love for the ISNULL it seems- can you guys explain the negatives of doing it that way? Thanks 😀

I know there is the small performance hit, is...

The trigger will fire once. It's absolutely critical that triggers be built so they can efficiently handle multiple rows.

I suggested load-testing three scenarios. Really, that's how you'll get the best solution for...

I suspect that you're best action would be to keep the tables partioned the same way, so as to avoid extra overhead in querying even more partitions.

What you might do...

I can't fully judge it based just on your description, but I'm going to say that's not normalization, that's something else. It's based on a relatively common misconception of...

Grats and well done!

And, of course, thanks for the information. Very good write-up, without being any sort of brain dump or anything. That's good.

That almost certainly means there are no exact matches for that Where...

Jack Corbett (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post. ...

I've used calculated columns for that kind of thing a few times, but I've generally found the best is a history table. Set up the indexes on them correctly,...

I just tested this:

set nocount on;

if object_id(N'tempdb..#testcases') is not null

drop table #testcases;

CREATE TABLE #testcases(

[testcase_id] [int] IDENTITY(1,1) NOT NULL,

[ScenarioName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[scenario_category] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[expected_bundles] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS...

There are ways to get Windows apps/services to run on Linux, but you're almost certainly better off using one of the RDBMSs that's designed for Linux/Unix. Like MySQL or...