Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,806 through 14,820 (of 59,097 total)

RE: How to convert Large text file to Excel

Thom A - Wednesday, July 5, 2017 6:23 AM
subratnayak09 - Wednesday, July 5, 2017 6:17 AM
--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)

July 5, 2017 at 6:42 am

#1949449
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, July 4, 2017 1:10 PM
Some people are kinda getting on my nerves.
People who are the excellent at something usually...
--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)

July 5, 2017 at 5:49 am

#1949435
RE: Are the posted questions getting worse?

ChrisM@Work - Tuesday, July 4, 2017 1:21 AM
Happy holidays to our wonderful neighbours across the water, celebrating Brexit 1776!
BWAAA-HAAA!!! Now that'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)

July 4, 2017 at 10:17 am

#1949352
RE: What's the best way to get a sample set of a big table without primary key?

Didn't know this was for a type of NoSQL. Considering that you have "billions" of rows, it may be time to bite the bullet and put it all in a...
--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)

July 4, 2017 at 10:14 am

#1949350
RE: How does a stored procedure takes 15 seconds to start?

Eric Mamet - Sunday, July 2, 2017 3:14 PM
What seems the best way to evaluate the cost of recompiles?
Extended events on...
--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)

July 3, 2017 at 7:09 pm

#1949270
RE: Disk space report showing wrong results

Fire up an SQL Agent job that does a DIR through xp_CmdShell on the C: drive of a machine that is reporting correctly and a machine that is not. 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)

July 2, 2017 at 1:43 pm

#1949078
RE: De-Identification of PHI Data

ericwenger1 - Sunday, July 2, 2017 1:08 PM
I'm not sure it really makes alot of difference so long as you can't identify...
--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)

July 2, 2017 at 1:38 pm

#1949077
RE: De-Identification of PHI Data

Let me ask you the same question I've asked many others.... if the data contained information about your or your family, would you actually be happy that someone used datamasking...
--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)

July 2, 2017 at 12:49 pm

#1949073
RE: What's the best way to get a sample set of a big table without primary key?

Jeff Moden - Friday, June 30, 2017 9:03 PM
halifaxdal - Friday, June 30, 2017 7:59 PM
--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)

July 2, 2017 at 12:14 pm

#1949070
RE: Dedup Large Table

xsevensinzx - Saturday, July 1, 2017 1:14 PM
Yep, pretty much. Not saying it was unique, but others have sold it as...
--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)

July 2, 2017 at 9:36 am

#1949069
RE: Dedup Large Table

xsevensinzx - Saturday, July 1, 2017 3:46 AM
However, the trust issue is the big one that turns away most DBA's and 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)

July 1, 2017 at 7:09 am

#1949048
RE: Dedup Large Table

J Livingston SQL - Saturday, July 1, 2017 1:51 AM
Jeff Moden - Friday, June 30, 2017 6:48...
--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)

July 1, 2017 at 5:55 am

#1949044
RE: What's the best way to get a sample set of a big table without primary key?

Heh... and why you don't think it's practical to serialize a billion row table is beyond me. 😉
--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)

June 30, 2017 at 9:04 pm

#1949034
RE: What's the best way to get a sample set of a big table without primary key?

halifaxdal - Friday, June 30, 2017 7:59 PM
Jeff Moden - Friday, June 30, 2017 5:47 PM
--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)

June 30, 2017 at 9:03 pm

#1949033
RE: Dedup Large Table

Just remember that checksum is NOT reliable when it comes to the determination of what is a duplicate. It should only be used for determining what COULD be duplicates and...
--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)

June 30, 2017 at 6:48 pm

#1949026

Viewing 15 posts - 14,806 through 14,820 (of 59,097 total)