Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,706 through 42,720 (of 59,102 total)

RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Grant Fritchey (7/30/2009)
Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:46 am

#1032485
RE: More Can Come From Less

Man, do I agree with that. I just turned down a huge offer from a company because they actually expected a 55 hour work week.
Managers and owners, wake up......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:43 am

#1032484
RE: Select into from huge table with indexes

I agree with Grant.... BCP out to a file at the source, BULK INSERT from the file to the destination. If you use the "NATIVE" option of BCP, it'll...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:39 am

#1032478
RE: Loading Data from Text file to SQL Server

Bulk Insert will work fine if the server can see a "share" on your local machine.
So far as the "0'/Null thing goes... load it into a staging table and change...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:36 am

#1032477
RE: Sql cursor is not returning data

You don't need a cursor for this. Use a simple two table join.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:32 am

#1032474
RE: Recursive CTE Vs Temp Table in Recursive User Defined Procedure

If the binary tree doesn't change very often (say, once a day), you can use a Nested Set model in parallel with your current Adjacency Model. Joe Celko has...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:31 am

#1032472
RE: Zero fill (Format) a field.

This type of formatting shouldn't be saved in a table anywhere. First, it converts INT to VARCHAR and VARCHAR lookups are more expensive than INT lookups. Second, it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:26 am

#1032465
RE: Database Design for Online Examination System

gochaithu (7/29/2009)
Hi friends,This is Chaithanya.
I have some doubt's in preparation of Online Exam database.My first doubt is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:21 am

#1032457
RE: how to Split DateTime value in seprate date and time column

GilaMonster (7/30/2009)
In all the SSAS recommendations I've read (and the ones I've made) the datetime is stored in the SQL table as a datetime, to whatever granularity the user wants...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 9:14 am

#1032448
RE: how to Split DateTime value in seprate date and time column

dan.hare (7/30/2009)
Agreed that this should be done in a view or calculated column.
One reason why one would want to split out date and time is to allow the use of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 6:35 am

#1032334
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/30/2009)
Is there a more detailed error message in this file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_JMODEN2_MSXML6_1.log?
Yep.... it's quite long so I'll post the only line in monster 421 line...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 12:53 am

#1032204
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Heh... ok... NOW I'm feeling more like an MVP! It took 8 bloody hours but I think I've got this problem licked. I'm in the middle of another...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 30, 2009 at 12:04 am

#1032182
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Yeppp that file exists.... I've tried a reinstall again since the #13 try worth of files I just listed...
Machine : JMODEN2...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 29, 2009 at 11:04 pm

#1032161
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Irwan Tjanterik (7/29/2009)
Hi Jeff
If u believe u have completely uninstall the SQL Server, you can try to delete the following folder completely C:\Program Files\Microsoft SQL Server.
Once u've delete the folder,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 29, 2009 at 10:24 pm

#1032149
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/29/2009)
Check the latest %SQL.log. From looking at the one in my directory, that is the log for installing the dtabase engine.
Sorry... I don't see any such file......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 29, 2009 at 10:21 pm

#1032148

Viewing 15 posts - 42,706 through 42,720 (of 59,102 total)