Viewing 15 posts - 40,981 through 40,995 (of 49,571 total)
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect that people know...
February 19, 2009 at 5:58 am
madhu.arda (2/19/2009)
1.I have to go database Mydb and execute drop statistics _WA_Sys_stdAQSKey_78415083 right?
Yup, for each of the statistics listed in the errors
2.how do we know these statistics are...
February 19, 2009 at 5:57 am
How many rows does the delete affect?
Why that choice of clustered index? It doesn't look like a very optimal one (wide, not unique, not ever-increasing).
February 19, 2009 at 5:54 am
elay (2/19/2009)
WE are to perform DBCC CHECKDB today. Hopefully it will work out.
CheckDB's not going to fix anything. It's a diagnostic that will show what's wrong.
February 19, 2009 at 5:53 am
kuldip.bhatt (2/19/2009)
is there any way that i can not insert entry in the log files?
No. Changes are always logged and there's no way to stop logging. Logs are used to...
February 19, 2009 at 5:52 am
How many rows does that update? The exec plan (which is an estimated plan) says 1.
What's the clustered index on?
February 19, 2009 at 1:54 am
v-makath (2/10/2009)
My requirement is "Make the stored procedure to run daily without using any JOBs.
Why the restriction against using jobs?
February 19, 2009 at 1:52 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic660010-146-1.aspx
February 19, 2009 at 1:47 am
2009-02-10 22:16:05.31 spid53 Warning: A column nullability inconsistency was detected in the metadata of index "_WA_Sys_stdAQSKey_78415083" (index_id = 3) on object ID 2017546371 in database...
February 19, 2009 at 1:46 am
It looks like there's some corruption. Please run the following and post all of the results
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Also, read through this - http://www.sqlservercentral.com/articles/65804/
You...
February 19, 2009 at 1:39 am
n.pratheep (2/18/2009)
Please tell me how to find when the database opened and solution to make it again standby mode.
Restore the latest full, with NORECOVERY or STANDBY option, and then restore...
February 19, 2009 at 1:37 am
More interview fun.
http://www.sqlservercentral.com/Forums/Topic659105-360-1.aspx
February 19, 2009 at 1:36 am
February 19, 2009 at 1:35 am
No entries in the event log.
Did you look in the windows event log or the SQL error log? There should be at least one entry in the log for the...
February 19, 2009 at 1:28 am
The delete shouldn't escalate to a table lock with 5 of 10 rows unless it's a very small table or there are no appropriate indexes.
Can you post delete statement, table...
February 19, 2009 at 1:27 am
Viewing 15 posts - 40,981 through 40,995 (of 49,571 total)