Viewing 15 posts - 11,956 through 11,970 (of 49,562 total)
Jeff Moden (8/25/2013)
Index Seeks are always better than index...
August 26, 2013 at 3:16 am
Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.
Do you know how much data was lost?
Do you...
August 26, 2013 at 3:12 am
Jeff Moden (8/25/2013)
GilaMonster (8/25/2013)
What's your favourite index-related myth?What's yours?
I have a few, but I need fodder for the PASS presentation (that's due today) 😀
August 25, 2013 at 3:05 pm
AVB (8/25/2013)
No testing has been done yet as I'm in a "merged" logical and physical design phase.
Beware premature optimisation (making non-standard, over-complex design decisions based on untested performance assumptions)
You're looking...
August 25, 2013 at 2:59 pm
AVB (8/25/2013)
At some point 95% of shipments and invoices will move into a final status (Paid, Shipment Delivered) so I would think indexes wouldn't be useful.
If you frequently query...
August 25, 2013 at 2:41 pm
What's your favourite index-related myth?
August 25, 2013 at 1:54 pm
That check constraint won't prevent rows in tEmployeesStatus from being deleted/updated if there's a matching row in the child table. A foreign key will (or will cascade the delete/update if...
August 25, 2013 at 1:53 pm
What does it print out?
August 25, 2013 at 10:48 am
Jeff Moden (8/24/2013)
the data isn't actually written as you would think until the transaction is committed.
In both cases the data changes are made to pages in memory and those changes...
August 24, 2013 at 4:26 pm
MyDoggieJessie (8/24/2013)
so it's basically reading it from the last known outcome of the prior CHECKDB that was successful.
Correct. It's printing out the date and time last known good CheckDB run....
August 24, 2013 at 7:50 am
MyDoggieJessie (8/24/2013)
Whenever I look at the SQL logs after a service restart I see that every database has had a checkdb run against it by a system spid ...
Nope....
August 24, 2013 at 5:48 am
ALTER DATABASE <db name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS instead of PARTNER OFF
Forces the mirror online without destroying the mirroring config entirely.
August 24, 2013 at 3:17 am
Developer edition however is licensed for non-production usage only. You have a 7TB database that you're developing against?
August 24, 2013 at 3:15 am
anoop.mig29 (8/24/2013)
@Gail problem is there are 2 dr of a single primary and only is participating in DR drill so i cannot stop ls backup job at primary.
I never said...
August 24, 2013 at 3:12 am
MyDoggieJessie (8/23/2013)
My boss wanted to try the REPAIR_ALLOW_DATA_LOSS first before restoring from the backup and we tried that...it ran for 25 mins when I was instructed to kill it.
So...
August 24, 2013 at 3:09 am
Viewing 15 posts - 11,956 through 11,970 (of 49,562 total)