Viewing 15 posts - 3,571 through 3,585 (of 5,685 total)
Cat, it's for both, and same purpose. In a RAID 5, for each section of disk (I forget the break out) in say a 4 disk array, 3 have...
March 24, 2011 at 8:56 pm
Polymorphist (3/24/2011)
Most part-time development jobs want open source knowledge such as PHP, MySQL, etc.
Primarily because most clients who use open source are either small, so they don't have...
March 24, 2011 at 7:59 pm
CELKO (3/24/2011)
SELECT A.column_a, A.column_b
FROM TableA AS A
LEFT OUTER JOIN
Flagged_Records AS FR
...
March 24, 2011 at 7:39 pm
Try this:
SELECT
drv.ClientID,
ca.*
FROM
(SELECT DISTINCT ClientID from tIdentity) AS drv
CROSS APPLY
(SELECT TOP 1
i.ClientID,
ds.DocSummaryKey,
-- picked a few random fields here, choose what you want to return...
ds.DocKey,
ds.DateExpiry
FROM
tDocSummary AS ds
JOIN
tIdentity AS...
March 24, 2011 at 7:31 pm
Can you supply the ddl for the tables and a little sample data?
I was in the middle of providing a pretty quick (usually) cross apply solution, and then realized I...
March 24, 2011 at 7:06 pm
Couple of things, and no, you don't want a cursor if I understand you right.
phil.layzell (3/24/2011)
and convert(varchar(10),I1.DateExpiry,120) >= convert(varchar(10),GetDate(),120)
This can't index seek, it's considered non-SARGable, because you've wrapped DateExpiry in...
March 24, 2011 at 5:48 pm
The most important point first:
dji (3/24/2011)
I hope I haven't wasted anyones time with this, all the help is most appreciated.
You haven't Jake. This is an excellent example to learn...
March 24, 2011 at 5:43 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin...
March 24, 2011 at 5:02 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin post the...
March 24, 2011 at 5:01 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin post the next 36...
March 24, 2011 at 5:01 pm
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Almost at 25,000 posts here on The Thread! At today's rate, we'll hit it tonight.Edit: 36 posts to go. (Watch Alvin post the next 36 messages...)
Now,
two
March 24, 2011 at 5:01 pm
WayneS (3/24/2011)
Almost at 25,000 posts here on The Thread! At today's rate, we'll hit it tonight.Edit: 36 posts to go. (Watch Alvin post the next 36 messages...)
Now,
March 24, 2011 at 5:00 pm
A couple of first glance notes with the right query.
First, your SQLPlan, which you have to go to the XML to see this, has this problem:
<StmtSimple StatementCompId="1" StatementEstRows="89912" StatementId="1" StatementOptmLevel="FULL"...
March 24, 2011 at 4:58 pm
Ah hah! I must have missed that when I re-scanned the thread. That makes more sense as to his earlier observations. I do remember thinking to myself...
March 24, 2011 at 4:24 pm
CirquedeSQLeil (3/24/2011)
jcrawf02 (3/24/2011)
GilaMonster (3/24/2011)
Stefan Krzywicki (3/24/2011)
March 24, 2011 at 3:53 pm
Viewing 15 posts - 3,571 through 3,585 (of 5,685 total)