Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,596 through 35,610 (of 59,102 total)

RE: Lost New Line Character Error Described

dbuendiab (11/9/2010)
(Already posted in General 2K5 Forum, posted again here - maybe more adequate place)
I've been near to send a post to the world on this issue I've been fighting...
--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)

December 24, 2010 at 12:00 pm

#1266238
RE: Jump to 2008 or stick with 2005 (partially done)?

As you said, either way you still end up preping for and taking two exams. Why not take the latest and greatest?
--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)

December 24, 2010 at 11:52 am

#1266237
RE: How to do UNPIVOT with dynamic column names within a FUNCTION

nemesis52 (12/23/2010)
Hi Jeff,
Because there is just one admin who has permission and is responsible to enter basic definitions like antibiotics, I am not really worry about the issue you mentioned.
Thanks...
--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)

December 23, 2010 at 8:42 pm

#1266120
RE: Time Worked in 15 minute increments

Lowell (12/23/2010)
this seems to give me the results i was looking for, it's rather dawn out into CTE's to show all the logic and can be easily shortened up, 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)

December 23, 2010 at 8:21 pm

#1266117
RE: Partitioned Indexes

mitch.fh (12/23/2010)
So Many Hits no answer... Is that a Problem that no One has or no One knows an answer to? :w00t:
I think people may be waiting for you 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)

December 23, 2010 at 7:21 pm

#1266111
RE: Help writing query logic

stevenplee (12/23/2010)
Thanks, For your response. What does the ":with cte AS" statement do?
A whole lot. Take a look at "WITH common_table_expression" in Books Online... there's just...
--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)

December 23, 2010 at 6:43 pm

#1266107
RE: Cursor delete faster

Roger Sabin (12/23/2010)
There are no triggers on the table.
I did not time the actual deletes but when 10 single deletes finish quickly and a single delete for 10 rows does...
--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)

December 23, 2010 at 5:53 pm

#1266102
RE: CLR Assemblies

Tom.Thomson (12/23/2010)
David Burrows (7/4/2008)
"If you don't write the bloody things, you don't have to worry about stuff like this!"
ever the cynic eh Jeff 😎
Nah, not a cynic. Just sensibly...
--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)

December 23, 2010 at 5:42 pm

#1266101
RE: How to do UNPIVOT with dynamic column names within a FUNCTION

nemesis52 (12/23/2010)
I solved my problem in another way. I put the function creation sentence inside a dynamic query and each time user define a new antibiotic, the function will be...
--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)

December 23, 2010 at 5:40 pm

#1266099
RE: Estimating table size - problems with MS fromulas

The only thing you can do without additional information is to find the "total cost" in bytes per row using (DataSize+IndexSize)/Rows.
The next step would be to look at the 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)

December 23, 2010 at 7:09 am

#1265918
RE: How to do UNPIVOT with dynamic column names within a FUNCTION

nemesis52 (12/22/2010)
The problem is, my column list should be dynamic
I have to ask "Why"? Do you have so many tables to unpivot that you need dynamic SQL?
I think we...
--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)

December 23, 2010 at 1:01 am

#1265802
RE: Cursor delete faster

Roger Sabin (12/21/2010)
I tried deleting just 10 records directly as follows:
delete from tblDocument where DocumentID in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
The delete ran for over...
--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)

December 23, 2010 at 12:58 am

#1265801
RE: WHERE...IN vs JOIN

Mad Myche (12/22/2010)
The code you have in this thread is averaging 210ms. NS was not a DateDiff option in Sql2000 and it does not appear to have been in 2005...
--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)

December 22, 2010 at 10:30 pm

#1265774
RE: SSIS - ForEach From Variable Enumerator

willtwc (12/22/2010)
Use ADO instead.
Why?:blink:
--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)

December 22, 2010 at 10:27 pm

#1265773
RE: GetDate() or CURRENT_TIMESTAMP

vinothraj (12/22/2010)
Jeff Moden (12/22/2010)
Which code did you use for that test? If the answer is that you used the same code that you used before, the reason why 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)

December 22, 2010 at 10:26 pm

#1265772

Viewing 15 posts - 35,596 through 35,610 (of 59,102 total)