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...

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...

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...

2016's not even released yet. Certification info won't be released before the product is.

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...

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....

Short of replacing your IO subsystem with something faster, there's nothing you can really do.

Why do you want to create more files?

shaneoneillis (4/6/2016)

---

If you want to include them when you script a table go to the following on SSMS:

Tools --> Options --> SQL Server Object Explorer --> Scripting --> under "Table...

TomThomson (4/6/2016)

---

Brandie Tarvin (4/6/2016)

---

Good morning, peeps.

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...

It's the join operator. It's what SQL uses to match the rows from one table to the other.

Well it's lunch time, so

Lentil, chicken, bacon and feta salad(also contains cucumber, spring onion and pepperdew)

Full backups do not ever truncate the transaction log

b) incremental backup does not include transaction log, and...

You need to get it, because those are numbers you'll be held to when/if a disaster happens.

If...

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...