Viewing 15 posts - 17,716 through 17,730 (of 49,552 total)
najeeb_kt2000 (7/10/2012)
DBCC CheckDB (‘FlexFamilyMembership’), (REPAIR_ALLOW_DATA_LOSS)
Wait... what???
Yo do realise that is going to cause data loss? No backups? No alternatives to throwing data away?
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
July 10, 2012 at 4:19 am
No idea, could be anything. What is this mysterious file called?
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
July 10, 2012 at 4:16 am
Wait until no one is using the table.
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
July 10, 2012 at 4:15 am
Restore from backup.
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
July 10, 2012 at 4:15 am
You will get a database that is transactionally consistent as of the point that the backup completed.
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
July 10, 2012 at 4:09 am
Not entirely.
What messages?
The backup copies the data pages as it encounters them. It also copies the portion of the tran log it needs to make the restore consistent.
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
July 10, 2012 at 3:38 am
The backup started after the commands started, so as long as they finish before the backup finishes, they will be in the restored 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
July 10, 2012 at 2:52 am
If all you're trying to do is find the top 3 by the pk, that method is not what you want to use, it's overkill. It's for when you want...
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
July 10, 2012 at 2:50 am
Post your code.
Typically you'd use TOP (3), but I'm not sure what you're doing,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
July 10, 2012 at 2:30 am
Nope. Once-off shrink to get things to a reasonable size, sure. Regular shrink, no.
Please read through this - Managing Transaction Logs[/url]
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
July 9, 2012 at 3:59 pm
CELKO (7/9/2012)
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
July 9, 2012 at 3:18 pm
Fly Girl (7/9/2012)
From what I've been learning in my reluctant dba-dom on this contract, tempdb files equaling the count of processors/cores is in line with best practices.
Not really. On...
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
July 9, 2012 at 3:08 pm
Couple steps back... Why are you partitioning? What's the purpose and expected gain?
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
July 9, 2012 at 2:42 pm
Levels 6 and 7 are sitting in my mail box, waiting to be edited.
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
July 9, 2012 at 2:33 pm
Unless you're dealing with nulls, no difference. If you are dealing with nulls, the behaviour is different so you need to check which one gives the correct results
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
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
July 9, 2012 at 2:32 pm
Viewing 15 posts - 17,716 through 17,730 (of 49,552 total)