jflynn-735049 (1/19/2012)

---

Yes that is what I mean in DB1 it has the proc myProc.

I need the database to used to be either DB2 or DB3 after the data has...

You can put in the disk and go through the steps again and it will identify what is installed and what is not. Just add the things that you...

SQLRNNR (1/19/2012)

---

SQLKnowItAll (1/19/2012)

---

Just to make sure I am reading the path right... I would be training for 70-432 if I have no previous MS certs and am doing the administration...

GilaMonster (1/19/2012)

---

SQLKnowItAll (1/19/2012)

---

So, can I buy these books used or do I have to register that I bought it? Let's say I was a know-it-all and just wanted to...

Just to make sure I am reading the path right... I would be training for 70-432 if I have no previous MS certs and am doing the administration path?

PaulB-TheOneAndOnly (1/19/2012)

---

Microsoft really doesn't care how you acquired your knowledge, you have to prove nothing - register for the test, take it, pass it, be happy forever after... better saying...

The best way to do this is to fully qualify the table when you reference it in the stored proc. So databasename.schema.tablename or databasename..tablename if it is the default...

All good insight. As everything goes... It depends 🙂 Ok, let me get more specific since the Microsoft site is just giving me error pages and "no longer available."...

Ok, I guess I could have figured that out on my own 🙂 What about other recommendations? i.e. Wait for 2012, or just upgrade to it later? e-learning, book, or...

I think its funny that we are arguing using profiler in this case. Sure, if I have no performance problems and run profiler it might not cause any issues....

Going along with the other responses... Partitioning is used to help better manage the administration of SQL Server. A great example of this is something that we do:

We have a...

Jeremy... (1/18/2012)

---

SQLKnowItAll (1/18/2012)

---

Jeremy... (1/18/2012)

---

Is this in the BI studio? I'm not seeing "report" in the...

Jeremy... (1/18/2012)

---

Is this in the BI studio? I'm not seeing "report" in the properties box....

Select "Report" in the properties box, go to InteractiveSize and change Height to 0.

bicky1980 (1/18/2012)

---

SQLKnowItAll (1/17/2012)

---

I think that we can all agree that this was not a mathematical issue but a logic issue. The two not being mutually exclusive, but being related. ...