Jeff Moden

Forum Replies Created

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

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
RE: Representing XML data in SQL Server

This is a nicely written article. Just as a suggestion for future articles, it would have been great if you identified where you got the Sales and SaleItems data from or...
--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 6:37 am

#2000578
RE: Rows into dynamic columns

Nicely documented, Jason. You should write articles.
--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 5:59 am

#2000564
RE: SQL Database Documentation

Charles_P - Monday, August 6, 2018 9:21 PM
Thank you both. Good advice. I tried the database diagram and it is very useful. ...
--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 5:56 am

#2000563
RE: SQL Database Documentation

Tim,
I don't know about anyone else but that came out looking like a very strange language. Not sure what font you uses but there's a one to one character...
--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 5:54 am

#2000562

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