Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,796 through 12,810 (of 59,095 total)

RE: Help me in designing table and its indexes

SQLAddict01 - Friday, March 2, 2018 3:07 PM

        

        
            
            
                        

            





Jason A. Long - Friday, March 2, 2018 12:57 PM









ManicStar - Friday, March 2, 2018 12: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)


                    

        
            March 2, 2018 at 1:04 pm
            #1981820

RE: Are the posted questions getting worse?

Sean Lange - Friday, March 2, 2018 9:47 AM

Lynn Pettis - Friday, March 2, 2018 9:43 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)

March 2, 2018 at 10:12 am

#1981798
RE: How does SQL Server handle concurrent operations?

junk.mail291276 - Thursday, March 1, 2018 4:23 PM

Oh, and I forgot to mention: sys.dm_exec_sessions confirms that it is our application session that's...

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

March 2, 2018 at 3:19 am

#1981749
RE: Best way to handle moving data in a varchar(max) field?

frederico_fonseca - Friday, March 2, 2018 2:29 AM

Jeff Moden - Thursday, March 1, 2018 7: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)

March 2, 2018 at 3:08 am

#1981747
RE: Best way to handle moving data in a varchar(max) field?

Heh... so what's wrong with a simple INSERT/SELECT???

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

March 1, 2018 at 7:38 pm

#1981730
RE: Introduction

TitusCrews - Thursday, March 1, 2018 2:23 AM

Not sure if anyone had done this already, so I just made this thread for...

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

March 1, 2018 at 6:52 pm

#1981729
RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

Luis Cazares - Wednesday, February 28, 2018 8:50 AM

drew.allen - Wednesday, February 28, 2018 8:42 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)

March 1, 2018 at 4:58 pm

#1981727
RE: FORMAT that string

Just in case a casual reader that doesn't know about the horrible performance of FORMAT reads this question, here's the reason why so many people on this discussion are saying...

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

March 1, 2018 at 3:42 pm

#1981718
RE: How to handle very large dataset

NineIron - Thursday, March 1, 2018 4:07 AM

I got some more information from the owner of the table and was able to...

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

March 1, 2018 at 7:40 am

#1981629
RE: Audit systems: a good idea or a mess to maintain?

peter.midgley - Thursday, March 1, 2018 2:06 AM

William Rayer - Thursday, March 1, 2018 1:27 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)

March 1, 2018 at 7:36 am

#1981628
RE: How would you lock down a SQL DBA to have local admin on the SQL box

Steve Jones - SSC Editor - Thursday, March 1, 2018 2:43 AM

Hmmm, OK. I tried this:

CREATE LOGIN JoeDBA with password...

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

March 1, 2018 at 7:33 am

#1981626
RE: Add Group ID value for set of sequential rows

drew.allen - Wednesday, February 28, 2018 7:53 AM

Jeff Moden - Tuesday, February 27, 2018 5:55 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)

February 28, 2018 at 3:21 pm

#1981569
RE: What Counts for a DBA – Inspirations

Brent Ozar - Wednesday, February 28, 2018 2:44 AM

Jeff Moden - Tuesday, February 27, 2018 8:03 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)

February 28, 2018 at 3:15 pm

#1981565
RE: Are the posted questions getting worse?

Sergiy - Wednesday, February 28, 2018 5:30 AM

Sean Lange - Tuesday, February 27, 2018 8:58 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)

February 28, 2018 at 3:11 pm

#1981564

Viewing 15 posts - 12,796 through 12,810 (of 59,095 total)