Keep in mind sp_MSforeachdb is an undocumented stored procedure, and may be removed in future versions. If this is for actual production development please use what GSquared provided.

This should get you close.

EXEC sp_MSForEachDB 'Use ?; select table_catalog, table_name, count(*) from information_schema.columns

where table_catalog like ''k%''

and table_name = ''hist''

group by table_catalog, table_name'

As with most things if you require expert results you probably need an expert.

Here are some helpful links to get you started.

http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

http://www.brentozar.com/archive/2011/05/keys-deploying-sql-server-on-vmware/%5B/url%5D

http://technet.microsoft.com/en-us/sqlserver/gg429826

The two machines can be well isolated, but it greatly depends on your configuration.

Here's a shotgun. It has the potential to bring your server to it's knees, so don't even think about running this anywhere near a production server.

DECLARE @sql...

http://support.microsoft.com/kb/918760

ScottPletcher (9/28/2012)

---

You could try:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

If that doesn't work, there are SERVERPROPERTY parameters that aren't documented: you might try poking around for some of those and see if any of them...

With VMWare having the VMware Tools installed, or in systray is a pretty good indicator.

Your post is pretty vague so my response is vauge.

Scope creep can be a pretty big problem for BI projects irrespective of the size of the company. Is there...

I'm not sure why you are not able to do an inplace upgrade. But failing every thing else, you can always just backup the database and restore it or...

You should also look at the cluster events in the cluster manager.

VygonDBA (8/3/2012)

---

Morning all,

I was lucky enough to be promoted at the beginning of this year and am now the sole DBA at my company looking after 5 SQL Server...

You may want to look at column store indexes or just buying more drive space as an alternative.

That shrink file command is probably being blocked (and fragmenting your...

What do your wait types look like?

Is the workstation configured to use all this extra ram? With the increase in procs are you running into paralllism contention with the...

Between partially contained databases and being able to create your own server roles in 2012 I'd imagine you could do what you're asking.

Though you'll want to have someone somewhere with...