Viewing 15 posts - 38,881 through 38,895 (of 49,571 total)
Steve Jones - Editor (5/27/2009)
If you (ya'll) want to write a book together or separately, Tony Davis of Simple-Talk is always looking for some to use in promotions.
I'd love...
May 27, 2009 at 9:59 am
Aaack!
Truncating the log breaks the log chain. If that is run, no log backups may be made afterwards and hence no point in time restores are possible until a full...
May 27, 2009 at 9:58 am
Max (5/27/2009)
3. Gail, I think RECOMPILE was available in 2005 and it would have been possible in 2k to use:CREATE PROC dbo.sp_TestProc @intPara1WITH RECOMPILE
AS...
Yes it was and yes...
May 27, 2009 at 9:14 am
Roy Ernest (5/27/2009)
Gail, that was what my teacher used to do. Are you sure you have never been to India and taughtDB2??
Never been to India, never even used DB2.
May 27, 2009 at 8:54 am
David Burrows (5/27/2009)
Lynn Pettis (5/27/2009)
Here is another OMG moment.OK, hang on, I'll get my Ouija board and crystal ball :w00t:
I have a tarot deck if you think that it will...
May 27, 2009 at 8:46 am
Roy Ernest (5/27/2009)
May 27, 2009 at 8:43 am
It might help, depends how the optimiser chooses to do the joins. Test some of your queries both ways and see.
May 27, 2009 at 8:26 am
Lynn Pettis (5/27/2009)
May 27, 2009 at 8:07 am
Grant Fritchey (5/27/2009)
May 27, 2009 at 7:55 am
There's a book that Grant Fritchey wrote, not sure if it's still available electronically. Also you could take a look at my blog.
http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/
May 27, 2009 at 7:52 am
NOLOCK/READ UNCOMMITTED only apply to selects. All data modifications will ignore that hint, they have to lock exclusive.
May 27, 2009 at 7:46 am
Grant Fritchey (5/27/2009)
May 27, 2009 at 7:39 am
narendra.pola (5/27/2009)
What are the ways that can be done to improve
Generally, change the queries to remove unnecessary operations and to allow them to use indexes effectivly and then tune...
May 27, 2009 at 7:31 am
GDI Lord (5/27/2009)
Me
The benefits that I my boss can see with tbl_Users1 would be the schlep of looking up addresses would be avoided.
However, I think that alternate/"out of town"...
May 27, 2009 at 6:38 am
Florian Reischl (5/27/2009)
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...Notice, more than 800 points.
Lots and lots of questions.
May 27, 2009 at 3:33 am
Viewing 15 posts - 38,881 through 38,895 (of 49,571 total)