You're looking in Task Manager for the memory usage, yes?

Locked pages aren't part of the process' working set and so aren't visible there.

Use the SQL Server performance monitor counters instead.

The...

doobya (7/19/2010)

---

oh yes, good call - I never noticed they were deprecated, I was always fond of those I don't use component services / mts etc. but if sp_bindsession is...

Sanjay-940444 (7/19/2010)

---

More the query is complex more possible plans are possible and SQL Sever is not going to pick up best one necessarily. Best design is one which is...

Anamika (7/19/2010)

---

I can't understand the logic behind

WHERE 1 =

CASE

...

Puzzling. I can see how you might want to record the date that a...

To be fair, I think Lutz covered it first 🙂

You can use select DATEPART(WEEK,DAY(getdate())) to get the week of the month. GETDATE() can be...

Binding sessions only provides access to an open transaction and to share locks, it won't...

Sanjay-940444 (7/19/2010)

---

I understand that upto a large extent it depends on scenerio on hand but sometimes task is so big and complicated that it becomes difficult to decide which...

ogrishman (7/18/2010)

---

In SQL Server 2005(2008 not tested), you can't create a temp function like #function_name, but you can create a functoin called function_name directly in tempdb. Does the function...

If Jack and Steve don't get on, we'll have to rename the organisation FAIL 😀

All good, Kingston (and Jeff). It was a fairly small refinement to the original excellent answer.

Avoiding the extra REVERSE is neat.

My main reason for posting was to show off...

Educate, help, and learn 🙂

My apologies if my previous post seemed a...

Cool - let us know if anything still puzzles you.

-- Option 1

SELECT *

FROM Tbl1

WHERE 1 =

CASE

...

Sagar Sawant (7/17/2010)

---

Why you are using cursors? it's degrade the performance of sql query and also consuming memory..Use while loop instead of cursor. You can see the dramatic performance... In...