Grant Fritchey (3/24/2016)

---

Hugo Kornelis (3/23/2016)

---

In almost 20 years of working with SQL Server, I have only once used an index hint in a production query, and that was after I...

Why no temp tables? The normal solution would be to EXEC into the temp table, then query it.

ChrisM@Work (3/24/2016)

---

Grant Fritchey (3/24/2016)

---

Steve Jones - SSC Editor (3/24/2016)

---

WayneS (3/24/2016)

---

Yes it does... even those that speak frequently. I know of a fellow...

A quick google search should answer the first and second at least.

Why don't you have a read through the search results for the first and second, then once you understand...

helper_10 (3/19/2016)

---

Multiple file groups in the same drive, Not So Much but If you can divide those file groups in multiple locations (Drives) there is huge positive impact in...

Performance, probably not, but trying to keep 20TB in one filegroup is probably not a good idea for backup/restore reasons.

Designing a filegroup layout for that is complicated though.

You mean you don't like my answers in the other thread?

Please stick to a single thread, otherwise people end up wasting their time (and...

Not a particularly good idea, as the restore process is more complicated when you do file and filegroup backups. You'll need to take log backups as well and restore those...

No you can't. Writing directly to a table is a feature of the Profiler GUI (and is usually a bad idea, especially if writing to the instance being traced)

Schedule your...

When you back up a database, you back up the entire database. How the backup is written doesn't depend on the file/filegroup structure of the DB.

By striping the backup (as...

Please don't post multiple questions for the same problem.

No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1772009-24-1.aspx

Um, the answer to that is exactly the statement that you said you understand.

You cannot truncate log records which are still needed for something, no matter how many log backups...

Statistics mostly, table variables don't have them. Lots of rows in a table variable can result in really bad row count estimates by the optimiser...

szejiekoh (3/17/2016)

---

Does it literally means that a truncate will happen after a logbackup (provided there is a checkpoint after the last backup) ,but , the truncation will only truncate up...

szejiekoh (3/17/2016)

---

But given that the checkpoint has run, there might be still uncommitted / active transactions inside the transaction log, can the log be truncated then (even if backup...