July 3, 2008 at 10:52 am
Okay, thanks. Unfortunately (?) we are looking at consolidating some of our servers, and will be using named instances where a separation is required.
😎
July 3, 2008 at 11:03 am
GSquared / Lynn, thanks for your insights.
So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and implications of table variables vs temporary tables (in this case).
July 3, 2008 at 11:09 am
Simon Facer (7/3/2008)
GSquared / Lynn, thanks for your insights.So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and implications of table variables vs temporary tables (in this case).
Absolutely. All "best practices" are that way.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 3, 2008 at 12:03 pm
GSquared (7/3/2008)
Simon Facer (7/3/2008)
GSquared / Lynn, thanks for your insights.So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and implications of table variables vs temporary tables (in this case).
Absolutely. All "best practices" are that way.
Which is why they are called "best practices", they aren't always appropriate in certain circumstances. Look at them, apply those that make sense, discard those that don't work for your situation.
😎
June 16, 2010 at 11:17 pm
how much is a good amount of virtual memory to keep in an intance ?
June 17, 2010 at 2:15 am
It all depends on how big is your application and how much load is expected on SQL Server
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply