You...

There really is no need for the ISNULL checks here. NULL is not in any of those value either. All the ISNULL check does here is makes it a nonSARGable...

I remember that thread. And I would say that yes it can be done but the end result is a static set of values. I...

Eugene Elutin (7/24/2013)

---

Sean Lange (7/24/2013)

---

I would have to say that is an absolutely horrid interview question. It is not testing your skills with sql server. I have seen the binary...

I would have to say that is an absolutely horrid interview question. It is not testing your skills with sql server. I have seen the binary AND around the forums...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

John Mitchell-245523 (7/24/2013)

---

Those links don't work for me. The code you posted will do the job, but it'll rebuild every index in the database regardless of how fragmented it...

mohan.bndr (7/24/2013)

---

Thanks all you guys for responding,but I believe in the older version of SQL Server (200 and below) can only possible.... am i correct ? and for SQL 2005...

Neither of those are syntactically correct. What I meant is don't use *. You should list the...

Your question is very unclear. It is nearly impossible to figure out what your question is. I don't think you want to use IDENT_CURRENT. If you have two users at...

marlon.seton (7/24/2013)

---

But you did write it. 😉

Sean Pearce (7/24/2013)

---

5) NOLOCK. This hint is very dangerous. Do you understand all the ramifications of this hint? Is duplicate and/or missing information acceptable? Given that some of these queries...

Hugo Kornelis (7/24/2013)

---

Since I was unaware of the effect of ALTER VIEW on an indexed view, I decided to check if it's documented. Turns out it is, in the ALTER...

WOW that proc is a text book case of a number of issues:

1) SQL Injection. Your proc is WIDE OPEN. You build up a string from parameters to the proc...

Koen Verbeeck (7/23/2013)

---

I will save a spot for you. It can't be all that bad, I mean so many of my friends will be there...