Viewing 15 posts - 46 through 60 (of 411 total)
Excellent Article. Thank you for providing it. I will be passing this off to some of my friends soon.
March 16, 2010 at 11:13 am
A very interesting and thought provoking article. Thank you!
On actually making your application more resistant to locking, the careful use of the "with (nolock)" query hint can improve performance...
March 10, 2010 at 12:02 pm
Fantastic article, thank you.
Related to your very first example, one should always think about scaling when writing code. Sometimes, especially when making prototypes, the deliberate plan is...
February 10, 2010 at 10:21 am
pete callaghan (2/2/2010)
February 2, 2010 at 6:01 pm
Pei Zhu-415513 (2/2/2010)
February 2, 2010 at 5:56 pm
m.ciesiensky (1/6/2010)
when attempting to run sp_msforeachtable in each of the variations below, I get these errors. I have tried running from both the master and CBL databases, with all...
January 12, 2010 at 7:14 am
Paul White (12/30/2009)]One scenario where this might be useful is if the read-only database is a target of log shipping.
That makes a lot of sense. Thank you.
December 30, 2009 at 10:55 am
A well written and good article that presents an interesting approach. I am curious, why would you want to do this instead of (temporarily) taking the database off of...
December 29, 2009 at 10:47 am
Jeff Moden (12/23/2009)
December 24, 2009 at 10:15 am
Jack Corbett (12/11/2009)
December 18, 2009 at 5:15 pm
Kurt W. Zimmerman (12/8/2009)
I had a stored procedure that performed "global search" that queried 3 tables which were rather large in size. I had gone ahead and tuned each...
December 8, 2009 at 12:47 pm
Grant Fritchey (12/4/2009)
December 4, 2009 at 11:43 am
This does seem to be a tough crowd in the thread today.
I think it was a well done article, and I agree with the basic outline. Thank you for...
December 4, 2009 at 11:38 am
atkinsd (11/30/2009)
One interesting point that you may or may not...
November 30, 2009 at 11:13 pm
einman33 (11/20/2009)
There extended so there married to languages that may not want to continue along into future releases.
Some extended procedures are documented and those are very likely to remain supported...
November 24, 2009 at 9:51 am
Viewing 15 posts - 46 through 60 (of 411 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy