Viewing 15 posts - 1,231 through 1,245 (of 2,838 total)
Steve Jones - SSC Editor (12/9/2011)
--------------------------------------
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 9, 2011 at 8:14 am
Grant Fritchey (12/8/2011)
--------------------------------------
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 8, 2011 at 12:45 pm
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
--------------------------------------
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 8, 2011 at 12:09 pm
Brandie Tarvin (12/8/2011)
It's hardly any...
--------------------------------------
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 8, 2011 at 11:59 am
Here are the three plans.
Initial Query is the initial query. It uses views, has an update to change text after the insert and has a TOP (100) PERCENT 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 8, 2011 at 9:54 am
GilaMonster (12/8/2011)
Stefan Krzywicki (12/8/2011)
GilaMonster (12/8/2011)
RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a...
--------------------------------------
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 8, 2011 at 9:44 am
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It is a...
--------------------------------------
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 8, 2011 at 9:44 am
GilaMonster (12/8/2011)
RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog post on...
--------------------------------------
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 8, 2011 at 9:11 am
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It is a production server, best I...
--------------------------------------
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 8, 2011 at 8:47 am
May I ask for some assistance here. I have triple checked to make sure I'm not using any views in a query, yet the Actual Execution Plan keeps including a...
--------------------------------------
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 8, 2011 at 8:32 am
Grant Fritchey (12/7/2011)
--------------------------------------
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 7, 2011 at 1:55 pm
Steve Jones - SSC Editor (12/7/2011)
Jeff Moden (12/7/2011)
Revenant (12/6/2011)
Jeff Moden (12/6/2011)
--------------------------------------
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 7, 2011 at 8:20 am
Evil Kraig F (12/5/2011)
GilaMonster (12/5/2011)
jcrawf02 (12/5/2011)
Did you guys see this? http://arstechnica.com/business/news/2011/12/bill-would-end-overtime-pay-requirement-for-many-more-it-workers.arsOne more reason I'm glad I'm not American...
The difference Gail is if you WERE American (or working here) you'd be...
--------------------------------------
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 5, 2011 at 11:43 am
Ninja's_RGR'us (12/2/2011)
GSquared (12/2/2011)
Ninja's_RGR'us (12/2/2011)
Happy putzy week-end (I hope I got the meaning right!).
Definition 1: unintelligent person: somebody regarded as very unintelligent and unpleasant
But I was just quoting Blazing Saddles because...
--------------------------------------
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 2, 2011 at 12:03 pm
GSquared (12/2/2011)
Ninja's_RGR'us (12/2/2011)
Steve Jones - SSC Editor (12/2/2011)
Ninja's_RGR'us (12/2/2011)
Steve Jones - SSC Editor (12/2/2011)
SQL Server is better than Oracle
Then why is your server hosted on Oracle?? :hehe:
/walks away to...
--------------------------------------
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 2, 2011 at 10:56 am
Viewing 15 posts - 1,231 through 1,245 (of 2,838 total)