sqlbuddy123 (1/20/2011)

---

Also Is there any specific reason to use Max Degree of Parallelism of 4 ?

...

SanDroid (1/20/2011)

---

Your total PageFile<s> should always be 3% larger than your total physical memory. It can be on more than one disk, but it needs to be the same,...

SanDroid (1/20/2011)

---

Can you post the return of the "SELECT @@version" command

Also please post "exec sp_configure".

If you could also tell us the size of the Page file, #CPU's, size of system...

SanDroid (1/20/2011)

---

One thing that is ofter overlooked is the CPU has to maps and control memory addressing. More System memory = more time the CPU needs to work it. ...

sqlbuddy123 (1/19/2011)

---

1. Because VAS is assigned by the OS to the applications and then is mapped to the available physical memory or the page file. You are restriction the extent...

Gila,

I am interested to know how you came up with the 56GB that you state above.

Thanks,

Fraggle

AWESOME!!!!!!

Thanks for the link.

Fraggle.

I would prefer not to simply because we will be renaming the server to DBTest in the next month. I would need to alter all of the security rights...

Steve,

Thanks. I was leaning that way and it does correct the issue. However, my reporting server breaks. 🙁

I don't suppose there is a way around this until...

GSquared,

Thanks for the input. Sadly, a CLR is not an option, even if I did know how to write one. Thanks for the note on the update and the...

This would be easier for everyone if you actually posted an example of the code that you are using to see why you might not be getting the ALTER LOGIN...

Figured out the issue. Someone hacked into the server, change the default language, did something, and then changed it back to the default. Now I have other fun...

learningforearning (9/22/2010)

---

i just tried to replicate this but i am not able to see any problem.

What I did :-

1) table create as order with startdate and enddate as 2 columns(both...

Mike Menser (9/22/2010)

---

The actual code would be a huge help. The dates for the where clause -- are they hard coded, or are they passed in from an external source...

Jack Corbett (9/22/2010)

---

What does SELECT @@LANGUAGE return? Date Formats are set based on the server's language setting.

Can you share the actual offending code? The table definitions would help...