Viewing 15 posts - 1,111 through 1,125 (of 2,497 total)
We have active instances on each node of a two-node cluster, but for us they are both EE. One node has our main publisher DBs and the other node...
December 23, 2009 at 3:55 am
The cluster index will help you manage free space far batter than you can at present, and having a CI may also improve your performance.
There is no way an outsider...
December 18, 2009 at 8:52 am
There are a few SQL experts and some PSS engineers who suggest setting the pagefile to zero on a 64-bit box that has memory in double-digit GBs. The rationale...
December 18, 2009 at 5:54 am
Even if you uninstall CU6, you may not get rid of all traces of it. Many CUs update the system tables, and I doubt the uninstall will always be...
December 18, 2009 at 3:31 am
Not all database systems support the concept of a cluster index. Therefore if you have a 3-party app that was written to work on a number of database systems,...
December 18, 2009 at 3:20 am
In 64-bit Windows, SQL Server thinks the total amount of memory available is the total of the physical memory plus the size of the page file. Therefore if you...
December 18, 2009 at 3:05 am
There are many cheap NAS boxes available, but all that I have seen appear as a network drive to Windows. This means they are no use for testing clustering.
One...
December 16, 2009 at 9:33 am
Let's assume this becomes the standard way of living in 'developed' countries.
There is no way your life log could not be hacked, either by government or by criminals....
December 14, 2009 at 5:43 am
GilaMonster (11/25/2009)
roelofsleroux (11/25/2009)
Gila you sound like Doomsday Prophet. This is South Africa.Jy ook? So baie mense van Suid-Afrika op hierdie forums.
Hahahahaha I was laughing waiting to see Gail's reply!
November 26, 2009 at 3:15 am
You can get SQL Agent on SQL 2008 Express Edition to start. You need to set up account rights and enable the agent XPs.
But as soon as it...
November 26, 2009 at 3:04 am
We have had a number of questions which included a deliberate spelling error that had an answer xxx is wrong because it does not exist. As far as I...
November 26, 2009 at 3:01 am
Did you check the memory use when you are running backups and other batch processes? You need to set your max memory use to take these into account.
If you...
November 25, 2009 at 9:32 am
One of the fundamental design criteria behind the ODBC standard is the ability to run ad-hoc queries. In order to do this, the ODBC driver needs to access certain...
November 25, 2009 at 4:47 am
I have experienced similar problems when memory has been under perssure.
The OP said they have a 16GB box with 13GB allocated to SQL Server. This may be OK in...
November 25, 2009 at 4:30 am
I misunderstood what you wanted to do. I'll try to think of a way to hide the system tables.
November 24, 2009 at 4:24 am
Viewing 15 posts - 1,111 through 1,125 (of 2,497 total)