Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,016 through 24,030 (of 59,102 total)

RE: Help need in Avoiding Loop

Let's turn this into a thinking lesson on "Divide'n'Conquer" methods. To do that, you have to think in columns instead of rows and you have to think about accomplishing...
--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)

April 1, 2014 at 7:50 pm

#1702303
RE: Ideal table for Memory Optimization ?

GilaMonster (4/1/2014)
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's not 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)

April 1, 2014 at 6:32 pm

#1702296
RE: Nesting xml

Eirikur Eiriksson (4/1/2014)
Please post proper DDL and enough data, the problem is straight forward from there.
If you're going to tell people that, then you need to tell them what "proper...
--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)

April 1, 2014 at 4:29 pm

#1702280
RE: sp_send_dbmail has formatting off on datetime when directing output to csv file

I think your biggest problem is that you're using a .xls extension on the file. It's NOT an Excel file. Also, if someone opens even a text file...
--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)

April 1, 2014 at 4:26 pm

#1702276
RE: Get the hierarchy orders(top to bottom) of the table

My question would be, why do people insist on storing hierarchical data in multiple tables? It's usually SO much easier to store/maintain the data as a single adjacency list...
--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)

April 1, 2014 at 3:59 pm

#1702270
RE: Error-CreateProcessAsUser on xp_cmdshell

Satheesh E.P. (4/1/2014)
XP_cmdshell is working fine in our environment with a non-sysadmin account.
I don't know about your specific problem but I have to tell you that giving a non-sysadmin account...
--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)

April 1, 2014 at 3:55 pm

#1702267
RE: Copy DB from Prod to QA

New Born DBA (3/31/2014)
I did run into some problems and I am wondering if someone can tell me what to do.
I was unable to restore the DB because the DB...
--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)

April 1, 2014 at 7:55 am

#1702043
RE: X in Technology

Stephanie J Brown (3/31/2014)
I think what skeleton567 may be trying to say is that the NAME of the group perpetuates stereotypes. [font="Arial Black"]If instead of "Women in Technology" the...
--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)

April 1, 2014 at 7:47 am

#1702035
RE: Are the posted questions getting worse?

jasona.work (4/1/2014)
Grant Fritchey (4/1/2014)
jasona.work (4/1/2014)
April 1st, the day when the internet loses its collective mind (did it ever have it to begin with?) and starts throwing out "jokes" (term used...
--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)

April 1, 2014 at 7:25 am

#1702017
RE: Converting sequential time records into IN and OUT times

Thanks for the feedback. It'll let me get some sleep tonight because I was seriously trying to think of an easy way to handle that computationally but I've been...
--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 31, 2014 at 10:50 pm

#1701878
RE: DELETE FIRST 1000 ROWS

While some of the methods posted are ok, there's still the fundamental problem...
shashianireddy (3/29/2014)
I WANT DELETE FIRST 1000 ROWS IN SQL TABLE ............................
... of not knowing what the first...
--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 31, 2014 at 10:25 am

#1701687
RE: Converting sequential time records into IN and OUT times

Thanks for the feedback.
Two things, though...
1. You're the one that has to support it. Do you understand how it works?
2. I'm also still greatly concerned about the...
--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 31, 2014 at 10:17 am

#1701682
RE: The Perfect Environment

To be honest, a "perfect environment" has nothing to do with the hardware, software, revisions, or infrastructure for me. For me, a "perfect environment" is having good, knowledgeable people...
--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 31, 2014 at 10:13 am

#1701680
RE: Like operator - Query performance issue

gsaini 95591 (3/31/2014)
Partitions would be helpful.Then you could also restrict conditions in where clause
We're talking about a leading wildcard in 12 different columns. As the others have suggested, parititioning...
--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 31, 2014 at 10:07 am

#1701675
RE: Batch Delete is Slow :angry:

There is absolutely no need to use SET ROWCOUNT in SQL Server 2000. SELECT TOP works just fine except that you can't use a variable to define the TOP...
--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 30, 2014 at 8:53 pm

#1701459

Viewing 15 posts - 24,016 through 24,030 (of 59,102 total)