Viewing 15 posts - 3,616 through 3,630 (of 49,552 total)
Alan.B (2/11/2016)
For those of you who are intoquantum mechanicsrelativity...IT'S OFFICIAL: Gravitational waves have been detected, Einstein was right
</pedantic>
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
February 12, 2016 at 2:23 am
chris.munsell (2/11/2016)
First, is it possible.
Yes
Second, anything I need to watch out for?
Having done this recently, multiple times, make the distributor SQL 2014 and do the entire setup from Management...
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
February 11, 2016 at 1:33 pm
Drop the indexes. Then, once they're dropped run CheckTable on the two tables and see if there's any corruption remaining.
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
February 11, 2016 at 12:17 pm
Steve Jones - SSC Editor (2/11/2016)
If you enjoy the 80s, I might recommend Ready Player One as a read. Lots of memories in there.http://www.amazon.com/Ready-Player-One-A-Novel/dp/0307887448
Seconded. It's excellent.
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
February 11, 2016 at 11:48 am
Basically, you don't.
From Books Online
"TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not...
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
February 11, 2016 at 6:13 am
The output already lists what the affected objects are.
CHECKDB found 0 allocation errors and 588 consistency errors in table 'ep1.EDIDS' (object ID 81643584)
CHECKDB found 0 allocation errors and 34 consistency...
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
February 11, 2016 at 5:59 am
No, because there will be other errors that indicate which object it's part of.
Without seeing the entire output of CheckDB I can't tell you how to fix it.
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
February 11, 2016 at 5:17 am
It's part of the 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
February 11, 2016 at 5:08 am
Someone\something is running BACKUP LOG <db name> WITH NORECOVERY as that backs up the log and then switches the DB into the RESTORING state.
Probably a backup dialog or job...
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
February 11, 2016 at 5:04 am
Can you pull the estimated plan from SQL 2014 and the actual plan from 2008 R2 and post them both?
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
February 11, 2016 at 2:55 am
There are two predicates, so the expected cardinality is multiplied together
If the first is expected to affect 50% of the rows and the second 20% of the rows, then 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
February 10, 2016 at 11:28 am
ChrisM@Work (2/10/2016)
GilaMonster (2/10/2016)
ChrisM@Work (2/10/2016)
and it would have met Gail's precautionary restrictions too.
My comments had nothing to do with what the function returns, rather where to use it (not in a...
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
February 10, 2016 at 1:59 am
"Next version" always means next major version, not next service pack.
Upgrade advisor is for upgrading major versions (eg to 2012 or 2014), it doesn't check anything regarding applying service packs
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
February 10, 2016 at 1:58 am
Can you perhaps give more information? To start, what are you trying to do, to what, with what, etc, etc.
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
February 10, 2016 at 1:55 am
ChrisM@Work (2/10/2016)
and it would have met Gail's precautionary restrictions too.
My comments had nothing to do with what the function returns, rather where to use it (not in a DML statement...
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
February 10, 2016 at 1:50 am
Viewing 15 posts - 3,616 through 3,630 (of 49,552 total)