If you had to choose one, which would it be:

A) Pacer

B) Gremlin

C) walk

All of this:

The first INSERT statement moves about 800,000 rows from these tables. The second INSERT statement creates about 200,000 rows in the fact table by querying the fact table...

Suggest I do that a mirror said Troll should look.

Pharisee

DimDim (4/19/2010)

---

I create below as a job in MS SQL 2005:

Job Step = Operating System [CMDEXEC]

Run as = SQL Agent Service Account

COMMAND =

"sqlcmd -SABCDEF -E -d TEST -i L:\ALTERINDEX.sql...

Grant Fritchey (4/19/2010)

---

anthony_merriwether (4/19/2010)

---

Please do not resort to name calling. Seems that a few of you display your intellect in this way, which does not surprise me in the least....

dakshinamurthy-655138 (4/19/2010)

---

No,

my Pc or Laptop loginname is dakshina, where as i login to sql server using sa login and its password, the sql server may be either in my own...

Even if we make sure that they wear clean socks? 😛

dakshinamurthy-655138 (4/19/2010)

---

Hi,

i even tried that, i will ge the login used to connect to sql server, but i am required of the loginname used to connect to my PC...

anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of...

Curious. I execute select suser_sname() and it returns my username, not the name of my desktop system from which I have logged into the SQL Server instance.

CirquedeSQLeil (4/16/2010)

---

Anybody out there have SQL 2000 installed?

If so, can you verify for me if ANSI_NULLS is off in sp_who2 on your server?

I believe it would be since that is...

Jeff Moden (4/16/2010)

---

dma-669038 (4/16/2010)

---

Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best are those...

Based on your sampe data, how about this:

--DocID FieldName FieldValue

--1 Number 1000

--1 DocName Murphy.doc

--1 City Greenville

--2 Number 50

--2 DocName Biggs.doc

--2 City Null

create table #testtab (

DocID int,

...

DTA is a good tool, just take its recommendations with 2-ton grain of salt. You really need to test the recommendations that it makes to be sure that they...