I see what you mean. Can you please clarify which performance counter you're lokking at?

Processor - %Processor Time has a numeric instance for each logical processor and not for sqlserver...

SELECT @@servicename on each instance will return the instance id, which is the suffix appended to the performance counter names.

Something like this:

SELECT DB_NAME(database_id) AS database_name,...

Is it a heap table? There's a well known issue with deleting from heaps without the appropriate locks. Use WITH TABLOCK in the DELETE statement to work around it. Or,...

AUTO_SHRINK kicks in when 25% of the database space is unused. See https://msdn.microsoft.com/en-us/library/bb522682.aspx

Performance implications? Many and nasty. Fragmentation primarily. See this blog for details: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx

dwain.c (2/24/2015)

---

Jeff Moden (2/23/2015)

---

So, let me ask... do you have an Employee table or an Employees table? Do you have a Company table or a Companies table? Do...

Why wouldn't it work? I'm pretty sure I have done this in the past.

I'm not trolling...

This should be what you're looking for: http://spaghettidba.com/2014/09/05/database-free-space-monitoring-the-right-way/

Do yourself a favour and use proper version control tools.

Popular version control systems:

* Git

* Mercurial

* SVN

* CVS

* TFS

See here for a quick comparison: http://www.sitepoint.com/version-control-software-2014-what-options/

Visual Studio can work with all...

You can evict the old node and then add the new node to the cluster. Would it work for you?

You're right: the constraint name is system generated, so it won't likely be the same on different databases. It's a best practice to name constraints to avoid fighting with different...

I...

Compressed columns are compressed in the backup, but it's a different kind of compression compared to backup compression. In the first case it's row/page compression, in the second case it's...

Highly debatable...

The ISO standards suggest that table names are pluralized. I admit that I agree with Celko on this one.

I have to admit that the points you make are good....

If the updates require a Windows restart, go for it. You'd better do it when users are not using the database, so plan downtime with them.