Viewing 15 posts - 11,956 through 11,970 (of 49,552 total)
Jeff Moden (8/25/2013)
Index Seeks are always better than index...
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
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...
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
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) 😀
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
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...
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
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...
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
August 25, 2013 at 2:41 pm
What's your favourite index-related myth?
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
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...
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
August 25, 2013 at 1:53 pm
What does it print out?
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
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...
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
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....
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
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....
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
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.
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
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?
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
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...
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
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...
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
August 24, 2013 at 3:09 am
Viewing 15 posts - 11,956 through 11,970 (of 49,552 total)