Viewing 15 posts - 34,186 through 34,200 (of 49,552 total)
Edwin-376531 (2/5/2010)
What is the Microsoft recommended good practices to cope this kind of scenario?
A good backup strategy designed according to the downtime and data loss requirements of the application.
February 5, 2010 at 1:03 pm
The estimated row count on your actual physical table is wrong. SQL thinks that the physical table contain only 1000 rows and hence that a scan of the physical table...
February 5, 2010 at 12:35 pm
Bru Medishetty (2/5/2010)
It would still be one of the better features for having multiple copies of data.
Sure, it's fine for secondary reporting systems. It's just bad for hot failover...
February 5, 2010 at 12:15 pm
Luke L (2/5/2010)
Yes, but you'll have to wait for Gail's Blog post on DBCC TimeWarp to make certain you get all 137 non-optional parameters correct.
btw, as an aside, in case...
February 5, 2010 at 11:53 am
Replication is not a high availability technique. While it can create a copy of a database, it's a pain to switch apps over, it may not be a complete copy...
February 5, 2010 at 11:41 am
namrata.dhanawade-1143388 (2/5/2010)
But that would mean to look at other things for my performance issue.
Yup. Poorly written queries, inadequate indexing. Main causes of any perf problem.
February 5, 2010 at 8:42 am
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some...
February 5, 2010 at 8:41 am
subs99 (2/5/2010)
February 5, 2010 at 8:37 am
pradeep_kodley175 (2/5/2010)
insert into TestReport (Answer) select Answer from Question where YourQues.TestReport= Question.Question;but its shoing error like "The multi-part identifire "YourQues.TestReport" could not be bound"...
There's no object called 'YourQues' anywhere in...
February 5, 2010 at 8:34 am
suresh.maddali (2/5/2010)
1. Go to c:\Program files\Microsof Sqlserver\MSSQL.1\Data...
February 5, 2010 at 7:15 am
zhayatali (2/5/2010)
February 5, 2010 at 4:22 am
The backup that you took at 12:51 cannot be used to restore to 12:30. There's no time machine in SQL.
You need to take the latest full backup from before 12:30,...
February 5, 2010 at 4:11 am
What more are you looking for?
http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/
http://sqlinthewild.co.za/index.php/2008/04/23/execution-plans-important-properties/
February 5, 2010 at 4:03 am
With the 3 indexes that you have defined there, the only queries that will perform optimally there will be the ones that filter on a single column. When using predicates...
February 5, 2010 at 12:03 am
Viewing 15 posts - 34,186 through 34,200 (of 49,552 total)