Viewing 15 posts - 2,236 through 2,250 (of 2,838 total)
PaulB-TheOneAndOnly (12/30/2010)
I'll say that... if you do not have a Test environment and you do not know the Queries and you do want to keep your...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 30, 2010 at 11:47 am
CGSJohnson (12/30/2010)
Run a profiler/trace session against that database...that will give you the queries hitting the database.Hope that this helps...thanks.
Chris
Would if I had access. As it is, I have to wait...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 30, 2010 at 11:46 am
GilaMonster (12/30/2010)
Stefan Krzywicki (12/30/2010)
I'm thinking I can just make one Index with the fields
BusinessDate, CafeNumber, PosNumber, DField
and be done...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 30, 2010 at 11:34 am
PaulB-TheOneAndOnly (12/30/2010)
Stefan Krzywicki (12/30/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 30, 2010 at 11:28 am
Jack has a really good point. You said you're going to have 500 databases, that is a lot of databases to restore/bring back on-line if the server fails. You're going...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 29, 2010 at 12:01 pm
Koen (da-zero) (12/29/2010)
Jack Corbett (12/29/2010)
Hello My New Friend.
Good Day and How are...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 29, 2010 at 11:24 am
As Gail has been saying, you need to test your specific loads and databases to know what the right proportions are. I'd suggest starting with one instance and several "typical"...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 29, 2010 at 11:22 am
GilaMonster (12/29/2010)
Some backup please? I don't know how to say what I've already said 3 times again.http://www.sqlservercentral.com/Forums/Topic1039883-146-1.aspx
I think they may just be looking for confirmation that they're going in the...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 29, 2010 at 11:17 am
WayneS (12/28/2010)
(From a higher level) How to set up...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 29, 2010 at 7:45 am
CirquedeSQLeil (12/23/2010)
Stefan Krzywicki (12/23/2010)
CirquedeSQLeil (12/23/2010)
Anybody else read the article from today?Do you mean the Queries for SSC Community Participation article?
Yes
Yes, I read it. Interesting, but I wonder what the numbers...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 23, 2010 at 10:25 am
CirquedeSQLeil (12/23/2010)
Anybody else read the article from today?
Do you mean the Queries for SSC Community Participation article?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 23, 2010 at 9:30 am
WayneS (12/20/2010)
Ray K (12/20/2010)
Celko warning alert
Yeah, I really liked how the OP pointed out that all Celko's assumptions were wrong. He seems to think...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 20, 2010 at 1:10 pm
This article might also help[/url] you figure out exactly how you want to go about the calculations.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 20, 2010 at 12:30 pm
Craig Farrell (12/16/2010)
Brandie Tarvin (12/16/2010)
Steve Jones - SSC Editor (12/16/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 16, 2010 at 11:21 am
GSquared (12/16/2010)
Brandie Tarvin (12/16/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 16, 2010 at 8:38 am
Viewing 15 posts - 2,236 through 2,250 (of 2,838 total)