It's not a best practice to create user tables in the PRIMARY filegroup to begin with. Leave PRIMARY just for the system catalog, create at least one new filegroup...

Yes, if you rebuild an index, then the stats for the associated columns do get automatically updated in a manner equivalent to fullscan. (Although if your only goal is...

Try using multiple destination files for your backup. Also, you haven't mentioned if you're using compression or not. These should significantly help the backup and restore speeds. ...

Lots of folks have posted informative replies; but at the end of the day, the only way to know for sure in your own situation is to gather the data....

actually, char(10) IS the newline character. Maybe you're looking for carriage return? If so, that's char(13)

Here's a similar one to the one linked directly above, but that also brings in the showplan XML. A little "heavier" query, but very useful if used sparingly.

SELECT TOP...

alter database <mirrorDB> set partner FORCE_SERVICE_ALLOW_DATA_LOSS

This allows the mirror DB to come online without any further attempt on the server's part to apply more log bytes from the principal.

As others have said, don't shrink files unless you really have no choice. I know this is development, but once you shrink the files, your indexes will generally get...

Maybe this will help you identify the source of the tempdb log file usage; although indirectly because it's looking more at tempdb objects

/** tempdb usage by task **/

SELECT distinct t1.session_id,...

Client .NET build shouldn't matter a bit if all that's changing is the SQL Server version.

Agree on the comment about the driver issue. The SQL Server native client (SNAC) driver doesn't ever need the port as long as it's the default port. But...