October 17, 2011 at 9:52 am
Q. Can you add a data file to existing mirror configuration?
A.
Q. Can you re-do the mirroring with latest backup?
A.
Q. Why you cannot do t log backups in simple recovery model?
A.
Q. What is the best replication for performance level?
A.
Q. What memory (OS or SQL Server memory) does it uses while backing up the database?
A.
Q. Does Restore and backup will take same time?
A.
October 17, 2011 at 9:57 am
homework?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 18, 2011 at 7:37 am
I would say so... Question 3 is a dead giveaway.
October 18, 2011 at 7:47 am
Interview questions is my bet, with no research done. Google is almost certain to have useful results for all of those.
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 18, 2011 at 7:48 am
edit: removed inappropriate response.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 18, 2011 at 7:53 am
...edited...
October 18, 2011 at 8:03 am
EDIT: Maybe discussing the question on replication is important. My thoughts are that it is not performance that is the deciding factor on which type of replication to use, but what the use case is. We use Transactional Replication for replicating certain data from 4 production servers to our reporting server. The production servers are set up such that the application can write to any of the 4 servers, but always write to the "closest" as default. Other data is not replicated for reporting, but is replicated for failover. Since our company has decided against clusters and mirrors, we are using Transactional Replication with updatable subscriptions for these cases. I am relatively new to using replication (started with this company in April) and this seems to work fine for us. Any thoughts?
Jared
Jared
CE - Microsoft
October 18, 2011 at 8:03 am
For the original poster: Please use a search engine or Books Online to research these questions. We are happy to help you with specifics, but without any effort on your part, we don't look to do the work for you.
For responders: Please do not joke or pick on posters. It doesn't help them to learn or have confidence to respond to others.
October 18, 2011 at 8:11 am
Steve Jones - SSC Editor (10/18/2011)
For the original poster: Please use a search engine or Books Online to research these questions. We are happy to help you with specifics, but without any effort on your part, we don't look to do the work for you.For responders: Please do not joke or pick on posters. It doesn't help them to learn or have confidence to respond to others.
You are absolutely right Steve. I certainly don't want to impede learning in any way. Sorry if my comments were offensive.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 18, 2011 at 8:13 am
Steve Jones - SSC Editor (10/18/2011)
For the original poster: Please use a search engine or Books Online to research these questions. We are happy to help you with specifics, but without any effort on your part, we don't look to do the work for you.For responders: Please do not joke or pick on posters. It doesn't help them to learn or have confidence to respond to others.
Many apologies
October 18, 2011 at 9:22 am
nigel. (10/18/2011)
Sean Lange (10/18/2011)
... 😛...edited...
Nigel - could you also edit the quote since Sean edited his original comment and apologized?
Kudos to the respondents for cleaning it up:-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 18, 2011 at 9:39 am
Kudos to the respondents for cleaning it up
Not only cleaning it up but also to encourage new guys to come upfront as well. I know few of the forums where it’s not monitored and few experts use the language they should not.
I very much appreciate Steve’s intervention and then the cleanup from the guys (it shows their humbleness).
I am becoming a fan of SSC now. 🙂
October 18, 2011 at 9:42 am
Dev @ +91 973 913 6683 (10/18/2011)
I am becoming a fan of SSC now. 🙂
You werent before? 🙂
October 18, 2011 at 9:45 am
Nigel - could you also edit the quote since Sean edited his original comment and apologized?
I tried to clean it myself; am not authorised. Now I understand why you posted it (& not cleaned it yourself).
October 18, 2011 at 9:48 am
You werent before? 🙂
I am new here... It takes time 😛
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply