Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,011 through 17,025 (of 59,067 total)

RE: Parallel insert in a table

sqlenthu 89358 (8/15/2016)
Part of table into different spindles means partitioned tables ?
That would be necessary but you can partition the heck out of a table using multiple files and yet...
--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)

August 16, 2016 at 2:58 pm

#1895790
RE: Experience, Location & Salary for Database Professionals in USA

sqld-_-ba (8/16/2016)
I read somewhere SSC has 600K visitors. Assuming 10% see the salary survey, and 1% respond, that is 6000 responses. I'm also trying to advertise this on stackexchange, 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)

August 16, 2016 at 2:51 pm

#1895785
RE: Need query for After Trigger on update,delete

ScottPletcher (8/16/2016)
Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged. But verify...
--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)

August 16, 2016 at 11:26 am

#1895726
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

ChrisM@Work (8/16/2016)
The Dixie Flatline (8/16/2016)
Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads is that,...
--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)

August 16, 2016 at 11:12 am

#1895721
RE: Tablix assistance please!

faulknerwilliam2 (8/16/2016)
Dear Jeff
A thousand thanks for your help and your taking the time and trouble to help with my query. Your solution has worked perfectly. I love the ranking element.
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)

August 16, 2016 at 8:55 am

#1895680
RE: need to copy a 600 gig table

BLOB_EATER (8/16/2016)
Jeff Moden (8/16/2016)
BLOB_EATER (8/16/2016)
Where can I find info on Log files can use instant file initialization? I thought differently so I am very curious now (unless I read...
--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)

August 16, 2016 at 8:45 am

#1895672
RE: need to copy a 600 gig table

BLOB_EATER (8/16/2016)
Where can I find info on Log files can use instant file initialization? I thought differently so I am very curious now (unless I read Jeff's post wrong)
Yes......
--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)

August 16, 2016 at 8:09 am

#1895655
RE: need to copy a 600 gig table

Luis Cazares (8/12/2016)
Snargables (8/12/2016)
I didn’t mean not log at all. I just don’t want it to use one continuous transaction to load 2.5 billion records. SSIS is doing it in...
--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)

August 16, 2016 at 7:27 am

#1895640
RE: need to copy a 600 gig table

Luis Cazares (8/12/2016)
but minimal logging can make the log grow even more than normal logging
I've never seen actual minimal logging cause such a thing especially since about the only thing...
--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)

August 16, 2016 at 7:23 am

#1895637
RE: Tablix assistance please!

Ok... Here we go. Let's do this "for real" using a test table of 7 million constrained but random rows over a period of 7 years (million rows per...
--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)

August 15, 2016 at 9:53 pm

#1895554
RE: Partition and Index Alignment

Will you ever need to copy a "part" of the table to a Dev or Test box?
--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)

August 15, 2016 at 6:00 pm

#1895545
RE: Need query for After Trigger on update,delete

ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original 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)

August 15, 2016 at 4:15 pm

#1895540
RE: Tablix assistance please!

Apologies for missing your follow up posts on this. It IS a bit amazing to me that no one else picked up on this thread. I'll see what...
--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)

August 15, 2016 at 4:12 pm

#1895539
RE: Finding data that does not exist in another table

msmith-880862 (8/15/2016)
Thanks for the reply everyone. It looks like I can't do it with a view but I got some great ideas from everyone. Thanks again.
Just 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)

August 15, 2016 at 4:05 pm

#1895538
RE: Rounding in tsql

CELKO (8/15/2016)
The ANSI/ISO standards define rounding as "implementation defined", so you have to be careful. Google scientific versus commercial rounding (I prefer this because it is more "set oriented" than...
--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)

August 15, 2016 at 3:45 pm

#1895535

Viewing 15 posts - 17,011 through 17,025 (of 59,067 total)