Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,596 through 11,610 (of 59,099 total)

RE: Representing XML data in SQL Server

Eirikur Eiriksson - Tuesday, August 7, 2018 11:49 PM
Thank you for this article Diogo, nice write-up.
😎
Quick thoughts, I think it would...
--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)

August 8, 2018 at 12:12 am

#2000739
RE: Partioning Huge Table (650GB about)

Thanks and, yeah, joined at the hip with you on vertically spitting such wide tables into sister tables but, like you say, not my idea on these tables and common...
--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)

August 7, 2018 at 10:29 pm

#2000735
RE: BCP Error

First of all, I've only ever seen one other table consisting of mostly NVARCHAR(MAX) columns and it was horribly slow because of it. I know you're just trying to get...
--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)

August 7, 2018 at 10:04 pm

#2000734
RE: Need help to extract unstructured excel data to sql server

saptek9 - Tuesday, August 7, 2018 12:04 PM
Can i use Microsoft power query or third party tools like Alteryx to extract the ...
--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)

August 7, 2018 at 9:14 pm

#2000732
RE: formatting T-SQL

Eric M Russell - Tuesday, August 7, 2018 12:46 PM
If you work in an organization where a DBA has an the opportunity,...
--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)

August 7, 2018 at 9:08 pm

#2000731
RE: please help !! Dynamic SQL

Scott Coleman - Tuesday, August 7, 2018 1:59 PM
It would be enlightening to hear what environment actually requires the CHAR(13). Everything I've...
--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)

August 7, 2018 at 8:56 pm

#2000730
RE: Representing XML data in SQL Server

Jeff Rivera - Tuesday, August 7, 2018 6:10 PM
I feel sheepish disagreeing with a SQL legend but here goes: Regarding the...
--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)

August 7, 2018 at 8:51 pm

#2000729
RE: Partioning Huge Table (650GB about)

andycadley - Tuesday, August 7, 2018 11:30 AM
+1 for Temporal Tables as a great solution to this kind of problem and +10...
--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)

August 7, 2018 at 7:35 pm

#2000727
RE: Move some tables onto a different database.

sgmunson - Tuesday, August 7, 2018 10:24 AM
Jonathan AC Roberts - Tuesday, August 7, 2018 8:39 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)

August 7, 2018 at 7:18 pm

#2000726
RE: Move some tables onto a different database.

Jonathan AC Roberts - Tuesday, August 7, 2018 6:04 AM
Hi Y'all
I'd like some advice. My problem is there are a pair of...
--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)

August 7, 2018 at 7:15 pm

#2000725
RE: BCP Error

There are a huge number of possibilities as to what is wrong. At this point, I'm going to suggest that we might not be able to help at all without...
--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)

August 7, 2018 at 9:11 am

#2000627
RE: please help !! Dynamic SQL

Lidou123 - Tuesday, August 7, 2018 8:55 AM
laurie-789651 - Tuesday, August 7, 2018 8:45 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)

August 7, 2018 at 9:07 am

#2000625
RE: Adding Indexes to Tables

Grant Fritchey - Tuesday, August 7, 2018 6:24 AM
rjjh78 - Monday, August 6, 2018 3:52 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)

August 7, 2018 at 7:38 am

#2000594
RE: formatting T-SQL

andycadley - Tuesday, August 7, 2018 6:29 AM
Luis Cazares - Monday, August 6, 2018 11:25 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)

August 7, 2018 at 7:34 am

#2000591
RE: Archiving when 2 tables are sharing the same partition scheme and same partition function

Thanks for the feedback on my comment.
Shifting gears a bit, I've found that partitioned tables are pretty annoying compared to partitioned views. I can do everything I can...
--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)

August 7, 2018 at 7:06 am

#2000585

Viewing 15 posts - 11,596 through 11,610 (of 59,099 total)