Jeff Moden

Forum Replies Created

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

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
RE: Expected salary for DBA with 3 years exp.

SKYBVI (12/21/2010)
Does education (bachelor's or master's) also influence the pay in case of SQL server DBA ??
Regards,
Sushant
I've not seen it to be so. I will say that some companies...
--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:04 am

#1265604
RE: Fastest way to move a database from 32bit to 64bit server

DKlein (12/21/2010)
Jeff, what would you suggest for a small company?
That, of course, depends on the budget. Raid 5 certainly helps protect the data but is a slower compared 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 22, 2010 at 9:57 am

#1265600
RE: Fastest way to move a database from 32bit to 64bit server

Sjeef (12/21/2010)
Now would be a good time to get away from Raid 5 if you can.
Hi Jeff,
Is Raid 1 more preferred for database files over Raid 5.?
I know raid 5...
--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 9:54 am

#1265599

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