Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,921 through 13,935 (of 59,095 total)

RE: Data Modelers - Alternatives to Erwin

In all seriousness, I found a hack on SO and I'm in the process of reverse engineering a 2016 Enterprise database using Visio 2010 Pro. I'll let you know how...
--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 27, 2017 at 5:30 pm

#1965639
RE: Data Modelers - Alternatives to Erwin

Lynn Pettis - Friday, October 27, 2017 9:54 AM
Anyone remember what last Version of Visio that supported reverse engineering of databases?
Yes. The "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)

October 27, 2017 at 4:49 pm

#1965636
RE: StartDate and EndDate in same column

Redmond01 - Friday, October 27, 2017 12:31 AM
Correct Jeff Moden start date should be 2006-08-02 instead of 2004-08-02, hat was a type...
--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 27, 2017 at 4:27 pm

#1965635
RE: PURGING DATA

The way you're going about it will require constant changes to the stored procedure each month. Further and based on the number of months that you look like you're trying...
--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 27, 2017 at 6:47 am

#1965495
RE: Parameter Sniffing In Action

Grey Cat - Thursday, October 26, 2017 4:03 PM
steve.powell1 - Tuesday, October 24, 2017 2:02 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 26, 2017 at 9:51 pm

#1965449
RE: App timing out, but sproc runs in 3 seconds

butcherking13 - Thursday, October 26, 2017 9:01 PM
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation...
--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, 2017 at 9:49 pm

#1965448
RE: Bulk load architecture

sqlenthu 89358 - Thursday, October 26, 2017 6:47 AM
Also is there a way to handle UNC path configuration as source folder for...
--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, 2017 at 9:11 pm

#1965447
RE: Bulk load architecture

Thom A - Tuesday, October 10, 2017 8:32 AM
... and the other is just a File System Task.
I'm curious... can this "File...
--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, 2017 at 9:09 pm

#1965446
RE: Update 600,000 rows in table

Heh... I just noticed. :sick: The OP started this thread 3 weeks ago and hasn't been back to this site since. Must be one of those folks that doesn't...
--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, 2017 at 8:38 pm

#1965445
RE: Send mail from stored procedure

mjohnson 71479 - Thursday, October 26, 2017 3:36 PM
I just needed to think outside of the T-SQL box and use a non-ANSI...
--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, 2017 at 8:22 pm

#1965444
RE: Concatenate two columns which have a space between them

NorthernSoul - Monday, October 16, 2017 8:34 AM
adan950 - Monday, October 16, 2017 8:16 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 26, 2017 at 8:11 pm

#1965443
RE: SQL versus program

patrickmcginnis59 10839 - Monday, October 23, 2017 6:47 AM
Jeff Moden - Saturday, October 21, 2017 6:06 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 26, 2017 at 8:08 pm

#1965442
RE: StartDate and EndDate in same column

Redmond01 - Thursday, October 26, 2017 6:15 PM
Well basically my Rundate column is in ascending order and I have to setstart 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)

October 26, 2017 at 7:59 pm

#1965441
RE: Transport error encountered when SOME queries run with batch terminator. Behaviour changes depending on text of query. WEIRD!

Don Halloran - Thursday, October 26, 2017 2:57 PM
No crazy database settings Jeff. I have a strong suspicion that this is not...
--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, 2017 at 7:30 pm

#1965440
RE: Reproduce-able : Could not continue scan with NOLOCK due to data movement.

The real solution is to not use WITH(NOLOCK). 😉
--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, 2017 at 5:36 pm

#1965427

Viewing 15 posts - 13,921 through 13,935 (of 59,095 total)