Viewing 15 posts - 13,891 through 13,905 (of 49,552 total)
kevaburg (3/14/2013)
My train of thought is that if the recovery model were changed to SIMPLE, we could in effect "unlock" the table and delete it.
The only two things that change...
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
March 14, 2013 at 7:43 am
Yes.
ALTER TABLE <table name> ADD <column name> BIT NOT NULL DEFAULT 0;
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
March 14, 2013 at 7:03 am
A failover involved SQL starting cold on the second node. There's no memory transfer, the databases are shared but that's all.
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
March 14, 2013 at 6:47 am
Restart the instance, it's a hung rollback. If it's 0 seconds remaining, there won't be a prolonged recovery period.
Recovery models have no effect on rollback, so doesn't matter which one...
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
March 14, 2013 at 5:25 am
Cool. In that case the business rules for how, when and by what criteria rows are archived will guide your choice of partition column.
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
March 14, 2013 at 4:12 am
sqlguy-736318 (3/13/2013)
Gail - Correct me if I'm wrong but if I...
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
March 13, 2013 at 3:46 pm
sqlguy-736318 (3/13/2013)
Thanks for the feedback. In my first query please ignore the "top 10" in my select statement to keep my question more focused.
The TOP has very little to...
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
March 13, 2013 at 2:25 pm
What are you trying to achieve by partitioning?
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
March 13, 2013 at 1:58 pm
Depends on the indexes you have.
If you have no indexes, that's a table scan and SQL will apply both filters as it scans the table. If you have an...
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
March 13, 2013 at 1:50 pm
DiegoPeña (3/13/2013)
If you dont have the coin:
Encouraging copyright violation there are we.... I hope you're not also telling people to steal books that I've written, I get little enough royalties...
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
March 13, 2013 at 12:24 pm
Why are you partitioning? What's the goal here?
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
March 13, 2013 at 11:14 am
Restore from last good backup, that's irrepairable.
If there's absolutely no backup whatsoever, export all the documents, lists, etc from sharepoint (not a SQL data export), then drop and recreate the...
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
March 13, 2013 at 11:12 am
Exactly the same as a join between two normal tables. Yes, your example is completely correct.
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
March 13, 2013 at 9:02 am
Ignore it? If it's not causing any problems, just ignore it.
Oh, and don't shrink TempDB, it's documented to be able to cause corruption.
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
March 13, 2013 at 8:29 am
There's no such list. The optimiser can pick table scans even when the where clause looks like it could use an index. Has to do with % of rows returned,...
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
March 13, 2013 at 7:11 am
Viewing 15 posts - 13,891 through 13,905 (of 49,552 total)