Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,676 through 42,690 (of 59,067 total)

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
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/29/2009)
Let's take this one step at a time. Looking at my system here at home the logs are in this directory: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.
Is this...
--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 9:32 pm

#1032130
RE: Query Help?

jason (7/29/2009)
b) have a dynamic, changing number of fields depending on the source data
See the following... http://www.sqlservercentral.com/articles/cross+tab/65048/
--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 4:35 pm

#1032067
RE: Recursive User Defined Procedure

bhavesh_183 (7/29/2009)
Finally I got it .... Thanks every one
Bhavesh
Got what? Please share your solution.
--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 4:31 pm

#1032064
RE: Altering column from varchar(2048) to varchar(max) performance

ALZDBA (7/29/2009)
altering to varchar(8000) is only a catalog operation (and maybe an index op if the column is indexed) because it stays the same datatype, only the var length changes....
--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 4:24 pm

#1032063
RE: Why cursors

I don't know why cursors where actually added to SQL back in version 6.5, but you can bet it was some market pressure by those who don't know how 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 29, 2009 at 4:09 pm

#1032059

Viewing 15 posts - 42,676 through 42,690 (of 59,067 total)