Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,281 through 14,295 (of 59,097 total)

RE: HIERARCHYID DataType and Referential Integrity

Apologies I lost track of this one. Here's both my opinion and the method I use...
The HierarchyID is based on a "Hierarchical Path" type of hierarchical structure. It...
--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)

September 20, 2017 at 8:51 am

#1960177
RE: Interviews: What is ACID?

Heh... yeah but did you know how to get the current date and time? 😀
--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)

September 19, 2017 at 9:42 pm

#1960073
RE: Setup the sync process against Large Database

Amit Kumar-481560 - Tuesday, September 19, 2017 11:51 AM
Hi All,
The database size is 150TB which required to sync in development from production environment.
Please...
--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)

September 19, 2017 at 8:33 pm

#1960072
RE: Need to rebuild Index on 1.4 TB table (Replication is setup on that database) and also on 900 GB table(mirroring is setup on database

kiran_Sqldba - Monday, April 25, 2016 5:34 AM
Thanks all for their suggestion. Help me a lot to understand what are different ways...
--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)

September 19, 2017 at 8:16 pm

#1960071
RE: SSIS not copying all rows in data flow task

By any chance, are all of the columns implicitly convertible to all of the other columns in the destination 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)

September 19, 2017 at 7:30 pm

#1960069
RE: Are the posted questions getting worse?

Luis Cazares - Tuesday, September 19, 2017 2:54 PM
Also, today is the 32nd anniversary of the most devastating earthquake that Mexico has...
--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)

September 19, 2017 at 7:22 pm

#1960068
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, September 19, 2017 2:39 PM
OMG! People are getting so literal! "I am not using a system table." Hey! ...
--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)

September 19, 2017 at 7:06 pm

#1960067
RE: Are the posted questions getting worse?

Alan.B - Tuesday, September 19, 2017 4:44 PM
SQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
Heh... yep... fun stuff.

SELECT...
--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)

September 19, 2017 at 6:56 pm

#1960066
RE: ? on Parsing an XML field

I've found that it's much more fun to visit the person sending you the XML and just beat the crap out of them. 😉
--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)

September 19, 2017 at 6:13 pm

#1960064
RE: Concatenate sp_MSForeachdb results

sqlnewbie17 - Tuesday, September 19, 2017 1:25 AM
How can I join all the results of the below query into a single result...
--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)

September 19, 2017 at 6:10 pm

#1960063
RE: The Library Job Hunt

I got laid off just once due to a company restructuring/physical move and it was with only 2 weeks notice with a pitiful severance. I got really lucky (or maybe...
--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)

September 19, 2017 at 6:02 pm

#1960062
RE: Job failing with maximum row size exceeds the allowed maximum of 8060 bytes.

Database admin(DBA) - Tuesday, September 19, 2017 2:10 PM
Lynn Pettis - Tuesday, September 19, 2017 1:12 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)

September 19, 2017 at 4:40 pm

#1960054
RE: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

Thanks for the feedback both on your fix and on nonRBAR solutions, Geoff. I appreciate it.
--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)

September 19, 2017 at 4:10 pm

#1960051
RE: The struggle to renormalize data

David.Poole - Monday, September 18, 2017 8:15 AM
I'm just not convinced that something that can be achieved with bcp should be replaced...
--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)

September 18, 2017 at 5:22 pm

#1959888
RE: Mortgage amortization table

ScottPletcher - Monday, September 18, 2017 10:00 AM
I don't think this is really an issue, as a practical matter. Interest is computed daily,...
--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)

September 18, 2017 at 5:16 pm

#1959887

Viewing 15 posts - 14,281 through 14,295 (of 59,097 total)