Very well said! I agree but unfortunately we live in a world were stock holders need to make even more money. Technology (including DB systems) are actually driven by how...

Thanks for your reply Matt. Neat we to store and search

Rudy 🙂

Hmm, I seem to be getting errors when executing the code.

Msg 207, Level 16, State 1, Line 2

Invalid column name 'object_id'.

Msg 102, Level 15, State 1, Procedure sp_common_server_problems, Line 31

Incorrect...

Thanks for your comments. I am in the process of performing real time monitoring on the current 5 SQL servers and will calculate the max I/O, data through put, memory...

These sql servers are currently on a 32bit environment, but the consolidated server is completely 64 bit and connected to a HP SAN (I forgot to mention that).

Since SQL...

No Oracle background here. What we are thinking of doing is putting 5 SQL servers on to one large server. We have an HP585 with 8 cpu and 64gigs or...

Ok, I see. So that means that when setting memory setting for an instance, you set the values for that instance and not for the OS. What I'm trying to...

You say set the min and max to the same value, can you explain this a little more?

Are you saying that on a 30gig of RAM on a server,...

Thanks for the great information but not what I need. I guess I'm not explaining myself. Let see, Ok. I want to create a report like below

User/Login Name DB...

Has anyone just disabled the Buitlin\Administrators account? That way you can test and if something breaks you can enable it and correct the issue. And if nothing is broken you...

Hello Everyone,

Just looked at the article and see that some people want to execute DBCC commands on a remote server. I not sure you want to do this as it...

Hey DatabaseWorkBench is not free. I think we are looking for free tools, but not bad product for the price.

The product will show the version number. Nothing will tell you if it's registered to you

or you company

SQLRecon - see my earlier post It will display the versions of sql it found on your network

If only there was a tool like Enterprise Manager or SSIS for linux (no. not in a vmware setting) then DBA's could switch to linux easily.

Quest's Toad for SQL Server...