Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,071 through 14,085 (of 59,101 total)

RE: Very challenging TSQL Query

hapsa10 - Monday, October 16, 2017 11:10 AM
PodrÃas intentar hacer algo como esto.
;With CTE_Source As (
    Select Fl, Col
    , Val = Case
                When...
--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 16, 2017 at 5:29 pm

#1963947
RE: Very challenging TSQL Query

Alan.B - Monday, October 16, 2017 3:01 PM
hapsa10 - Monday, October 16, 2017 11:10 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)

October 16, 2017 at 5:26 pm

#1963945
RE: Very challenging TSQL Query

hapsa10 - Monday, October 16, 2017 11:10 AM
PodrÃas intentar hacer algo como esto.
;With CTE_Source As (
    Select Fl, Col
    , Val = Case
                When...
--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 16, 2017 at 5:20 pm

#1963944
RE: Today's Random Word!

Ray K - Monday, October 16, 2017 1:00 PM
ZZartin - Monday, October 16, 2017 12:24 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)

October 16, 2017 at 5:14 pm

#1963943
RE: could some one help me with the query below

Lynn Pettis - Monday, October 16, 2017 9:49 AM
So, your policy is that all databases are to use the SIMPLE recovery model? ...
--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 16, 2017 at 11:53 am

#1963909
RE: Timing is Everything

It's real simple, in most cases. I just ask them how to get the current date and time in 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 16, 2017 at 9:49 am

#1963866
RE: could some one help me with the query below

David Burrows - Monday, October 16, 2017 8:27 AM
I have never used it but according to the spec referenced you are using...
--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 16, 2017 at 8:39 am

#1963848
RE: The Cloud is Better In At Least One Way

Steve Jones - SSC Editor - Monday, October 16, 2017 7:44 AM
Any particular person can out optimize the cloud, especially for value...
--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 16, 2017 at 7:59 am

#1963831
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, October 16, 2017 7:39 AM
Adding web capacity to hopefully speed things up a bit
Thanks, Steve.
--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 16, 2017 at 7:47 am

#1963825
RE: Are the posted questions getting worse?

Thom A - Monday, October 16, 2017 7:26 AM
Forums appear to be on a bit of a go slow again. 🙁
REALLY SLOW. It'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)

October 16, 2017 at 7:46 am

#1963824
RE: Identify the Column for 'String or binary data would be truncated'

skeleton567 - Sunday, October 15, 2017 3:42 PM
OK, here's a good one. I import my data into a table with all field...
--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 16, 2017 at 6:43 am

#1963804
RE: bcp import data from text file to sql server table - german accent

rash3554 - Monday, October 16, 2017 2:58 AM
I changed the length of the last field to 7. It helped me get 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)

October 16, 2017 at 6:21 am

#1963798
RE: TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO

mrpellepelle - Monday, October 16, 2017 3:22 AM
When i use OPTION(RECOMPILE) to the INSERT statement, there is no time difference anymore.
GREAT,...
--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 16, 2017 at 6:02 am

#1963796
RE: Incremental load solution to track the changes

ramrajan - Friday, October 13, 2017 1:26 AM
Loading the data 70 Million records from IBM DB2 to SQL Server
Problem â€“
1. Need...
--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 16, 2017 at 5:57 am

#1963795
RE: Incremental load solution to track the changes

Phil Parkin - Monday, October 16, 2017 5:43 AM
ramrajan - Monday, October 16, 2017 5:04 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)

October 16, 2017 at 5:49 am

#1963792

Viewing 15 posts - 14,071 through 14,085 (of 59,101 total)