Viewing 15 posts - 1,666 through 1,680 (of 2,496 total)
The approach to clustering is different between SQL Server and DB2.
As most SQL people know, SQL Server will always physically insert a new row in the correct place in a...
April 16, 2008 at 3:37 am
The description I gave about MDC was very simplified. If you want more details then you have to search the DB2 documentation.
Believe me, MDC does what it says on...
April 15, 2008 at 9:21 am
I really don't see any way to have multiple clustered indices without storing multiple copies of the data, as it's not clustered unless it's physically stored in that order.
In DB2,...
April 15, 2008 at 7:44 am
You get this message when the database files are closed.
Having AUTOCLOSE on is the commonest way that database files get closed, but there are others...
ALTER DATABASE xxx SET OFFLINE
ALTER...
April 15, 2008 at 5:59 am
The OP said there was plenty of memory on the box.
Remember that with 32-bit SQL Server, the ONLY thing that can use memory above the 4GB line is...
April 15, 2008 at 5:49 am
A clustered index physically stores the data in the sequence given in the index definition. The way this is implemented in SQL Server means you can only have 1...
April 15, 2008 at 5:39 am
They exist, but you do not have to adjust them. Changes to these are only needed if you have specific requirements that could be met by using affinity masks.
April 14, 2008 at 8:22 am
There are a few threads on this forum that have focussed on the differences between 32-bit and 64-bit SQL Server 2005. Most people would not hit any issues, but...
April 14, 2008 at 3:40 am
If the only thing running on your box is the OS and SQL server, than setting max memory to 62 GB might just work, sometimes.
If you run anything else (anti-virus,...
April 14, 2008 at 2:36 am
I would say that 2 hours to uninstall and reinstall SQL 2005 is good! I find that the uninstall can easily take 40 minutes, and the install along with...
April 11, 2008 at 3:19 am
If you aer re-installing to the same folders, there is no need to delete them between the uninstall and the new install.
You should not restore any other system databases apart...
April 11, 2008 at 3:01 am
Windows want to use more memory than it has available.
As Chirag says, check what is happening in SQL Server. SQL should adjust its memory use to avoid excessive paging,...
April 11, 2008 at 2:56 am
In 32-bit mode, SQL Server 2005 SE can use AWE along with Windows /PAE switch to use memory above the 4 GB line.
Only the buffer cache can use memory above...
April 11, 2008 at 2:41 am
SqlServerFineBuild is free, but you can make a contribution (it goes direct to charity) if you wish.
April 9, 2008 at 9:58 am
There are 2 issues - SQL table & index fragmentation, and NTFS disk fragmentation.
To reduce the size of your database, I would look at a) delete the unwanted data, b)...
April 9, 2008 at 3:28 am
Viewing 15 posts - 1,666 through 1,680 (of 2,496 total)