Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,351 through 16,365 (of 59,067 total)

RE: Big data: transfer x-number of rows per batch?

Sergiy (11/2/2016)
The fastest data transferring channel is a truck loaded with DVD's
:hehe:
Or an overnight care package with a monster hard disk in it. 😀 Did that when I was...
--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)

November 7, 2016 at 8:51 pm

#1911085
RE: How Do You Act When You Need to Learn New Technology?

xsevensinzx (11/7/2016)
What happens if someone tells you that you can do something cheaper and equally the same as SQL Server with another piece of tech? It's equally the performance, 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)

November 7, 2016 at 8:39 pm

#1911082
RE: How Do You Act When You Need to Learn New Technology?

Eric M Russell (11/7/2016)
The smarter managers, the ones who have a track record of delivering and cultivating the best teams, they have a basic mistrust of employees who act like...
--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)

November 7, 2016 at 9:33 am

#1910955
RE: How Do You Act When You Need to Learn New Technology?

xsevensinzx (11/7/2016)
This is sort of the thinking that turns away new ideas.
It's actually not. Go back and read what I wrote. I usually give every idea the chance...
--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)

November 7, 2016 at 9:20 am

#1910952
RE: How Do You Act When You Need to Learn New Technology?

Andrew..Peterson (11/7/2016)
Jeff Moden (11/6/2016)
To be honest, I'm starting to get really pissed off at people and their "new improved shinny bobbles". .........
Very true. I am sure that 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)

November 7, 2016 at 8:33 am

#1910938
RE: A Better sp_Spaceused

Eirikur Eiriksson (11/7/2016)
Jeff Moden (11/6/2016)
Geez... it would have been SOOOOOOOO simple for them to make the "improvement" so much more worthwhile. I don't know why they even bothered.
They had...
--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)

November 7, 2016 at 8:14 am

#1910929
RE: Management Studio hangs after query results

alfred.h.hernandez (11/7/2016)
What I find very wierd is that it didn't use to be like this...:(
Perhaps you have a memory chip that's gone bad, you've loaded something extra into memory that'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)

November 7, 2016 at 7:56 am

#1910926
RE: LOADING A PARTICULAR COLUMN FROM FLATFILE

What are the actual column names involved and what does a sample of the actual data look like? The reason I ask is that such a data configuration is...
--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)

November 7, 2016 at 7:48 am

#1910923
RE: TempDB growth due to version store on AlwaysOn secondary server

David.Poole (11/7/2016)
Great article, well written. I'd hope for something this clear if I was on call.
Any idea what caused spid 484 to hang around?
That was going to be my...
--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)

November 7, 2016 at 7:35 am

#1910921
RE: Sproc/view/function code parser

Grant Fritchey (11/5/2016)
I don't know of a tool that does a great job.
Heh... brain of a good DBA or Developer.
--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)

November 6, 2016 at 10:58 pm

#1910823
RE: Books and Training Materials for SQL Server 2014 SSAS Tabluar

quinn.jay (11/6/2016)
Hello, I have Google and Amazon searched foe books and training materials for SQL Server SSAS Tabular, and I find 2012 SSAS Tabular, and pre-order for 2017 materials. Is...
--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)

November 6, 2016 at 10:52 pm

#1910821
RE: How Do You Act When You Need to Learn New Technology?

To be honest, I'm starting to get really pissed off at people and their "new improved shinny bobbles". I've spent countless hours listening patiently and doing due diligence for...
--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)

November 6, 2016 at 10:15 pm

#1910815
RE: Are the posted questions getting worse?

Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.
That said, can anyone...
--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)

November 6, 2016 at 4:50 pm

#1910810
RE: Are the posted questions getting worse?

jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.
That said, can...
--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)

November 6, 2016 at 4:43 pm

#1910809
RE: Execution Plan help. Estimates off by alot !

thomashohner (11/6/2016)
Thanks Jeff, i'll keep looking odd thing is I only have one <> 0 in the joins. Unfortunately I have not figured out away around it.
edit: I lied 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)

November 6, 2016 at 2:45 pm

#1910808

Viewing 15 posts - 16,351 through 16,365 (of 59,067 total)