Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,891 through 22,905 (of 59,067 total)

RE: Inline syntax for indexes

GilaMonster (8/12/2014)
The inline syntax is needed for hekaton tables because they're like table vars in that once created they cannot be changed. The fact that it works on normal tables...
--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 15, 2014 at 6:42 pm

#1738600
RE: PIVOT without aggregate function?

serviceaellis (8/15/2014)
I don't. I used the title that the link I found I posted states.
Just went with it.
I know that in Access you can do first or last as Value...
--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 15, 2014 at 4:24 pm

#1738587
RE: PIVOT without aggregate function?

@serviceaellis,
Why on Earth do you need to do this without aggregates? As JeeTee and some of the others have pointed out, it's one of the more efficient methods in...
--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 15, 2014 at 4:12 pm

#1738580
RE: PIVOT without aggregate function?

JeeTee (8/15/2014)
Of course max() is aggregation; I don't think that was ever in question. However for the purposes of what's trying to be accomplished here, using max() in the context...
--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 15, 2014 at 4:09 pm

#1738579
RE: PIVOT without aggregate function?

I can't speak for anyone else but I consider MAX to be a form of "aggregation" even when it applies to character based values.
--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 15, 2014 at 2:58 pm

#1738553
RE: Assign Row number to the result set without using Row_Number

GilaMonster (8/15/2014)
Eirikur Eiriksson (8/15/2014)
Koen Verbeeck (8/15/2014)
GilaMonster (8/15/2014)
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number,...
--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 15, 2014 at 1:36 pm

#1738531
RE: SQL DBA high ended question (5+ years’ experience)

Brandie Tarvin (8/15/2014)
GilaMonster (8/11/2014)
paul.knibbs (8/11/2014)
Jeff Moden (8/9/2014)
With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia,...
--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 15, 2014 at 1:31 pm

#1738526
RE: query with several joins fills up tempdb and won't finish

It might be just me but the exec plan you attached returns a blank page for me even if I save the file and try to open it.
--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 15, 2014 at 12:29 am

#1738288
RE: Can't find error message when trigger fires

So take the commit out of the Catch Block. If you really want to use an explicit transaction in the trigger code, do the commit at the end of...
--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 14, 2014 at 10:49 pm

#1738280
RE: Alerting when tempdb files have X% free space

Jay@Work (8/14/2014)
I've actually emailed Paul on this very topic as when it comes to SQL knowledge I'd believe him if he told me that putting my head in the oven...
--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 14, 2014 at 10:08 pm

#1738278
RE: Alerting when tempdb files have X% free space

Jay@Work (8/14/2014)
Thanks Jeff.
Have your tempDB files ever had to autogrow or were they created with an initial size large enough that this hasn't been necessary?
Our Sharepoint consultants advised the 1...
--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 14, 2014 at 10:06 pm

#1738277
RE: query with several joins fills up tempdb and won't finish

NoDBA (8/14/2014)
Since this report is only for testing purposes as of now, that suffices.
Possibly not. It may actually be that the query never got to the ORDER BY. ...
--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 14, 2014 at 6:45 pm

#1738251
RE: Assign Row number to the result set without using Row_Number

Indu-649576 (8/14/2014)
Hi,
Is there any other way to assign row number to the result set with out using Row_Number/rank/Dense rank functions or loops?
Thanks,
Indu
Yes... there is. How many rows in 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)

August 14, 2014 at 6:38 pm

#1738248
RE: Disable and Enable Constraints in a Table in SQL Server

Mr. Kapsicum (8/14/2014)
Hi All,
I have a Table, on which i am performing Bulk Insert Operations. For This,
i am First Disabling Constraints on that table and After Insert Operation , i...
--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 14, 2014 at 6:25 pm

#1738247
RE: SQL Query to find all the employee whose salary sum is 80% of sum of salary of all employee.

akash_singh (8/14/2014)
Let us assume that there are 100 employee in a company. And sum of salary of all employee is 10000. Find list of highest paid employees whose sum of...
--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 14, 2014 at 6:22 pm

#1738246

Viewing 15 posts - 22,891 through 22,905 (of 59,067 total)