Viewing 15 posts - 40,966 through 40,980 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 1:37 am
More interview fun.
http://www.sqlservercentral.com/Forums/Topic659105-360-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 1:36 am
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 1:27 am
swmsan (2/18/2009)
I do backup restore 10 times a day...still I was not able to answer such questions...
Errr, those are pretty trivial questions. If you don't know the answers, how well...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 1:16 am
With 16 GB, you can probably safely increase the max memories to total 14.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 1:08 am
Steve, one query about Active Threads. Some article discussion threads appear in that and some don't. Is that intentional?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2009 at 3:39 pm
Best thing would be to have each log on a separate physical drive and, if possible each data file on a separate physical drive
RAID or single disks?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2009 at 2:10 pm
Viewing 15 posts - 40,966 through 40,980 (of 49,552 total)