As this is an assignment, I'd like to suggest that you show us what you have done so far to try and solve your problem. From there we can...

At this point I am going to chime in and suggest that you read the first article I reference below in my signature block and the following blog, The Flip...

Unless you are experiencing disk space issues on the disk where tempdb resides, I'd leave it alone. It grew to whatever size it is for a reason. If...

I have to agree, the wording of the question is questionable.

Directly from the source sighted in the answer to the question:

50 instances on a stand-alone server for all SQL Server...

smknox (5/17/2009)

---

It seems like my simplest option might be to pull lots of records over the network (one sp without a where clause) and then filter out what I want...

rodney.williams (5/17/2009)

---

Thanks, Lynn. This is such a textbook business problem and i'm really only asking for best way to approach something, those things mentioned in your first link to...

vickymae222 (5/17/2009)

---

Thank you for your quick response! What is the My table you are referring to? After I do this expression, then I need to...

You could use a master stored procedure that executes the proper child stored procedure based on the parapmeters passed to the master stored procedure.

Jan Van der Eecken (5/17/2009)

---

Since Lynn calls this place the Water Cooler, I thought I'd give it a bash and ask you guys who are in the US a totally...

O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?

raj_143bhoomika (5/16/2009)

---

hi , i just need what may be the reasons . If we might across a condition

When creating a non clustered index on a column...

You don't need a cursor, but what we ned is the DDL for the tables, sample data (in a readily comsumable format), the expected results based on the sample data,...

Perhaps if you provided the complete error message you are receiving we could help you figure out what is wrong.

We are not going to agree. The "discrimination" starts in education system, and is perpetuated from there. We as professionals and parents need to make the changes happen...

Gift Peddie (5/16/2009)

---

Immaterial. I have worked in both large and small organizations and the general make-up of the organizations have been largely equal. As I said, I haven't seen the...