Viewing 15 posts - 31 through 45 (of 219 total)
eelliott 75257 (8/23/2011)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 15, 2011 at 3:15 pm
I hope you have off-site tapes. The scenerio you described will not result in recovery
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 10, 2011 at 6:24 am
Backup Compression is in Standard Edition with R2
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 9, 2011 at 10:58 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 in Microsoft...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
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);...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 9, 2011 at 8:46 am
Viewing 15 posts - 31 through 45 (of 219 total)