Viewing 15 posts - 40,231 through 40,245 (of 49,552 total)
rajganesh.dba (3/21/2009)
Second if the database is in suspect state due to data corruption - then try detach and attach the database
Absolutely not! That is the worst possible advice regarding a...
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
March 21, 2009 at 2:41 am
hugues.gauthier (3/20/2009)
I look at the sysindexes tables and see indexes, but the index id 4 is existing in the table sysindexes
Nope. IndexIDs are only unique per table. There can be...
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
March 20, 2009 at 3:28 pm
If you want to learn CheckDB, the number one resource is, of course, Paul Randal's blog - http://www.sqlskills.com/blogs/paul/
You can also have a look at an article I wrote explaining some...
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
March 20, 2009 at 2:24 pm
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
March 20, 2009 at 1:54 pm
Can you explain in a bit more detail please. Maybe with some sample data and desired results.
Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
March 20, 2009 at 1:53 pm
Jeffery's pretty much got it.
The interval between log backups is the maximum amount of data that you are willing to lose in a disaster. If the allowable data loss for...
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
March 20, 2009 at 1:48 pm
Can you please run the following and post the full output. I prefer not to make recommendations on corruption problems without seeing the full list of problems.
DBCC CHECKDB (< 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
March 20, 2009 at 1:44 pm
In future please start a new thread for a new problem.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/ What you've got there is one of the irreparable errors. CheckDB can't read...
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
March 20, 2009 at 1:40 pm
A procedure is compiled at the point that it is called, providing there is no matching plan in cache. If there is no plan in cache, then the procedure is...
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
March 20, 2009 at 1:35 pm
Drop the SET and do the assignment as part of the select
declare @sequence_number int
select @sequence_number =
case
when workflow_activity_type_identifier = 197 then '1'
else
case when workflow_activity_type_identifier = 203 then '1'
else(select count(*)...
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
March 20, 2009 at 9:33 am
gbrabham (3/20/2009)
I would be interested in some more information. I've worked with Oracle over 14 years... I'm assuming SS is the master replicating down to Oracle.
No. Oracle...
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
March 20, 2009 at 8:47 am
achleshsoni (3/20/2009)
no but this happened suddenly while sql is fully working , it looks bcas of overload of memory ...
High memory usage will not cause a complete cache flush.
Check...
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
March 20, 2009 at 8:34 am
plavec (3/20/2009)
I know that FORCESEEK is available in 2008, but I need it in 2005 😉
Perhaps you could tweak query and indexes so that hints are not necessary. Post query,...
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
March 20, 2009 at 8:22 am
achleshsoni (3/20/2009)
second option see some logs.. since whn problem got started ....
Sorry, I don't understand.
There's nothing interesting in that piece of log, it's a standard set of SQL startup events.
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
March 20, 2009 at 8:17 am
So there's no blocking? Don't use sp_who2, query the session and requests DMVs directly. Lots more information.
SELECT * from sys.dm_exec_requests where session_id > 50;
What are the wait_types and wait_resources that...
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
March 20, 2009 at 8:11 am
Viewing 15 posts - 40,231 through 40,245 (of 49,552 total)