Actually, I found a solution. Sort of.

The queries touch 4 tables. 1 has 2 indexes (1 clustered, 1 non), and the other 3 only had clustered indexes on the PK....

If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

1) What does sp_kleenex do and when would you...

He was applying for the Ninja Dev job. I take it he passed? @=)

Gabe T. (4/13/2012)

---

4) With recruiters, be patient with them, and understand their standpoint. Typically they can hardly spell SSIS, let alone tell you what the difference between a foreach container...

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...

Kausar Mehmood (4/16/2012)

---

What i have concluded right now after some R&D is that Partition table can solve the issue. It will not only ease Manageability issue but also improve performance....

If I were looking for...

praspras42 (4/13/2012)

---

I just want to know that can i write a procedure with the help of which i can take the backup of all databases and can restore all the...

Kausar Mehmood (4/13/2012)

---

I know that this depends on DB Design. We are already in development phase and I know we can use UNION statements for combining results from different queries,...

Thank you. I knew I was overlooking something.

You don't need Full Text Indexing necessarily to do a search. If your indexes and statistics are good enough, then you can search billions of records without a problem.

The problem...

opc.three (4/12/2012)

---

tt-615680 (4/12/2012)

---

Brandie Tarvin (4/12/2012)

---

Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

Remember, least permissions needed to do the job (figuratively and literally) should...

That's because they're using the same schedule (you can have jobs use an existing schedule, or each job have their own brand new schedule). Delete the schedule from job 3...

You misunderstand what he said. If you want to put the code in a web page and post the URL of the...

Um, that's what I've been telling you. If you want to data mine, you need data (not information). There's a difference.

can...