Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,526 through 12,540 (of 59,102 total)

RE: INSERT INTO from one table to another table show duplicate row ??? WHY

mrceski - Sunday, April 22, 2018 6:01 AM
I use this code:
INSERT INTO
TableIzlez ([BrojNaSmetka],[Artikal],[Sifra],[Kolicina],[Cena_P],[Cena_N],[Prodavac],
[Datum],[Fiskalna],[MasaBroj],[Oddel],[Zatvorena],[PodGrupa],[Cena_Produkti],[TipNaSmetka],[DDV],[Den])
SELECT
BrojNaSmetka,Artikal,Sifra,Kolicina,Cena_P,Cena_N,Prodavac,Datum,
Fiskalna,MasaBroj,Oddel,Zatvorena,PodGrupa,Cena_Produkti,TipNaSmetka,DDV,'19.04.2018'
FROM TableIzlezDneven
Aftrer this code I delete the table...
--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)

April 22, 2018 at 1:43 pm

#1987800
RE: YTD Calculation

jallowmarie - Saturday, April 21, 2018 3:38 PM
hi ,
i need help with calculating YTD for Tax and TaxablePay. I already have 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)

April 22, 2018 at 12:41 pm

#1987798
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, April 20, 2018 12:18 PM
Lynn Pettis - Friday, April 20,...
--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)

April 20, 2018 at 1:05 pm

#1987746
RE: Keep It All

Eric M Russell - Friday, April 20, 2018 12:15 PM
jay-h - Friday, April 20, 2018 11:30 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)

April 20, 2018 at 1:03 pm

#1987744
RE: Where GROUPING SETS is used.

Key point here... don't confuse OLAP Cubes with the WITH CUBE option of GROUP BY.
--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)

April 20, 2018 at 11:54 am

#1987727
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, April 20, 2018 10:15 AM
Jeff Moden - Friday, April 20, 2018 9:07 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)

April 20, 2018 at 10:29 am

#1987706
RE: Keep It All

Shifting gears a bit, we're setting up to delete 1TB from a 1.4TB database and 600GB from a 1TB database. The data we're dropping is simply data that no one...
--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)

April 20, 2018 at 9:34 am

#1987690
RE: The best way to load big chunks of rolling data

valeryk2000 - Friday, April 20, 2018 8:50 AM
We have monthly loads of a THREE month of data: say, in April it's Jan,...
--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)

April 20, 2018 at 9:28 am

#1987689
RE: Where GROUPING SETS is used.

saravanatn - Friday, April 20, 2018 9:08 AM
Jeff Moden - Friday, April 20, 2018 7:39 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)

April 20, 2018 at 9:24 am

#1987688
RE: Are the posted questions getting worse?

Shifting gears a bit, I'm giving a new presentation here in the Detroit area for the local PASS Chapter on the 10th of May. I was limited to 1000 bytes...
--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)

April 20, 2018 at 9:07 am

#1987684
RE: SQL Server 2016 Enterprise - Free space recommendation

dajonx - Friday, April 20, 2018 7:16 AM
Ah, yes... You're right, Jason. I am confusing database file free space with free space...
--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)

April 20, 2018 at 7:54 am

#1987667
RE: Where GROUPING SETS is used.

saravanatn - Thursday, April 19, 2018 9:03 PM
I am working as a Database Tester for quite some time. But I never 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)

April 20, 2018 at 7:39 am

#1987662
RE: Backup and restore speeds are significantly slower on flash storage than on sas drives.

Feivel - Thursday, April 19, 2018 2:07 PM
One of our users complained that when trying to backup/restore a database roughly a GB...
--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)

April 20, 2018 at 7:25 am

#1987658
RE: Spills into tempdb poor performing query fixed by converting to SP

My first-blush guess would be that the original code used values only known at execution time and the stored procedure used parameters known prior to execution time.
However, 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)

April 20, 2018 at 7:18 am

#1987653
RE: Transferring data between tables

richardmgreen1 - Friday, April 20, 2018 6:52 AM
Thanks all
Unfortunately, I can't make that decision arbitrarily.
I'll have a chat with my boss 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)

April 20, 2018 at 7:13 am

#1987651

Viewing 15 posts - 12,526 through 12,540 (of 59,102 total)