Jeff Moden

Forum Replies Created

Viewing 15 posts - 58,756 through 58,770 (of 59,076 total)

RE: SET DATE TO 90 DAYS AGO

Don't forget that just subtracting 90 days using either method will not take you to midnight of the given day... the current time element will be included unless you 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)

May 11, 2005 at 10:49 pm

#558257
RE: Finding no of weekend days between two dates

This'll work if you have a DBA that doesn't understand the merits of a date table and it's short enough to use in inline code if the...
--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)

May 11, 2005 at 10:36 pm

#558256
RE: Safety of Using sp_OA

Hopefully, SP4 will fix some of the memory leaks. It came out this last Friday.
The problem in our shop used to be that no-one did a code review of other's...
--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)

May 9, 2005 at 6:26 am

#557565
RE: Filegroup full (NOT what you''''re thinking)

I second Carl's suggestion about turning AutoShrink off... AutoShrink causes several problems not the least of which can be severe disk fragmentation and long wait times when it does need...
--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)

May 9, 2005 at 6:15 am

#557562
RE: connecting oracle database from sql server 2000 trigger
```
 
```
I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server...
--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)
May 9, 2005 at 6:06 am

#557561
RE: connecting oracle database from sql server 2000 trigger

I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server processes will start kicking off...
--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)

May 9, 2005 at 5:56 am

#557560
RE: Is there another way for this??

I believe that it's called an "M-Space" and occupies the same width as the letter 'M", hence the name. Since it's not a regular space character (ASCII 32), you may...
--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)

May 8, 2005 at 10:18 pm

#557523
RE: why is the diference between a select and print output?

Here's a couple of other differences...
PRINT doesn't print those pesky column headers.
PRINT outputs to the MESSAGES tab even if the GRID mode is turned on. SELECT will print to the...
--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)

May 7, 2005 at 9:15 pm

#557498
RE: updating without using Cursor

Ok, so you've shown what doesn't work... what, in your estimation, would work if you were given that particular problem (the Adam Mechanic one) with that particular data?
--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)

May 2, 2005 at 10:27 pm

#556440
RE: Column Naming Conventions (rears it''''s ugly head again :)

Michelle/Dolphin,
Thanks for the feedback on the medical community... I guess that's one place where the following saying (author unknown) applies...
"Normalize 'till it hurts,
DeNormalize 'till it works."
--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)

May 2, 2005 at 9:06 pm

#556438
RE: updating without using Cursor

>The proprietary syntax has unpredictable results.
Only in something other than the SQL it was written in. It is not upredictable in SQL Server.
>Notice that we did not use the...
--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)

May 2, 2005 at 8:55 pm

#556435
RE: Column Naming Conventions (rears it''''s ugly head again :)

>First option makes optimizer work faster
Sergiy,
Can you show me where this is written? The reason I ask is because I've got a bunch of folks at work that use...
--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)

May 2, 2005 at 6:39 am

#556263
RE: updating without using Cursor

Dang... I missed that. Sorry Shahed and thanks for the feedback. Glad you got it working...
--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)

May 2, 2005 at 6:32 am

#556259
RE: Column Naming Conventions (rears it''''s ugly head again :)

Roger that... thanks. I'm just the opposite... I leave the aliases just for brevity... I figure that it takes about 2 seconds to figure out that "c" means "Customer". But...
--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)

May 1, 2005 at 2:13 pm

#556191
RE: updating without using Cursor

Obviously, I haven't tested this but it should be real close.
UPDATE A
    SET Flag = 1
   FROM A,
        (--Derived table "bd" finds everything in B having a count...
--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)

May 1, 2005 at 9:35 am

#556173

Viewing 15 posts - 58,756 through 58,770 (of 59,076 total)