Viewing 15 posts - 7,726 through 7,740 (of 9,715 total)
vamshikrishnaeee (8/6/2010)
We have1.Read committed isolation level
2.Indexes are placed on all required columns
3.Index Rebuilds are running as maintenance tasks.
You're not running the rebuilds during the day or while other tasks...
August 6, 2010 at 6:46 am
The first thing I notice is that your SELECT statement and your error message don't use the same temp table name. Is this how it is in your code? Or...
August 6, 2010 at 6:43 am
In a total change of topic.
Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?
August 6, 2010 at 6:36 am
Really? How odd. I wonder if the forum is blocked from your internet connection.
The actual link is here http://forums.asp.net/t/951690.aspx.
If you still can't see it, the advice is:
Login into SQL Server...
August 6, 2010 at 5:33 am
I'm curious. What recovery mode is your database in? FULL or Bulk-Logged?
If it's in FULL and you have a bunch of Bulk Inserts for your data, that could be the...
August 6, 2010 at 5:29 am
free_mascot (8/4/2010)
I would like to drow your attention that when you restart the server tempdb will shrink and when the space is required it has to expand. Now expanding the...
August 6, 2010 at 5:26 am
Your comments make me wonder who it is that's saying you're too old for this. Are they peers of yours? Are they older? Or are they the "younger men" who...
August 6, 2010 at 5:17 am
If I'm understanding your question correctly, all Service Packs have previous fixes inclusive up to the current version #. So if you've never installed SP1 or SP2, you should be...
August 6, 2010 at 5:11 am
guptaajay1985 (8/6/2010)
Default isolation level is?
Have you tried looking it up in Books Online?
August 6, 2010 at 5:10 am
Here's a link with a similar issue. Does it help?
August 6, 2010 at 5:09 am
One thing I'm suddenly confused about. 1) Why is a performance issue question in the Security forum?
Back to the point, Doesn't the data being in different places, pointers or...
August 6, 2010 at 5:06 am
GilaMonster (8/6/2010)
Brandie Tarvin (8/6/2010)
I have to wonder how many times a single record is split because not all the data will fit on a page.
Not permitted (except row overflow of...
August 6, 2010 at 4:49 am
I get my ideas from words. Words just trigger some sort of bizarre mental process in me that sparks my creative side. Whether I'm having / overhearing a conversation, listening...
August 6, 2010 at 4:46 am
Drain Bramage!
I wonder how many people will recognize where that phrase came from. @=)
August 6, 2010 at 4:31 am
Good luck to Steve on the PASS interview. Jack, I'm sure yours went fine.
And I'm glad my taboo tech discussion helped someone and spawned even further interesting discussions. @=) ...
August 6, 2010 at 4:29 am
Viewing 15 posts - 7,726 through 7,740 (of 9,715 total)