free_mascot (4/4/2014)

---

It is not advisable to put anything like user proc on master; instead you can create new database and store stored procedures. Also it is not a good idea...

Lowell (3/13/2014)

---

Basically its a find and replace operation... you can select definition from sys.sql_modules to get the CREATE PROC statements but you need to change it to alter and add...

Thank you very much

what your trying to...

Thanks for your reply...

clayman (6/28/2012)

---

SqlSpider... (6/28/2012)

---

Hi All,

I am doing login downgrade in My Server...

this is my Script It is Throwing Error. Please Let me know if you have any...

Gianluca Sartori (4/4/2012)

---

I would avoid this approach for many reasons.

If you're looking for a results caching solution, take a look at SafePeak.

My suggestion is to speed up the query with...

Gianluca Sartori (4/4/2012)

---

John Mitchell-245523 (4/4/2012)

---

600,000 rows in a report? I feel sorry for the person on whose desk that lands! I think some better options include optimising the...

Gianluca Sartori (4/4/2012)

---

You could use BCP with xp_cmdshell for instance, but, let me ask you WHY you want to cache results like that.

Do you need a result cache to query...

Thanks for your valuable reply... Really it is useful....

GilaMonster (4/2/2012)

---

First step. Take out the join hints and table hints. The chance that you know better than the optimiser is slim.

If you can't post the code, then I can...

Steve Jones - SSC Editor (2/23/2012)

---

You haven't explained what you are doing well enough for us to determine if there is another way to code this.

You'd need to provide more...

Instead of using this code, is there any other way round....

Please....

Will these indexed views improves the Performance..?

Now i am Doing the Same, Mean while I posted it.....