Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,326 through 11,340 (of 59,095 total)

RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 6:46 AM
Jeff Moden - Sunday, September 2, 2018 6: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)

September 2, 2018 at 7:52 am

#2004223
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 3:48 AM
andycadley - Sunday, September 2, 2018 2:33 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)

September 2, 2018 at 6:39 am

#2004216
RE: How to Generate a common unique column for multiple views

Naidu PK - Friday, August 31, 2018 2:36 PM
I created 3 different views and I need a common column to join these...
--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 1, 2018 at 8:14 pm

#2004207
RE: Balancing Writes

coolchaitu - Saturday, September 1, 2018 3:51 PM
SGT_squeequal - Saturday, September 1, 2018 3:38 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 1, 2018 at 7:57 pm

#2004206
RE: Code to list dates end of month dates between specific start and end date ranges

alexander.lummer - Friday, August 31, 2018 12:31 PM
Caps out at 100 rows where there should be more? this i would def hope...
--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 8:42 pm

#2004197
RE: [RESOLVED] How to cast string (with comma or/and decimal) to integer/decimal?

Instead of using expensive REPLACEs, you could always convert it to the MONEY datatype and then to DECIMAL. The MONEY datatype takes commas in stride.
--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 8:38 pm

#2004196
RE: The Game is Afoot

I'm glad that someone else still likes SQL Profiler. 😀
As for that 10-15% CPU thing? The only time I don't cringe at that is when a large batch...
--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 8:34 pm

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

Interesting... earlier today, I ran the following code and it said "Error near ONLINE" and would not execute.
ALTER TABLE dbo.Trans
ADD CONSTRAINT PK_Trans PRIMARY KEY CLUSTERED ([Iterator]) WITH (ONLINE =...
--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 8:05 pm

#2004194
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

Viewing 15 posts - 11,326 through 11,340 (of 59,095 total)