If this is a particularly busy system, I'd consider restoring a recent backup onto another server and run CHECKDB against that.

It can be a pretty intensive taskand may...

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

I'm pretty sure this is still applicable to 2008R2 Express.

+1 with Steve.

There is probably some other factor effecting your chances. Age is certainly not one of them. I'm now 35 and have been a DBA by...

We could do with seeing an example of the connection string and knowing whether you are using trusted (windows) authentication of a SQL login.

With trusted authentication you should not be...

jason123 (11/9/2013)

---

Hi,

I am using Transnational replication of Microsoft SQL Server 2008. I always face one problem when distributor database fails eventually. It requires re-initializing subscriptions when I restore distributor database....

I'm not sure I follow. Adding a new file will not force SQL to release space taken by the tempdb. The safest way to resize tempdb files is...

No. Just google its use and/or search these forums.

The only time I've seen a SELECT statement block a job was when it was...

I was looking for some useful information regarding connection pooling and found this excellent blog post to describe it on msdn.

http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/10/08/connection-pooling-for-the-sql-server-dba.aspx

http://technet.microsoft.com/en-us/library/ms143432.aspx

http://technet.microsoft.com/en-us/library/ms187030.aspx

SQL Server allows a maximum of 32,767 user connections. Because user connections is a dynamic (self-configuring) option, SQL Server adjusts the maximum number of user...

Could you reschedule and change tsm to simply backup from DISK the native backup file you have taken already?

Taking two full backups could impact your ability to take and restore...

BTW this is a physical limitation of SQL. There is no "work around" other than to fix the problem

This should never happen because of connection pooling and points to 1 or many poorly written applications maintaining open connections. Unless you really have...

The current recommendation is to set it to the number of cores per NUMA node (if equipped), 8 for servers with 8 or more processors, 0-N for servers with less...

IMO you are probably best considering what databases are on which instance and giving a priority weighting to each. Then divide the available RAM up between these according to...

GilaMonster (11/6/2013)

---

Even with sort in tempdb, there will still be free space left from where the index used to be. How much depends on the order that the rebuilds are...