Felicia Coons (4/17/2012)

---

I'm attempting to develop a scale out plan for existing SQL Servers. Current configuration is irrelevant--let's just say I was thrown a garbled mess and tasked with "fixing"...

Nope, I wasn't involved in the consuption of the reference cursors. All I did was provide the other...

Nothing like stating the...

Rank1_nj (4/17/2012)

---

This is the create table queries: CREATE TABLE [dbo].[MainMaster](

[User] [int] NOT NULL,

[ID] [int] NOT NULL,

[Price] [money] NULL,

PRIMARY KEY CLUSTERED

(

[User] ASC,

[ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

CREATE...

What about the table from which the data is being selected, Channels2? Would help to see its definition as well.

Felicia Coons (4/17/2012)

---

Traditional load balancing can't be done on servers with SQL Server (data gets out of sync as soon as a write is made to one of them). However,...

Be very careful dropping indexes. An index you drop may not appear to be used but it may be critical to a process or report that is run infrequently...

Already suggested that and was told no, it wasn't a running total. ...

Simple answer, it depends. It depends on the activity...

First, be sure to disable autoshrink.

Second, your autogrowth settings should be set to a fixed amount not a percentage. Also, don't rely on it. Set your databases to...

Jan Van der Eecken (4/17/2012)

---

How about

SELECT *

FROM

(

VALUES

( 0, NULL ),

( 2.78,...

If you aren't getting the answers you need, it is because you haven't given us what we need to best answer your question. Please provide the DDL (CREATE TABLE...

Haven't had to do this, when I wrote SQL Code for Oracle, I returned the reference cursors, others had to deal with the information.

What I can tell you is that...

In addition to the information requested by Sean, please post the code for all functions used in your queries.

Please post DDL (CREATE TABLE statement) for the table(s) involved, sample data (series of INSERT INTO statements) for the table(s), sample updates to be used to update appropriate tables, expected...