Viewing 15 posts - 3,301 through 3,315 (of 49,552 total)
So that full backups don't mess with the log chain.
And the full backup doesn't back up the entire transaction log. Just what it need to restore consistent. So if 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
April 7, 2016 at 7:21 am
You don't need any traceflags for deadlocks to show up in system health.
1204 was the old SQL 2000 traceflag for deadlock graphs, it shouldn't be used on any version since...
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
April 7, 2016 at 7:07 am
John Jensen-439690 (4/7/2016)
but all of them gives bad performance
Yes, they will, for reasons explained in the article I referenced earlier
https://www.simple-talk.com/content/article.aspx?article=2280
It's not the split that's the problem, it's the form 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
April 7, 2016 at 6:51 am
2016's not even released yet. Certification info won't be released before the product is.
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
April 7, 2016 at 5:29 am
https://msdn.microsoft.com/en-us/library/ms176061.aspx
FOR ATTACH [ WITH < attach_database_option > ]
Specifies that the database is created by attaching an existing set of operating system files. There must be a <filespec> entry that specifies...
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
April 7, 2016 at 4:54 am
What sequence number? There's no 'sequence' column in any of those tables, no indication where it comes from, how it's calculated.
We can't read your mind, we can't see your screen....
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
April 7, 2016 at 4:19 am
Short of replacing your IO subsystem with something faster, there's nothing you can really do.
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
April 7, 2016 at 2:50 am
Why do you want to create more files?
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
April 6, 2016 at 10:17 am
shaneoneillis (4/6/2016)
Tools --> Options --> SQL Server Object Explorer --> Scripting --> under "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
April 6, 2016 at 9:48 am
TomThomson (4/6/2016)
Brandie Tarvin (4/6/2016)
What are we having for breakfast today?
Mine was oatmeal with purple honey (from North Carolina) and assorted fruit. But for some reason I have pancakes...
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
April 6, 2016 at 9:48 am
It's the join operator. It's what SQL uses to match the rows from one table to the other.
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
April 6, 2016 at 9:42 am
Brandie Tarvin (4/6/2016)
What are we having for breakfast today?
Well it's lunch time, so
Lentil, chicken, bacon and feta salad(also contains cucumber, spring onion and pepperdew)
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
April 6, 2016 at 5:45 am
szejiekoh (4/6/2016)
a) is transaction log (eligible for or/& being truncated) after full backup ?
Full backups do not ever truncate the transaction log
b) incremental backup does not include transaction log, and...
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
April 6, 2016 at 4:34 am
szejiekoh (4/6/2016)
It is because I do not have the answer myself as well
You need to get it, because those are numbers you'll be held to when/if a disaster happens.
If...
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
April 6, 2016 at 4:28 am
Script them separately (right click index, script), or use the Generate Scripts wizard, specify just the table and use the Advanced button (on the 'set scripting options') page to include...
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
April 6, 2016 at 3:49 am
Viewing 15 posts - 3,301 through 3,315 (of 49,552 total)