Viewing 15 posts - 16,171 through 16,185 (of 49,552 total)
That to repair this error you need to run checkDB with the repair_allow_data_loss option, and it will cause data loss, as I mentioned earlier. 2MB or so of that 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
October 11, 2012 at 4:39 pm
I don't recommend enabling large pages, it can have some effects at startup and it doesn't usually help much, if at 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
October 11, 2012 at 2:41 pm
Transactional replication. Database mirroring with snapshots.
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
October 11, 2012 at 2:39 pm
You'd have to replace the master.mdf and master.ldf, and if you do so you will lose all logins, server-level permissions, linked servers and a bunch more. Got a backup of...
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
October 11, 2012 at 11:24 am
Ok, you are going to lose data.
You can repair the corruption and lose 2MB of so from that table or you can restore back to last good backup. Which?
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
October 11, 2012 at 11:22 am
You can, but unless you have log backups, you're looking at losing all data since the backup that you use to restore. Is that acceptable (potentially going back to mid...
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
October 11, 2012 at 10:49 am
The table with the problems is RegPreReturnsTbl
You're going to almost certainly lose data here. Looks like around 256 contiguous pages have been mangled. That's about 2MB of data from that...
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
October 11, 2012 at 10:35 am
Well, at a high level, all used data pages read from the data file and written into the backup file. That's the core. It's a bit of a simplification, but...
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
October 11, 2012 at 8:29 am
Reference: Creating an Indexed View in Books Online
So, go look in Books online under the section "Creating an Indexed View"
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
October 11, 2012 at 8:01 am
aadharjoshi (10/11/2012)
GilaMonster, Its extremely necessary to improve query performance..even if it process execution paralleled.
Then you probably don't want to change to joins, because that will not have the desired effect.
Please...
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
October 11, 2012 at 6:39 am
Jason-299789 (10/11/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
October 11, 2012 at 6:38 am
Sagesh (10/11/2012)
Use WITH Encryption Keyword with all the SQL objects while installing on the production system.
As I mentioned earlier in this thread, that's not actually encryption and it's trivial 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
October 11, 2012 at 6:37 am
Why do you want to know? What problem are you investigating?
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
October 11, 2012 at 5:21 am
aadharjoshi (10/11/2012)
Most probably i can remove in clause and use inner join..
Why? To make the query slightly less efficient and possibly duplicate rows?
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
October 11, 2012 at 5:21 am
It doesn't necessarily actually do a distinct.
I personally would not recommend changing the update to use the update from syntax. Since we know that the join will produce duplicate rows,...
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
October 11, 2012 at 5:19 am
Viewing 15 posts - 16,171 through 16,185 (of 49,552 total)