Jeff Moden

Forum Replies Created

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

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
RE: SQL Server 2008 R2 CPU Blunted Spikes

laurence.proctor - Monday, April 3, 2017 1:54 AM
The thing is, when the spikes occur, you can't run sp_whoisactive; even the profiler seems to hang, 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 3, 2017 at 8:46 am

#1936307
RE: Need SQL Training Recommendations

james.mobley - Friday, March 31, 2017 5:01 AM
Thank you for all the suggestions, I will start diving in today. This isn't an...
--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 3, 2017 at 8:39 am

#1936305
RE: High Usage of tempdb

smthembu - Sunday, April 2, 2017 11:39 PM
Hi there,
I need your help with regards to a query that is running on SQL...
--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 3, 2017 at 8:17 am

#1936300
RE: No PKs on fact tables

robert.gerald.taylor - Monday, April 3, 2017 7:26 AM
As I get to know the usage better, I'll be able to determine what good...
--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 3, 2017 at 8:02 am

#1936290

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