Peter Tuffin (2/27/2008)

---

Another thing: the Myers-Briggs Type Indicator is based on, and inspired by, the work done on this by Carl Jung. His interest was firstly to try to...

Non-indexed views aren't compiled separately, so...

Lowell - if you're on 2005 - use CLR instead to create the REGEX expressions instead. The XP is nice in 2000, but you can do better in 2005.

Refusing to consider using a temporary table is going to cost you dearly in performance. The one way to do such a thing creates a dataset with very high...

Actually - I've been finding that using ROW_NUMBER() is substantially less effort than than the aggregate function method. Not quite sure why - but it seems to do better.

;with...

Fair enough - but there is one on SQL 2005, and it don't work either.

126 (4)

ISO8601

yyyy-mm-ddThh:mi:ss.mmm (no spaces)

127(6, 7)

ISO8601 with time zone...

I'm assuming that's the database engine, right? That will in fact run.

If on the other hand, you get SSRS (reporting services) installed OR running on home premium -...

David -

Lynn is using what is called a CTE (common table expression). BOL will give you lots of examples of how it can be used. It's pretty nice...

Use the datediff function, and store the difference in a datetime field. Use the convert to show what you want to see

declare @startdate datetime

declare @EndDate datetime

set @StartDate = '2008-02-26...

why shrink the files at all? Leave the log files to be whatever size they need to be between backups. Continuously truncating them (which then forces them to...

It certainly does work. Your security is going to make it a little tricky, in that one reason to maintain it in a SINGLE XML fragment is to leverage...

use an "old-style" pivot command:

select dateadd(day,datediff(day,0,datein),0) Datein,

AdID,

sum(Case when leadstatus=1 then 1 else...

From what I've found - it depends on the version of Vista you're running. If you're not running Vista Business or Vista Ultimate, you don't get full access to...

Also - don't assume that SQL 2005 will use the same indexes as 7.0, nor that the optimizer will at all act the same as 7. It looks to...

Look up creating a "scalar function". That's a function returning a single value as opposed to returning an entire table.

create function myfunc(@myparams int, ...)

RETURNS @bob int

as

BEGIN

.....

RETURN

END