Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,341 through 11,355 (of 59,102 total)

RE: Interesting question about NCI's when converting HEAPs to CI's

frederico_fonseca - Friday, August 31, 2018 12:22 PM
Jeff Moden - Friday, August 31, 2018 11:52 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 31, 2018 at 7:38 pm

#2004193
RE: Interesting question about NCI's when converting HEAPs to CI's

Heh... Crud. It turns out this is a moot point. They don't want "just" a Not Null column with a Unique Clustered Index... they actually want a Primary Key CONSTRAINT...
--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 31, 2018 at 11:52 am

#2004161
RE: 70-762 Developing SQL Databases

Lowell - Friday, August 31, 2018 9:16 AM
I've gone through the effort to get some certs,and i will not bore anyone with...
--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 31, 2018 at 10:48 am

#2004157
RE: Displaying Hierarchical Data

Mike Is Here - Friday, August 31, 2018 9:10 AM
RonKyle - Friday, August 31, 2018 7:37...
--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 31, 2018 at 10:41 am

#2004156
RE: 70-762 Developing SQL Databases

firman_gary - Friday, August 31, 2018 12:11 AM
There are so many site online, my colleague passed his SQL Server certification last month,...
--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 31, 2018 at 6:54 am

#2004124
RE: SQL Server Accidental DBA Skills

zech 55624 - Thursday, August 30, 2018 9:58 AM
Hi all. I'm not sure the best place to post this, so let me...
--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 31, 2018 at 6:11 am

#2004121
RE: Are the posted questions getting worse?

Luis Cazares - Thursday, August 30, 2018 3:28 PM
This is one of the weirdest required skills I've seen in a job posting....
--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 30, 2018 at 5:43 pm

#2004091
RE: Interesting question about NCI's when converting HEAPs to CI's

Heh.... I was trying to avoid that because 1) I don't have any other HEAPs, 2) I didn't want to take the time to make one, and 3) the reason...
--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 30, 2018 at 5:36 pm

#2004090
RE: Interesting question about NCI's when converting HEAPs to CI's

Joe Torre - Thursday, August 30, 2018 3:55 PM
Warning
You will...
--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 30, 2018 at 4:04 pm

#2004086
RE: Need to write query with conditioms

Please see the first link under "Helpful Links" in my signature line below for posting methods that will help us help you better and more quickly.
--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 30, 2018 at 2:27 pm

#2004078
RE: Should I create a Staging Instance or Staging Database on the same Production Server? (Can only do SAME PRODUCTION SERVER)

Chris Harshman - Thursday, August 30, 2018 12:02 PM
If this staging database would only be for ETL type purposes, I think 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)

August 30, 2018 at 2:24 pm

#2004077
RE: Indexing the PO

Lynn Pettis - Thursday, August 30, 2018 12:12 PM
Jeff Moden - Thursday, August 30, 2018 11: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 30, 2018 at 1:39 pm

#2004074
RE: Indexing the PO

Heh... everytime I'm reminded of this, I end up asking myself... who would index a non-persisted column?
--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 30, 2018 at 11:39 am

#2004058
RE: Displaying Hierarchical Data

Larry Gilbert-474089 - Thursday, August 30, 2018 7:38 AM
Where's the correct staff table? The one listed has no StaffID or ManagerID.
If you...
--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 30, 2018 at 8:25 am

#2004010
RE: index scan where seek expected

jontris - Thursday, August 30, 2018 3:13 AM
@jeff, my 'earlier posts' were different posts and I was trying to be tongue-in cheek...
--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 30, 2018 at 8:19 am

#2004009

Viewing 15 posts - 11,341 through 11,355 (of 59,102 total)