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...

bitbucket-25253 (7/7/2011)

---

The source cited has the following statement:

But, as it always is, how does one determine the number of soft NUMA nodes? ...

I'll stick it in the back of my mind and see if we can better group these together. Maybe a forum with all BI topics and then sub topics for...

Maintenance plans have worked for me in the past, but I like Ola's script as a more flexible solution.