Viewing 15 posts - 11,251 through 11,265 (of 49,552 total)
Nolock means 'with potentially incorrect data', not usually this incorrect, but you should expect to not always get correct results when you use nolock. It's why it's not recommended for...
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 21, 2013 at 2:49 pm
alanspeckman (10/21/2013)
Backing up Log Shipped databases
Do not take other log backups of a log shipped DB or you will break the log shipping
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 21, 2013 at 12:50 pm
If there's no demand for free pages, no pressure to remove objects from cache to make space for new pages, then older objects could stay in cache for long periods....
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 21, 2013 at 11:38 am
For those who weren't at Summit, here's some of the recordings, keynotes, the WIT lunch, a few of the sessions
http://www.youtube.com/playlist?list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC
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 21, 2013 at 11:00 am
Yes it will interfere.
I strongly recommend you do one set of backups with one technology. Do all your backups natively or do them all through a 3rd person. At best...
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 21, 2013 at 9:35 am
dwain.c (10/21/2013)
GilaMonster (10/21/2013)
dwain.c (10/21/2013)
Not sure how advisable that is.It's strongly not recommended.
I was being polite.
So was 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
October 21, 2013 at 9:27 am
You can do that, the row_version data type's great for that as you don't have to do manually update it. I've also seen people use a calculated column defined as...
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 21, 2013 at 6:49 am
An instance is an installation of the database engine. Don't understand your other questions
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 21, 2013 at 6:40 am
Couple comments.
The process as it is now tests your backups. If you change to log shipping, then you lose that testing of your backups and you will need to either...
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 21, 2013 at 6:39 am
dwain.c (10/21/2013)
Not sure how advisable that is.
It's strongly not recommended. Transactions should be started and committed/rolled back in a single trip to the database, not left open during user interaction....
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 21, 2013 at 6:37 am
No, there isn't. Also be aware that the places you mention are estimates, not necessarily completely accurate values.
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 21, 2013 at 6:31 am
New persopn (10/19/2013)
here i have shrink the log now we got 30 gb space. here we have 360gb log now. can i reduce it up to 300gb.
No way to answer...
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 20, 2013 at 12:52 pm
For Model, that's overkill. The database is only used as a template to create other databases (including TempDB), so it should never see any load, so it shouldn't need anything...
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 20, 2013 at 12:45 pm
If the only damage was the IAM page, probably not. They can be recreated without losing data, though it does require the allow_data_loss option.
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, 2013 at 1:41 pm
Whatever works for you. I prefer to diagnose the cause of a problem before deciding on a solution, but maybe that's just me.
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, 2013 at 1:38 pm
Viewing 15 posts - 11,251 through 11,265 (of 49,552 total)