I am working on a database that usually uses GUIDs as primary keys. By default SQL Server places a clustered index on primary key columns. I understand that this is a silly idea for GUID columns, and that non-clustered indexes are better. What do you think - should I get rid of all the clustered indexes and replace them with non-cluste...
Hello everyone, 1st post on stackoverflow, hope to have great feedback :) I'm currently trying to load balance our web site. We have set up a 2 cluster NLB on windows server 2003 with IIS 6. While testing the setup, I found that sometimes, our session is lost. A day and a half later, here's the result: Yes, our machine.config both ha...
Hi all, we have just experienced a weird error on our applications connecting to a clustered Sql Server 2000: both our .NET applications (ADO.NET) and C++ (ADO) application get an error which we cannot explain. All the applications can connect to the database, can read data from it but cannot write data on it, receiving a "Generic networ...
Hi I have a web application running in cluster mode with a load balancer. It consists in two tomcats (T1, and T2) addressing only one DB. T2 is nfs mounted to T1. This is the only dofference between both nodes. I have a java method generating some files. If the request runs on T1 there is no problem but if the request is running on node...
Ok, here is the background. We have a clustered environment setup for running our coldfusion server, it basically split into two different instances, that the generic address redirects requests to. I have my app setup to send me emails whenever an error is caught by a user. Over the last week or so, I have had cases, where I have receiv...
I've heard these two terms quite many times, but always confused. My guess: for distributed servers,each server has its own unique data to serve for clustered servers,each server is supposed to have the same data given enough time to synchronize Is that the difference? ...
I have a Websphere topology wherein in Cluster1, I have an MDB that's trying to publish to another MDB that resides in Cluster2. Since they're both in the same container, I tried simply Blockquote Context ctx = new InitialContext(); ctx.lookup("jms/MyQueue"); Blockquote The "jms/MyQueue" is configured in Cluster2. As you can...
Hi. I'm trying to define a property that is not the id as a clustered index in nhibernate, yet I've found no way of doing this. Could anyone give me a pointer of how this is done, or it is something not currently available in nhibernate? Thanks in advance ...
How can we ensure that there is a single instance of a class in a clustered environment? The class is Serializable. ...
i have the following key: ALTER TABLE dbo.Table ADD CONSTRAINT PK_ID PRIMARY KEY CLUSTERED ( ID ASC ) so i have clustered index and primary key on ID column. Now i need to drop clustered index (i want to create new clustered index on another column), but retain primary key. Is it possible? ...
Hi all I am trying to eak out a bit extra performance from some sql queries which have a where clause on a field which is a non-unique non-clustered index, it is also a foreign key in table A. That foreign key is the primary key on table B and is the clustered index. What I'm wondering is, will I get a performance gain if I add a join ...