Remember that a NULL is not "stored" per se. It is the lack of a value. As far as I can tell, a column uses a bit to...

SQLKnowItAll (4/4/2012)

---

I think the point is, from my perspective, that with the usage of this server you are more likely to have a motherboard issue than a HDD error. The...

I think the point is, from my perspective, that with the usage of this server you are more likely to have a motherboard issue than a HDD error. The disks...

Ok, my first thought is that a mirrored server is better than the mirrored drives terms of fault tolerance. We had ours set up that way, and when we...

Geoff A (4/4/2012)

---

SQLKnowItAll (4/4/2012)

---

Geoff A (4/4/2012)

---

RAID 0+1 is still the best choice, regardless of anything else.

You would need 20 years of finacial data for 10,000 customers before you even got...

Glad to help!

Geoff A (4/4/2012)

---

RAID 0+1 is still the best choice, regardless of anything else.

You would need 20 years of finacial data for 10,000 customers before you even got close to using...

Yeah, but may not be necessary for GP. Again, if you only have 2 or 3 people accessing it you will not have a large load. So, in that case...

You do realize that you need a separate license for this? If someone tells you that you don't, they are wrong (past experience). I take this as step 1.

I used to administer GP at my previous company. How many users do you have on GP and how many use it concurrently? Most cases, GP does not need...

danielgostrer (4/3/2012)

---

Hey All,

I am using openquery to run a MySQL stored procedure that writes to a table in the MySQL db. The issue that is happening is that this store...

It is because you are still referencing the view in Database1 by fully qualifying it. If you want the USE keyword to do anything, you have to change Database1.sys.database_files to...

In addition to that, only change the service accounts using SQL Server Confiduration Manager. If you change it through the services.msc window, you will create problems.

Ok, so now can you tell me what the problem is? Which values are not correct?

Won't be the last time it happens to you or me 😀 Sometimes second quick pair of eyes (or brain) gets the job done!