Viewing 15 posts - 40,246 through 40,260 (of 49,571 total)
""Sameer"" (3/21/2009)
If you have questions about these tables, please contact the instructor for clarification.
Please contact the instructor? Are you asking us to do your homework for you?
March 21, 2009 at 6:38 am
achleshsoni (3/21/2009)
A lot of things could be the cause like memory pressure, poor plan reuse, auto update stats, reindexing, ddl etc.
None of the things you list there will cause...
March 21, 2009 at 4:37 am
It's not necessarily one query. It may be that there are a number of queries all using excessive CPU.
Check sys.dm_exec_requests to see what's currently running and what cpu they've useds....
March 21, 2009 at 2:59 am
I was wondering why there were so few posts lately... I haven't seen more than 4 pages in any of the 'recent posts' options for at least a week.
This morning,...
March 21, 2009 at 2:50 am
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...
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...
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...
March 20, 2009 at 2:24 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/
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...
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...
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...
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...
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(*)...
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...
March 20, 2009 at 8:47 am
Viewing 15 posts - 40,246 through 40,260 (of 49,571 total)