Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,521 through 47,535 (of 59,099 total)

RE: Using Datepart

If you'd always like it to return Jan - Mar of the CURRENT year, then you don't even need to know what the current year is...
SELECT ID
...
--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)

October 29, 2008 at 7:57 pm

#891572
RE: using CLR assembly

evaleah (10/29/2008)
Sorry about the missing information.
I deployed it to SQL 2005 and it appears in the Assembly area. The routine creates an iCalendar formatted email message and then sends...
--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)

October 29, 2008 at 7:44 pm

#891571
RE: SELECT DISTINCT returns random duplicate rows

Why? Try this and see why I ask... ask yourself "What is 1 divided by 3 times 3?" 😛
DECLARE @A DECIMAL(3,0), @b-2 DECIMAL(18,0),@F FLOAT
SET @A = 3
SET...
--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)

October 29, 2008 at 7:30 pm

#891567
RE: Segmentation fault in tempdb

Is the "autoshrink" option turned on on TempDB??? If so, it must be turned off!.
Also, you need to figure out what the largest it will grow to, add 20 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)

October 29, 2008 at 7:23 pm

#891564
RE: using CLR assembly

Better than that, tell us what the CLR is supposed to do so we can try to show you how to do it without a CLR... there's usually a way......
--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)

October 29, 2008 at 7:15 pm

#891561
RE: How to print null when no sales is present

Heh... try this...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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)

October 29, 2008 at 7:12 pm

#891560
RE: Ok, its their first day on the job.

Heh... I've been doing SQL for almost 13 years... at least he used books... I still write the answers on my shirt sleeve. 😛
Nah... seriously... breaking out the books...
--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)

October 29, 2008 at 7:09 pm

#891559
RE: Tempdb

Don't ever turn autoshrink on for TempDB... talk about fragmentation!
Check the log file (LDF) for TempDB... is that what's actually full?
--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)

October 29, 2008 at 6:54 pm

#891558
RE: Returning most recent date?

That is, of course, if you don't have the time in a separate column... let us know.
--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)

October 29, 2008 at 6:51 pm

#891557
RE: Returning most recent date?

If it's trully a DateTime column, then MAX will flush out the one with the latest time "auto-magically".
--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)

October 29, 2008 at 6:50 pm

#891556
RE: SQL-Server 2005: Change Ordinal Column Position

RML51 (10/29/2008)
Timely discussion.
I'm arguing with one of our VisualStudio/.NET developers about column order in tables. He's asking us to move columns around so they appear where he wants to see...
--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)

October 29, 2008 at 6:37 pm

#891555
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Damn! That's two times I missed the intended humor... ok... I'm going to my room to suck my thumb and twiddle my hair. 😛
--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)

October 29, 2008 at 6:23 pm

#891554
RE: Need help on performance and integrity

AnzioBake (10/29/2008)
I tested the Solutions against the Test dat set that I created. The Table Contained 1 Million records with sequences ranging from 1-35 rows.
My Solution returned 670000+ Rows...
--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)

October 29, 2008 at 6:31 am

#891154
RE: Need help on performance and integrity

AnzioBake (10/29/2008)
hi Steve (SMunson)
To Test your Solution, I ran mine again as I made some changes. Execution time was 5 min 36 sec
I added a print statement after ...
--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)

October 29, 2008 at 6:02 am

#891136
RE: I/O Bound

Just a comment... my experience has been that even monster batch systems don't need parallelism in most cases if the code is well written and the correct indexes are in...
--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)

October 29, 2008 at 5:57 am

#891135

Viewing 15 posts - 47,521 through 47,535 (of 59,099 total)