Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,256 through 15,270 (of 59,101 total)

RE: Update SQL with excel files?

Thom A - Wednesday, April 5, 2017 1:49 AM
stino - Tuesday, April 4, 2017 11:09 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 5, 2017 at 7:42 am

#1936783
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Wednesday, April 5, 2017 4:19 AM
The last query posted by SQL_Elvis is actually wrong:
CAST(FILEPROPERTY(name,''SpaceUsed'') AS INT) UsedSpaceMB,
should 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)

April 5, 2017 at 7:39 am

#1936782
RE: Should I listen to this recommendation to change data lengths for consistency during ETL?

Andrew P - Wednesday, April 5, 2017 3:16 AM
The source database is the Microsoft sample database AdventureWorksLT 2012. I'm not sure why...
--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 5, 2017 at 7:25 am

#1936778
RE: Just the time, please

Actually (and without giving up the correct answer here), none of the answers are correct because the correct answer doesn't have enough zeroes to the right of the decimal point....
--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 4, 2017 at 11:04 pm

#1936692
RE: Adding More Power

Wouldn't it be cheaper in the long run to optimize the code instead of throwing more resources into the picture?
--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 4, 2017 at 11:00 pm

#1936691
RE: need some best practice tutorials for Sql server to oracle ETL using SSIS

Personally, I wouldn't use SSIS. That, notwithstanding, try the following Google search. There seem be some tutorials (MSSQLTIPS is usually good) and YouTubes on the subject.
https://www.google.com/?gws_rd=ssl#q=ssis+transfer+data+from+sql+server+to+oracle&*&spf=381
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)

April 4, 2017 at 10:54 pm

#1936690
RE: Index and or constraint

andis59 - Tuesday, April 4, 2017 2:02 PM
I have this table
CREATE TABLE [dbo].[LaserData](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [MachineId} [nvarchar](50) NULL,
    [F1] [nvarchar](50) NOT NULL,
    [Kant]...
--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 4, 2017 at 10:41 pm

#1936689
RE: Should I listen to this recommendation to change data lengths for consistency during ETL?

The instructor is partially correct. Consistency is vitally important for speed of development, more error free code, and for the sake of performance especially when it comes to the creation...
--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 4, 2017 at 10:26 pm

#1936688
RE: Columns to rows and rows to columns

Apparently, the OP has left the building.
--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 4, 2017 at 9:06 pm

#1936681
RE: Update SQL with excel files?

stino - Friday, March 24, 2017 4:23 PM
Hi,
i need to update 1500 employee records,
my new data i have in Excel,...
--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 4, 2017 at 8:23 pm

#1936679
RE: How to join these tables together

Bill Talada - Tuesday, April 4, 2017 12:23 PM
This all reminds me of co-workers asking what is the part number. Are they...
--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 4, 2017 at 6:22 pm

#1936673
RE: Help in finding actual days and hours difference!!!

dhanekulakalyan - Monday, April 3, 2017 3:46 PM
Hello All,
--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 4, 2017 at 4:47 pm

#1936668
RE: SELECT output formation

kevv - Tuesday, April 4, 2017 6:13 AM
I want to export these columns and their values into a .SQL file so 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)

April 4, 2017 at 8:07 am

#1936544
RE: SQL Login Password Audit

Andreas Michael - Tuesday, April 4, 2017 1:47 AM
Hi, is it possible to have some serious sources on howto create and fill...
--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 4, 2017 at 8:00 am

#1936541
RE: How to join these tables together

jcelko212 32090 - Monday, April 3, 2017 9:00 AM
Jeff Moden - Sunday, April 2, 2017 5:01 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)

April 4, 2017 at 7:30 am

#1936529

Viewing 15 posts - 15,256 through 15,270 (of 59,101 total)