Jeff Moden

Forum Replies Created

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

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
RE: The Cloud is Better In At Least One Way

I didn't find the specific pricing I was looking for but I did click on the pricing link in the menu at the top of the page... not bad if...
--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 15, 2017 at 1:45 pm

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

xsevensinzx - Sunday, October 15, 2017 5:46 AM
Jeff Moden - Saturday, October 14, 2017 9:07 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 15, 2017 at 1:25 pm

#1963735
RE: Creating a Gantt Chart using SQL?

SteveOC - Sunday, October 15, 2017 8:43 AM
Jeff Moden - Saturday, October 14, 2017 10:29 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 15, 2017 at 1:01 pm

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

Where are you trying to run this query from? I don't believe it'll run in SSMS because the EXECUTESQL isn't a part of the T-SQL language. One of the .Net...
--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 14, 2017 at 9:14 pm

#1963716
RE: What can you tell me about DBeaver?

Looks interesting but this is the first I've heard of it, Rod.
--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 14, 2017 at 9:09 pm

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

I read the article about Azure that you provided the link for. Other than having someone else do the dirty work, I'm not really seeing any advantages there. For example,...
--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 14, 2017 at 9:07 pm

#1963714

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