ramjohn8 (12/7/2011)

---

Yeah right now I'm trying to learn as much on the subject. The DBA at my company is willing to let me in on some stuff but right...

matt.newman (12/7/2011)

---

How are you looking to "utilize" memory?

Are you wanting...

From 40 hours course to top 1-5% of the field took me 10 - 25K hours.

Best source is to read books, read questions here and try to answer in your...

This is for dependency tracking.

I wouldn't waste any time on this. No impact at all.

halifaxdal (12/7/2011)

---

Please don't be tough to Ninja, maybe it was a tough...

;

WITH CTE (PetID, PetName, DType, DDate, RN)

AS

(

SELECT PetID

, PetName

, DType

, DDate

, ROW_NUMBER() OVER (PARTITION BY PetID, DType ORDER BY DDATE) AS RN

FROM @Pet p1

INNER JOIN @PetDetail p2 ON p1.PetID=p2.PetDetailID

)

--SELECT...

1 little thing. When you want to pivot data (multiple rows into a single one), you need to do something like this =>

SELECT PetID

, PetName

, Date1 = MAX(CASE WHEN...

In that case...

Change single quotes (') to double quotes (")

Try changing ' to ".

SELECT DATALENGTH(BigAssColumn) AS BytesUsed FROM dbo.PoorTable

Of course, this will scan the whole table. So however many GBs you have in there it'll be read from disk (assuming not already...

Pitfalls of Nolock (readuncommitted).

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Looks correct (assuming SSRS).

What's the issue?

How can you do that when you're the boss???

Dev (12/7/2011)

---

@All: I will consider it a wise decision to quit the thread because I don't want to displease anybody here. But I am quitting with a fact...