The files the default trace creates are normal profiler trace files. You can copy them anywhere, open in profiler, load into SQL, whatever.

It has a very limited set of events,...

The INSERT ... EXEC can be used to insert into a table variable or temp table. A CTE however, despite its name, is not a table and hence can not...

Impact in what sense?

It's going to take time, time in which the table will be locked. It will take space. It will add time to index maintenance. If you've done...

Exceedingly unlikely, unless you happen to be running CheckDB at a time when large...

Grant Fritchey (8/20/2013)

---

But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of...

As I said earlier

Do you need to read the secondary? For example, offloading reports. If so, use standby. If not, use no recovery.

Not sure about the EXCEPT, but...

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Partitioning is not primarily for performance. It's for management, data loads, easy archiving. That it doesn't magically improve performance...

Partitioning is not primarily for performance.

Nothing to do with reindex.

The reason's given. "The specified network name is no longer available.", the network dropped and the backup failed as a result.

p.s. 18 days to reindex? What's...

You can, but bear in mind that only works if the database was shut down cleanly before removing the log. Otherwise you'll end up with a database that fails to...

You only need one log file. You can create more, but there's very seldom a good reason to do so.

There's no such thing as a nested transaction. It's a syntactical lie, they don't actually exist.

Ed Wagner (8/19/2013)

---

I think the number of people posting questions without first doing one iota of research has gone up. I also think the homework questions have increased. ...