Sorry, I had one of my typical moments when typing that up.

I meant query performance statistics

Nice info Craig 🙂

Instead of testing and exiting, is there a way to use a cursor to spin and "sleep" whiling waiting for the lock to release?

btw, I've done...

Actually, I should find out if I can do it the "correct' way first.

Is there a way of do this kind of aggregate using expressions and groupings in SSRS 2005:

count(distinct...

Like GilaMonster said, there is nothing inherently wrong with correlated queries other than they're often incorrectly used.

I find they work extremely well to check for existence of relations on tables...

We're importing data for a customer into our database and the customer's data is being provided by a 3rd party who houses their data and neither the customer nor the...

Intel's new i7 Xeons support Hyperthreading and it actually works this time

goodwill_guy (10/30/2009)

---

I have a table called "CompanyHistory"

I have 2 jobs

1. populatehistory - Writing the history of the company into one table

2. calculatehistory - Another job...

NUMA:

The OS defaults to allocating memory from the current NUMA node that the thread is executing. If the thread changes nodes or runs out of available memory on the current...

I *think* it's called for each row

on convert(int,nvarfield) = convert(int,varfield)

one way it could be done

Here's a little theory crafting and would be nice if it wouldn't be too hard to try out

Select fsp.*, fsl.* from Fact_SalesPerformance fsp

inner join Dim_Listing dl on dl.ListingID = fsp.ListingID

inner...

be careful with your "MAX" statement since getting that conversion error means that table is storing dates as STRINGS

you shown this in one of your replies

partnum revisionnum effectivedate

---------- ----------- -------------

1234...

Lowell (7/8/2009)

---

i think your issue is the NOT EXISTS...

whenever you do that, You have to test for nulls, as that will screw up the EXISTS

WHERE NOT EXISTS

(SELECT OldLicenseNumber...

Your problem is with the "not exists", you're using it incorrectly.

EXISTS vs IN

INSERT INTO TestID

(OldLicenseNumber)

SELECT

DISTINCT OldLicenseNumber

FROM TableFrom2002

WHERE NOT...

If you ever have to "store passwords" make sure you salt and hash them.