Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,831 through 10,845 (of 59,095 total)

RE: Index space

WhiteLotus - Wednesday, October 24, 2018 12:34 AM
Hi Guys
--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)

October 24, 2018 at 9:33 am

#2010964

RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

Thom A - Friday, October 5, 2018 7:51 AM

SQL Server has a FORMAT function, so if you were doing this with a...

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

October 24, 2018 at 9:21 am

#2010958

RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

I have to agree with Drew. I won't even post the FORMAT function as a possible solution until they fix the performance issues. I may, however, start off a posted...

--Jeff Moden

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)

October 24, 2018 at 7:10 am

#2010918

RE: Naming Conventions for SQL Server Objects

Jonathan AC Roberts - Wednesday, October 24, 2018 5:28 AM

andrew gothard - Wednesday, October 24, 2018 5:10...

--Jeff Moden

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)

October 24, 2018 at 7:05 am

#2010917

RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, October 24, 2018 6:02 AM

jasona.work - Wednesday, October 24, 2018 5:56 AM

--Jeff Moden

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)

October 24, 2018 at 6:15 am

#2010911

RE: Quitting Over Training

Sean Redmond - Wednesday, October 24, 2018 5:06 AM

I've often wondered as to whether the model of offering university students (or even...

--Jeff Moden

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)

October 24, 2018 at 6:05 am

#2010910

RE: Deleting data from a table ... quickly

Eddie Wuerch - Tuesday, October 23, 2018 8:10 PM

If you partition the table on the @@SPID value, then you don't need any...

--Jeff Moden

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)

October 23, 2018 at 8:29 pm

#2010880

RE: Running Concatenation (like running totals)

etl2016 - Tuesday, October 23, 2018 1:52 PM

many thanks for the replies.

The limitations I have is the DB I am working on...

--Jeff Moden

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)

October 23, 2018 at 7:06 pm

#2010875

RE: Quitting Over Training

I've actually run into people that have had training funds provided to them by the company that they work for and they don't go for training. Their excuse is...

--Jeff Moden

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)

October 23, 2018 at 6:53 pm

#2010874