Jeff Moden

Forum Replies Created

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

RE: Help me in designing table and its indexes

DesNorton - Saturday, March 3, 2018 1:00 PM
I would also consider separating Directories and Files into their own tables.
I'll suggest against putting...
--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 3, 2018 at 5:52 pm

#1981864
RE: Breaking into SQL Development job with irrelevant degree

evaslash - Friday, March 2, 2018 8:05 PM
I am looking to getting into a career as a database developer....
--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 3, 2018 at 8:35 am

#1981848
RE: updates are not happening through ssms

dastagiri16 - Saturday, March 3, 2018 6:40 AM
Phil Parkin - Saturday, March 3, 2018 6:26 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 3, 2018 at 8:13 am

#1981846
RE: How to bring database just before the delete occurred.

coolchaitu - Saturday, March 3, 2018 6:52 AM
GilaMonster - Saturday, March 3, 2018 6:30 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 3, 2018 at 7:56 am

#1981844

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

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