Viewing 15 posts - 29,041 through 29,055 (of 49,552 total)
If you put the mirror onto reporting or dev, think what will happen if there's a failover and the reporting or (heaven forbid) dev server is hosting the active production...
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
December 5, 2010 at 3:57 pm
allin1 (12/5/2010)
If i want to mirror the DBs on Prod server where do i keep the mirror ?
On a second production server. They're production databases and should the principal...
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
December 5, 2010 at 3:03 pm
Too technical. Business users aren't going to understand the significance of the options. A finance person isn't going to have a clue how the databases should be backed up nor...
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
December 5, 2010 at 2:40 pm
sandippani (12/5/2010)
Have a look to this link :http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx
However note that the first 'fact' stated in that article is incorrect. Changes to table variables are logged. They don't participate in user...
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
December 5, 2010 at 2:27 pm
That's correct. That's why the option is REPAIR_ALLOW_DATA_LOSS
Very hard to figure out what's gone. If there's a clustered index you can figure out the range of rows that would be...
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
December 5, 2010 at 12:23 pm
Unless you have a copy of the database from the date in question, you will not be able to recovery. A restore overwrites the database completely.
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
December 5, 2010 at 11:20 am
PaulB-TheOneAndOnly (12/5/2010)
Moreover, example below doesn't show any difference in explain plan meaning, no differences for select against constrained and non-contrained version of the table.
Two points.
That query is simple enough 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
December 5, 2010 at 9:15 am
PaulB-TheOneAndOnly (12/4/2010)
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
December 5, 2010 at 9:12 am
Please note: Almost 2 year old thread.
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
December 5, 2010 at 1:20 am
Yes, that's exactly what it does. Deallocate the damaged pages and fix up the links.
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
December 4, 2010 at 11:09 am
vinayak.v (12/4/2010)
i didn't get u sir...
You posted your question 4 times. That won't get it answered faster, it'll just irritate people.
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
December 4, 2010 at 10:56 am
You can't drop the tables because the database is suspect. While the database is in the suspect state you cannot even use it, much less change it. You can switch...
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
December 4, 2010 at 10:52 am
Great, now can you answer the one outstanding question - frequency of your log backups.
While you're at it, 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
December 4, 2010 at 4:47 am
A few questions first:
What recovery model?
What's the interval on log backups (if answer to recovery model != Simple)
Why two log files?
Why do you want to reduce the size of 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
December 4, 2010 at 2:47 am
PaulB-TheOneAndOnly (12/3/2010)
Brigadur (12/3/2010)
Constraints can actually be used by the optimizer to speed up a query.Hope you are referring to Referential Integrity constraints.
Check and not null constraints can too.
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
December 4, 2010 at 2:38 am
Viewing 15 posts - 29,041 through 29,055 (of 49,552 total)