NOLOCK hints are to do non-serialized reads (dirty reads) on data. It ignores all internal locking mechanisms of SQL Server and grabs the data it wants on each table...

Wildcat, it's SQL Server:

However, without having tracing...

GilaMonster (11/9/2010)

---

In case anyone (living under a rock maybe) missed the announcement:

Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1) : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9

Got a blog post with a couple...

My personal favorite is from Sanchin, though I still feel he gave the OP too much.

You really wanna know?

I thought you would rather...

LOL

I was getting brainlocked on trying to get away with some MAXRECURSION 0 method and then had a job I've been working on (at work! ...

SSSolice (11/9/2010)

---

@OnBreak : represents a clock scan time of when a break began.

@OffBreak : represents a clock scan time of when a break ended.

@DaysHoursWorked : represents total hours worked...

For the curious, question is from here:

http://www.scribd.com/doc/40561966/sql-Test.

Blocked by websense, I'm assuming it's a historical question/quiz.

How to find it?

http://www.google.com/#sclient=psy&hl=en&q=sql+%22top+2+salaries+for+each+employee%22&aq=f&aqi=&aql=&oq=&gs_rfai=&pbx=1&fp=eeb05746d54f919c

So, the answer they really want is:

Blah bla bla, blah blah. ...

Since you're willing to learn, let...

And back on topic for the thread:

http://www.sqlservercentral.com/Forums/Topic1018016-338-1.aspx

*wallbanger*

I'll be "blah blah"ing over in the corner now.

Hm, have you any experience then in looking at execution plans?

Okay, Career...

Sachin.Nandanwar (11/9/2010)

---

Now that's better.

Below is your query.

select * from

(

select *,row_number()over(partition by employeeid order by salary desc)rid from salary

)T where...

To drag the Canadian Geese back to a different formation for a moment, my websense and whatever is used in the Contribution Center doesn't play nice at work. At...

These two items...

rko.37gags (11/9/2010)

---

Question: Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the...