Alvin Ramard (11/9/2010)

---

Especially in The Thread.

Speaking Canadianese again Gus?...

It's possible that your VLFs are blocking the shrink. It's possible (I think) that a sector in use near the end of the file will prevent shrinking and you...

Actually a cross apply with Top 2 and Order By Desc will probably perform better than a CTE with a row number in it. Not sure, but it usually...

Like about half the questions/posts on the forums, eh?

I've written mine in Word.

Put the SPs and views in a separate schema and only give permission on that. Or a separate database. Two-part or three-part names in them will work with...

That will depend entirely on how you build your solution.

I'd have to play with that a bit, but it seems to me the place to start would be to log at the publisher and the subscriber, and have the...

Yes, it can. Assuming it has the listed prerequisites for the edition of SQL Server.

You can create a role and grant execute rights to it, then put the domain group into that role. That allows execution of procs.

I like to create a user...

pavan_srirangam (11/8/2010)

---

Do more Maintainance for you database

follow these steps

1) check waittypes --troubleshoot queries or change design ioptions

2) Regular backups based on business

3) Re-build or Re-org Indexes based on level...

bill 36362 (11/8/2010)

---

MS used to actaully throttle the performance of msde. With the release of R2 the db size increased to 10GB. I would think 50 users would...

Search online for "XML path string concatenation". It's a pretty slick trick.

No. There are no missing "go" separators in there.

String concatenation, and adding some hard returns into it, should do that.

But why would you want to do presentation-level tasks like that in the database? Do that kind of...