How many processors/cores? what is your istance's maxdop setting? What is the instance max memory setting?

Daxesh Patel (6/13/2012)

---

anthony.green (6/13/2012)

---

Daxesh Patel (6/13/2012)

---

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of...

I'm pretty sure that you can (although I may be wrong). What I do know is that you cannot partition a table on the second column of a clustered...

Evil Kraig F (6/12/2012)

---

SueTons (6/12/2012)

---

Hi, I know that deleting a row can cause fragmentation since it creates free space within a page, also inserting can cause fragmentation due to page...

jamie_collins (6/12/2012)

---

Sorry maybe I should have elaborated...

The actual table is 800 million + rows...

The example is just a made up table for simplicity...

I am curious as to how to get...

Looks like you are out of disk space...

jamie_collins (6/12/2012)

---

I have a table:

CREATE TABLE Orders

(OrderID INT IDENTITY(1,1) NOT NULL,

OrderDate DATETIME NOT NULL,

OrderFreight MONEY NULL,

ProductID INT NULL,

CONSTRAINT PK_Orders PRIMARY KEY CLUSTERED

(OrderID ASC, OrderDate ASC)

)

...

Express12 (6/12/2012)

---

I have a table:

id int

project_id int

primary bit

with several entries per project --

is there any way to set up a constraint that (project_id, primary) can only happen once when...

Marius.D (6/12/2012)

---

That's what I read - Microsoft recommends MaxDOP set to 2 for servers with 4-8 procs (ours has 4). The Cost Threshold set to 25 allows longer running queries...

Why is your server MAXDOP set to 2? Why is your threshold set to 25? I'm not saying that they shouldn't be... I'm asking if you know why they are...

RPC Serves no purpose...

http://msgroups.net/microsoft.public.sqlserver.server/rpc-vs-rpc-out-for-linked-s/98628

How are you changing the login for the service? I...

I wish that was true... I'm always confused, though less so since I have been on the...

Try this and also look up PIVOT and UNPIVOT T-SQL

SELECT department, name

INTO #temp

FROM

(SELECT department, name1, name2, name3, name4,...

Maybe this is what you are saying?

CREATE TABLE departments (Department char(20),

Name1 char(20),

Name2 char(20),

Name3 char(20),

Name4 char(20),

Name5 char(20),

Name6 char(20))

CREATE TABLE unpivot (Department char(20),

Name char(20))

INSERT INTO departments

SELECT 'Chemistry', 'Suzanne','Joe','Gertrude','Brett','Katie','Rebecca'

AND you want results to...