Viewing 15 posts - 46,141 through 46,155 (of 49,571 total)
Have you tried using the KILL command from query analyser?
June 23, 2008 at 6:40 am
There's nothing useful in there. Look through your older logs, see if there's any entry related to msdb that doesn't simply say 'bypassing recovery because msdb is marked suspect'
June 23, 2008 at 6:11 am
mathewspsimon (6/23/2008)
considering all other thing are common for both cases,which do you think will be faster.
How long is a piece of string?
That's not a question that can be decisivly answered...
June 23, 2008 at 4:56 am
Import into a staging table, do your clean up, move data to a proper table.
June 22, 2008 at 11:55 pm
You'll have to test each way and see what's better. Without a lot more info, there's no way to say which will be faster in your case.
There is a massive...
June 22, 2008 at 11:53 pm
coatta (6/22/2008)
So, is there a way on a production server to capture things like the deadlock graph without the Profiler running?
Sure. Switch traceflag 1222 on and all deadlock graphs (in...
June 22, 2008 at 11:43 pm
onlo (6/22/2008)
I am doing some bench mark on SQL Server, I would like to ask you 2 questions :
(1)I want to erase all the cache content (cold buffer cache)...
June 22, 2008 at 11:42 pm
Why do you need the proc turned into a view?
June 22, 2008 at 12:29 pm
Bilal (6/22/2008)
I expect about 1000 rows to return , and their is one type of index defined which is traffic1each table have millions of records
any thing else ?
Yup....
June 22, 2008 at 12:26 pm
What's the table's schema? What indexes are defined on it? How many rows are in the table? How many rows do you expect your query to return?
Do you absolutely need...
June 22, 2008 at 5:37 am
jvamvas (6/20/2008)
Also consider 1)changing recovery model2)use TABLOCK
What????
Do the two queries in question need to be SELECT *?
Have you checked the execution plans of the select queries to ensure that...
June 21, 2008 at 10:27 am
Depends on the data, depends on the table structure, depends on the query.
It's not a question that can be answered in isolation.
June 21, 2008 at 9:59 am
mithun gite (6/20/2008)
June 21, 2008 at 9:49 am
GSquared (6/20/2008)
Truth be told, I'm going by something I read a while back, and haven't tested it myself....So ... give me a few minutes here. 🙂
Are you maybe thinking about...
June 20, 2008 at 12:49 pm
Line 117 points at this update:
update #programs
set programid = programid
from #tmpProgMapping
where LOWER(TaskPrefix) = LOWER(Prefix)
It's probably supposed to be this
update #programs
set #programs.programid = #tmpProgMapping.programid
from #tmpProgMapping
where LOWER(#programs.TaskPrefix) = LOWER(#tmpProgMapping.Prefix)
Oh, as...
June 20, 2008 at 12:44 pm
Viewing 15 posts - 46,141 through 46,155 (of 49,571 total)