Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,921 through 49,935 (of 59,102 total)

RE: SQLSERVER 2000 auto rounding!

Nah... make it easy on yourself...
(IntegerConstant * IntegerColumn *1.0) / IntegerColumn = IntegerResult
--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)

June 18, 2008 at 3:28 pm

#830807
RE: count by another count

Ummm... take a look at the following subjects in Books Online...
ROLLUP operator
CUBE operator
GROUPING keyword
--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)

June 18, 2008 at 2:36 pm

#830769
RE: Need to relocate tempdb

The link that Kendal referred to has a full example of exactly how to do this along with certain explanations as to why you need to do (or not do)...
--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)

June 18, 2008 at 2:28 pm

#830759
RE: Unique column in 4 tables

Yep... a GUID would do it...
What do you want the unique column to look like and why? It may make a difference.
--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)

June 18, 2008 at 8:24 am

#830490
RE: datetime: 1245-03-05

Suresh B. (6/18/2008)
CLR Integration Data Types ?
Yeaup... and what would you have it do? Fact is, you still can't store out of range dates in the database.
If the front...
--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)

June 18, 2008 at 8:17 am

#830474
RE: Suggested Approaches Appreciated

Just curious... do you have any names like the following example?
Dr. and Mrs. J R van de Camp Rosenburg V MD. PHD. Esquire
--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)

June 18, 2008 at 8:07 am

#830461
RE: Parse delimited data in column to multiple columns

On my way to work... I'll try to take a whack at this tonight... but, the split must produce an "array" and then the array must be reassembled by...
--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)

June 18, 2008 at 7:48 am

#830433
RE: Virtual PM's for Jeff...

Easy to print? They contain CR/LF's... should print just fine if you display them in a text mode instead of a grid mode...
--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)

June 18, 2008 at 7:39 am

#830417
RE: performing a DIR command from a sproc without using XP_CmdShell

I agree... our DBA's have xp_CmdShell, sp_OA*, and a whole bunch of other "ad hoc" access turned off. But, they do allow it through stored procedures that are executed...
--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)

June 18, 2008 at 7:35 am

#830412
RE: PatIndex on varbinary Column

Thanks for sharing...
But that's still going to have the same problem as PatIndex... For example... if you're looking for the word "GUID" or the word "DEFAULT" in a word document,...
--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)

June 18, 2008 at 7:24 am

#830398
RE: SQLServer 2005 on VMWARE

AndyD (6/18/2008)
With VMware Infrastructure and VMware HA (High Availability), in many ways I am more comfortable running mission-critical apps in a VM than on a physical server.
How so?
--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)

June 18, 2008 at 7:17 am

#830388
RE: database tuning engine problem

Unfortunately... no... I don't. Sounds like you have everything you need to run it correctly.
--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)

June 18, 2008 at 7:16 am

#830384
RE: Theoretical question about importing from Excel using SSIS

GSquared (6/17/2008)
Matt Miller (6/17/2008)
I've done something like that with DTS a few times. For better or worse - I found it easier to have DTS handle the importing 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)

June 18, 2008 at 7:13 am

#830380
RE: Limitation fo AND's and OR's

karthikeyan (6/18/2008)
I have executed a query which has more number of ( around 500) string's in the IN clause. (All of us know IN will be treated internally as OR...
--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)

June 18, 2008 at 7:05 am

#830366
RE: Double Check

Syed (6/17/2008)
Also one problem with documentation (atleast places i have worked) is that initially documentation is created but after some time process is changed and no one updates the documentation....
--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)

June 18, 2008 at 6:59 am

#830362

Viewing 15 posts - 49,921 through 49,935 (of 59,102 total)