Viewing 15 posts - 31 through 45 (of 218 total)
eelliott 75257 (8/23/2011)
August 23, 2011 at 8:31 am
Express12 (8/23/2011)
I need to indicate our SQL Servers running on VM's and non-VM's. (for both Windows Server 2008 and 2003)How can I make this determination?
Do you need to know...
August 23, 2011 at 7:52 am
ChrisP-374390 (8/22/2011)
The results could depend on the existence of database test2...
My fault for answering and assuming that test2 did not exist. Apparently it did exist in this question.
August 23, 2011 at 5:58 am
This sometime happens when copyine scripts off SSC, I've had it happen several times. The whitespace leading a line gets converted to control characters. Reply back with your...
August 15, 2011 at 3:15 pm
I hope you have off-site tapes. The scenerio you described will not result in recovery
August 10, 2011 at 1:13 pm
I've worked at a company where a 15TB OLTP database was originally designed in access, ported to SQL7, then upgraded to 2000, 2005. You can really tell from the...
August 10, 2011 at 6:51 am
This sounds like it's pretty vendor specific, I don't know the app, so I won't speculate on what's wrong.
As for performance:
Add RAM
Add Disks
Get faster disks
Add CPU's
Stop unnecvessary services
Migrate other DB's...
August 10, 2011 at 6:47 am
We designate preferred owners
Everything is preferred to be owned by ist's active node, the secondary owners are passive nodes. We try to keep the heaviest db's form being on...
August 10, 2011 at 6:37 am
I have done up to A/A/A/A/A/P/P, though bost common is A/A/P
They save a significan amount of money versus just A/P.
And if you look at it statistically, it's unlikely that multiple...
August 10, 2011 at 6:32 am
A virtual name for sql
A Virtual name for the cluster
A Node name for node 1
A node Name for node 2
A heartbeat connection
Probably two public connections per server (for further redundancy)
A...
August 10, 2011 at 6:29 am
Why are you using replication? Is this for DR, or something like reporting?
Much less complex (to the user) than replication is mirroring and log-shipping.
You mentioned that the database is...
August 10, 2011 at 6:24 am
I stand somewhat corrected, according to Mastering SQL Server 2008, page 508
"...significantly departed from their traditional cursor-based data access technologies of the past. For the first time...
August 9, 2011 at 9:26 am
RonKyle (8/9/2011)
I'm not sure is access is even technically a RDBMS on the back end.
Gregory F, that's a bold statement without providing a framework as to what you might mean...
August 9, 2011 at 9:16 am
Having lived there, that does not surprise me. However, in major IT centers, from the emails I get for recruitrers, Access jobs pay in the range of $30/hour (1099);...
August 9, 2011 at 8:46 am
Viewing 15 posts - 31 through 45 (of 218 total)