If...

Alan Spillert (7/18/2013)

---

I've got 6 large SAS disks in three RAID-1 sets, and have divided the data load, I think, between them. My goal is to optimize performance by...

Is it because you don't know how to do it without a loop?

Have you tried to use a scalpel? 🙂

It depends.

If you have a query which reads 1 record from that table each time you run it, but it runs 35K per minute, then it's beter to create an...

brendan woulfe (7/8/2013)

---

Touching on what I wrote above...another problem I have with the recruiting companies is when they call you for a job they are placing, they'll ask the rate...

MAX

GROUP BY

Read this http://msdn.microsoft.com/en-us/library/ms191472(v=sql.105).aspx

Statistics cannot be perfect, doesn't matter if you update it with fullscan or sample 1%. It should be better with more sample data, but it's not guaranteed. There are a...

Denise McMillan (6/10/2013)

---

The results I'm trying to get are:

proc_id dtime proc_num result

70360 ...

ChrisM@Work (6/7/2013)

---

Something like this can help, and it's easy to check;

UPDATE D SET

Track_ID = P.Track_ID,

Territory_ID = P.Territory_ID,

Major = P.Major

FROM Staging.Track_Play D

INNER JOIN Staging.Track_Mapping P

ON P.ISRC = D.ISRC_Code

AND P.Event_Date...

GilaMonster (6/7/2013)

---

Why not? What's the problem...

How existence of different files in a folder can impact...

I'm using this one. Note that size is in MB.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET LOCK_TIMEOUT 10000

DECLARE @PageSize int

SET @PageSize = 8

SELECT

tbl.object_id,

CASE WHEN SUBSTRING(OBJECT_NAME(tbl.object_id),1,1) =...

vs.satheesh (6/7/2013)

---

My question is

I am give select * means its retrieving with in two seconds.But I am specify column...