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.

Create the login, then the user. I would set the login default database to the one in which you create the user. The login will have connect rights.

Then grant your...

ditto. Just saw that come through.

Thanks, I think that was a forum post, so it's hard to screen those out, but I'll see what we can do.

First you need to connect locally as an administrator. Local Windows admins usually have default rights, or the account that installed Express.

to add other accounts, use CREATE LOGIN: http://msdn.microsoft.com/en-us/library/ms189751.aspx

Most books have some practice questions in there, but publishing any of the exam questions or very similar ones is a violation of the NDA.

My advice is to go...