Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,336 through 19,350 (of 59,072 total)

RE: The Hot Jobs

xsevensinzx (10/26/2015)
Eric M Russell (10/26/2015)
..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect, Big Data Engineer,...
--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)

October 26, 2015 at 7:51 pm

#1835631
RE: Missing Relationships

Wayne West (10/26/2015)
Jeff Moden (10/25/2015)
... Then, introduce them to some very high velocity pork chops.
As it happens, I was eating a brisket and sausage sandwich when I read this. ...
--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)

October 26, 2015 at 7:41 pm

#1835629
RE: Positive or Negative

SQLBill (10/26/2015)
The way I would determine which to use (Active or Inactive) would depend on how I am going to query the data. I use "pseudo code" to determine...
--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)

October 26, 2015 at 7:37 pm

#1835628
RE: Starting to get tired of all the spam on the forums !!!!

Steve Jones - SSC Editor (10/26/2015)
They are using some bug that lets them submit many posts, even as unapproved users.
[font="Arial Black"]PLEASE [/font]tell me that the bug is in the...
--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)

October 26, 2015 at 7:02 pm

#1835626
RE: DELETE syntax - jus checking in..

Kim Crosser (10/26/2015)
Jeff Moden (10/25/2015)
[font="Arial Black"]The reason why I'm so interested in this is because it HAS happened before.[/font] I believe it was post 2000 SP2 but SQL Server...
--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)

October 26, 2015 at 6:57 pm

#1835625
RE: The Hot Jobs

xsevensinzx (10/26/2015)
There simply is not enough supply for the demand and while the employer is looking for 5 to 10 years experience...
My problem has been that I've interviewed plenty of...
--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)

October 26, 2015 at 11:07 am

#1835569
RE: Positive or Negative

Kim Crosser (10/25/2015)
It wouldn't be so bad if the "StatusCode" column were a computed column based on the datetime columns, but the developers don't like logic embedded in the database.
Now...
--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)

October 26, 2015 at 10:45 am

#1835559
RE: Positive or Negative

jeff.pendleton (10/26/2015)
...the correct and most efficient use of a flag is for marking exceptions...
I strongly disagree with both of those notions especially since NULLs are a frequent cause of needing...
--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)

October 26, 2015 at 10:40 am

#1835558
RE: Using Dynamic SQL To Order Column Names

That will "only" handle the price and rating combination and only in that order. We're going to need some dynamic SQL here and it needs to be in the...
--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)

October 26, 2015 at 10:36 am

#1835556
RE: A Simple Formula to Calculate the ISO Week Number

robert.sterbal 56890 (10/26/2015)
To the best of my knowledge, I know of no temporal system that considers midnight to be at the end of the day. It always marks the...
--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)

October 26, 2015 at 10:33 am

#1835554
RE: Using value from cloumns to generate a new value for new column

sqlbaby2 (10/26/2015)
Hi
I've data as below
account period01 period02 period03 period04
1111 null ...
--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)

October 26, 2015 at 5:11 am

#1835479
RE: Missing Relationships

Ratheesh.K.Nair (10/25/2015)
Jeff Moden (10/25/2015)
Ratheesh.K.Nair (10/25/2015)
Hi Experts,
We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help 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)

October 25, 2015 at 10:30 pm

#1835445
RE: Retrieve String Between Two Delimiters for Multiple Occurences SQL Server

Alan.B (10/21/2015)
My Hacked version of Jeff's splitter splits a string based on a delimiter that is longer than 1. I
Just a suggestion and looking at the data, I wonder 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)

October 25, 2015 at 11:36 am

#1835424
RE: SSIS Import from Excel

TSQL Tryer (10/23/2015)
Appreciate your help with.
As I have the above UNION and the Excel Connection has "First Row has Column Names", so that the first select statement picks up the...
--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)

October 25, 2015 at 11:27 am

#1835423
RE: How to do an OPENROWSET query within a cursor using variables

Blue Rabbit (10/22/2015)
Hi, I am writing a custom query to determine if a legacy table exists or not. From My CMS Server I already have all the instances 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)

October 25, 2015 at 11:17 am

#1835421

Viewing 15 posts - 19,336 through 19,350 (of 59,072 total)