Just to be clear, you are seeing a SQL backup in msdb..backuphistory from VMWare and there aren't any jobs setup?

It's certainly possible, and I would agree with CarpenterBob that you...

A couple of things to look at then.

RTO: What's the time to restore in a disaster, and what does that mean for lost work/productivity or sales. Put numbers to it...

If you run this in SQL Server, what happens?

select distinct Region

from RegionTable

Use your own field/table names.

I'm not sure I understand. Are you striping the backup across 7 files to one Data Domain device? Is that a single array/LUN/drive?

The speed in backup comes from multiple physical...

Possibly something with SQL, but I wouldn't think so if other clients can connect. Unless it's a shared DLL somewhere.

It could be OS related, but it's definitely some call in...

Enjoy, Ray.

Looks like my first game will be Aug. My wife is planning a team builder with her company for the Rockies/Dodgers.

If SQL is not case sensitive, you ought to be getting back just one row there. What query are you running, or how are you doing this. If Crystal is...

I'd run a trace to see where it hangs, but it almost sounds like a corrupt client tools issue. I might reinstall just the client tools

RAND - http://msdn.microsoft.com/en-us/library/ms177610.aspx

CHECKSUM - http://msdn.microsoft.com/en-us/library/ms189788.aspx

NEWID - http://msdn.microsoft.com/en-us/library/ms190348.aspx

The table, or database, must have a case-sensitive collation if this is what you get. As SQLRNNR mentioned, this should help:

SELECT UPPER(region)

, count(sales)

from MyTable

group by UPPER(region)

http://msdn.microsoft.com/en-us/library/ms180055.aspx

We have two e-books here that can help you learn more about this topic:

Inside the SQL Server Query Optimizer - http://www.sqlservercentral.com/articles/books/71564

SQL Server Execution Plans - http://www.sqlservercentral.com/articles/books/65831

Please check the error logs. It's possible you have pathing wrong somewhere, or there is some error being thrown from the services.

That's the job history, not the MP history.

I'd make sure your plan is set to generate a log. Usually these are in the SQL folders in \LOG, so check them...

The page faults on the server shouldn't matter to SSMS since it's a client program connecting the same as it would from another server.

Are you connecting with the same protocols...

LOL. Nice dinner story.

No great significance to this number, but since this thread popped up today, 3,000 is on my mind. I've been a Yankees fan my whole life and...