Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,026 through 8,040 (of 59,072 total)

Reply To: T-SQL Query Help

I also suspect that you want this to be conditional to check if there already is a "First Try" or not and add the extra row if there isn't. I...
--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 27, 2019 at 4:32 pm

#3710786
Reply To: importing text file, bulk insert to populate table

Jeff Moden wrote:
@smattiko83,
Do you also want the dates to be validated as "real" dates?
I'm asking this question because the translations you ask for are fairly trivial and I'm trying to generate...
--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 27, 2019 at 4:23 pm

#3710784
Reply To: how to increase batch size to 100000

If you're generating individual INSERT/VALUES statements, I wouldn't do that because it will take a month of Sundays to complete 1 million rows. In fact, most methods will not 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 27, 2019 at 4:18 pm

#3710783
Reply To: how to force a procedure to execute the first ?

If order of execution is important for 1 procedure, it's likely inevitable that order of execution will be come a necessity for others, as well. My recommendation is to build...
--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 27, 2019 at 4:02 pm

#3710780
Reply To: The Best DBA Gifts

As to the question of what I'd like from work, the answer is for things to NOT change. I'm one of the fortunate few in the world when it comes...
--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 27, 2019 at 3:47 pm

#3710778
Reply To: The Best DBA Gifts

skeleton567 wrote:
My best gift is another year with my wife of 40 years whom twice doctors gave up for lost, but who has survived and overcome bilateral below-knee amputation 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 27, 2019 at 3:40 pm

#3710776
Reply To: Meaning of WHERE x NOT LIKE '% %'

Unfortunately, I've seen that and more. I've even seen people add trailing spaces to all of their object names to make it more difficult to use what they've built. Crazy...
--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 27, 2019 at 3:34 pm

#3710774
Reply To: Why columnstore indexes are not very popular?

Sergiy wrote:
I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages of splitting datetime into date and time.
That's very true. And, sorry...
--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 27, 2019 at 3:27 pm

#3710769
Reply To: Why columnstore indexes are not very popular?

Grant Fritchey wrote:
Sergiy wrote:
Frederico, do you have any test case to support your speculations?
I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages...
--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 27, 2019 at 3:23 pm

#3710767
Reply To: Meaning of WHERE x NOT LIKE '% %'

I've not executed the code but it looks to me like they're trying to reject rows where the name has any spaces.
--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 27, 2019 at 12:03 am

#3710621
Reply To: importing text file, bulk insert to populate table

@smattiko83,
Do you also want the dates to be validated as "real" dates?
--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 26, 2019 at 11:57 pm

#3710620
Reply To: importing text file, bulk insert to populate table

smattiko83 wrote:
I have to import a text file to build a table and all of the date fields currently are in integer form. It comes in three different ways. 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)

December 26, 2019 at 3:14 pm

#3710543
Reply To: High Page File Usage

Good lord!!! A SQL forum that doesn't allow you to upload .SQL or TXT files! This is just silly.
Here's sp_ShowWorst... I've got to figure out how to do the other...
--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 26, 2019 at 2:45 pm

#3710540
Reply To: High Page File Usage

Brahmanand Shukla wrote:
Max Memory capping is applied on the instance.
Total Available Memory : 32 GB
Max Memory configured : 26 GB
Brahmanand Shukla wrote:
As far as I know, nothing additional running on the instance,...
--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 26, 2019 at 2:43 pm

#3710538
Reply To: What is going on with my rebuilding index job?

Man... I'm sorry. I lost track of this thread and didn't answer your additional questions.
I guess my biggest question would be, did you stop using REORGANIZE or not?
--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 25, 2019 at 8:50 pm

#3710358

Viewing 15 posts - 8,026 through 8,040 (of 59,072 total)