Paul.Blain (2/15/2008)

---

Thank everyone for the replies. I was *hoping* someone would recognise an issue with our SQL Server 2000 - and tell me why these SQL database files were...

I'm being nitpicky about this - but let's avoid using the word PK in this case. Its function as Primary Key has no bearing whatsoever on the page splits....

ALZDBA (2/19/2008)

---

(0 row(s) affected) :laugh:

Is it a public link ? :Whistling:

TheSQLGuru: From what I've been told - didn't have time yet to play

with CLR...

There have been a lot of schools of Agile. David Poole recently wrote a fairly good primer on Agile development from the perspective of a DBA.

The thing is -...

Marios Philippopoulos (2/19/2008)

---

You also may want to consider making your primary key ID column non-clustered and define your clustered index on a more suitable column, eg. a record timestamp.

Queries involving...

Your big problem is that you are using LIKE in such a way that it's not possible to use any kind of indexing. The "Like '%ring%' " (find 'ring'...

Christopher Ford (2/18/2008)

---

For totals that involve groups, I wonder if you can split the work in half.

A multi-thread CLR?

Where the first query get the first half while the second query...

I still have only an incredibly foggy of what you're trying to do, so I have no clue if you're being given good advice or not. For one -...

I don't know how to retrospectively figure it out. That being said - if I...

Your issue is that you're comparing strings to strings and not dates to dates.

in your case '15/04/2099'<='16/01/2008' (because '15'<='16')

What you want to be doing is CAST('15/04/2099' as datetime) which...

Steve's right - unique constraints are implemented through indexes, so they're subject to the "no more than 16 columns, which can't add up to more than 900 characters" limit.

If you're...

Mike C (2/18/2008)

---

BTW, my friend that I blogged about (who's currently interviewing for jobs) was asked this very question a couple of days ago. I can only assume the interviewer...

Jeff Moden (2/18/2008)

---

Heh... do be a bit careful... my questions, although certainly appropriate, are likely to be taken as a high insult. 😉 I know this because new vendors...

Ivanna Noh (2/18/2008)

---

are there other ways of accumulating points as well as answering 'Today's question' correctly?

I'm unsure of exactly how the points thing works, but I'm interested in trying...

Jeff Moden (2/18/2008)

---

Heh... the method certainly is useful for a lot of things that would otherwise require a cursor... and a heck of a lot faster, too!

Matt, that's perfect... the...