Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,906 through 13,920 (of 59,095 total)

RE: Handling string column with dates

Thom A - Saturday, October 28, 2017 3:17 PM
Jeff Moden - Saturday, October 28, 2017 2:53 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 28, 2017 at 5:19 pm

#1965686
RE: What else can take up space in a database besides tables

Heh... Right now I'm thinking, "Check-valve".
--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 28, 2017 at 3:53 pm

#1965685
RE: Help in analyzing deadlock and index recommendation - all definitions included

Santhoshkumar KB - Friday, October 13, 2017 7:38 AM
Interestingly all the deadlocks (around 70+) from past 2 days are showing
ridlock fileid=4...
--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 28, 2017 at 3:44 pm

#1965684
RE: select top(100) percent

Lynn Pettis - Friday, October 20, 2017 3:03 PM
sgmunson - Friday, October 20, 2017 2:02 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 28, 2017 at 3:07 pm

#1965682
RE: Handling string column with dates

GrassHopper - Friday, October 20, 2017 2:49 PM
Thom A - Friday, October 20, 2017 12:21 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 28, 2017 at 2:53 pm

#1965681
RE: Which is the end?

I still think it hilarious (I laughed almost hysterically when I first heard of it) , in a dreadful sort of way, that they took the time to create a function...
--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 28, 2017 at 2:10 pm

#1965680
RE: Bulk load architecture

sqlenthu 89358 - Friday, October 27, 2017 2:06 AM
I think I will have to get bulk admin administrator role for my...
--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 28, 2017 at 11:13 am

#1965679
RE: Bulk load architecture

Phil Parkin - Friday, October 27, 2017 5:57 AM
Jeff Moden - Thursday, October 26, 2017 9:09 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 28, 2017 at 11:07 am

#1965678
RE: SQL versus program

patrickmcginnis59 10839 - Friday, October 27, 2017 6:44 AM
Jeff Moden - Thursday, October 26, 2017 8:08 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 28, 2017 at 10:52 am

#1965676
RE: Substring Question

Eirikur Eiriksson - Saturday, October 28, 2017 7:05 AM
Jeff Moden - Friday, October 27, 2017 7:40 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 28, 2017 at 8:37 am

#1965671
RE: Substring Question

For those that may be getting ready to pounce on using a starting position of "0" instead of "1", it's a trick to make it so that you don't have...
--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 7:40 pm

#1965647
RE: Substring Question

One way is like this...
Select Substring(name,0, ISNULL(NULLIF(Charindex('.',name),0),8000)) as name2
If the CHARINDEX results in a "0", the NULLIF converts it to a 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 27, 2017 at 7:33 pm

#1965646
RE: Execute AS writing to different DB

dan-572483 - Friday, October 27, 2017 3:03 PM
The Trustworthy setting was it. Thank you.
Was it on or off?
--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 7:09 pm

#1965643
RE: What happens when delete query executed inside sql server engine , process in deleting file , how data page will be managed , how deleted data pages will be free for next use?

Sue_H - Friday, October 27, 2017 12:55 PM
sgmunson - Friday, October 27, 2017 12:05 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 27, 2017 at 7:06 pm

#1965642
RE: Data Modelers - Alternatives to Erwin

It's done and it worked just fine. I reverse engineered all the tables in a 1,391 table, 1.3TB database in 327 seconds with no display turned on, added a table...
--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:47 pm

#1965640

Viewing 15 posts - 13,906 through 13,920 (of 59,095 total)