Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,621 through 22,635 (of 59,067 total)

RE: Find greatest value in a series of columns and select a related column value

mcinvalek (10/10/2014)
Table Structure
Camp1_ID, Camp1_Amt, Camp1_PCT, Camp2_Id, Camp2_Amt, Camp2_PCT....,Camp20_ID, Camp_20_Amt, Camp20_Pct
I need to search through the 'Camp_PCT' columns and find the max value, then select the cooresponding Camp_ID. If, 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)

October 10, 2014 at 4:37 pm

#1751762
RE: Improving Index Seek

UDBA (10/10/2014)
I have a query that is performing index seek on a large table and taking about 5 minutes, is it possible to further improve the attached index seek?
Look at...
--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 10, 2014 at 4:24 pm

#1751761
RE: Is html coding is allowed in sql server

jacksonandrew321 (10/10/2014)
Hi Experts
Is this possible to write html codes in the query window of the sql server? I have runned some codes and executed them and they successfully executed but...
--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 10, 2014 at 8:03 am

#1751648
RE: How can i use ouput of PowerShell script in SSRS without upload toSQL DB

nelly.kh (10/8/2014)
I'm new to SSRS 2008 R2. I have been using Report Builder 3.0 to design my reports with no problems .Now, I would like to use as sources output...
--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 9, 2014 at 7:49 am

#1751293
RE: SSRS and DB2 connection

I'm having a similar problem. I hope you're still around so that I can ask, "Did you ever solve this problem" and "How did you do it"?
Thanks.
--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 8, 2014 at 8:35 pm

#1751135
RE: Tools for graphical format

ZZartin (10/8/2014)
Well there's always excel.
... which is neither cheap nor free.
--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 8, 2014 at 11:49 am

#1751069
RE: Difference between ISE vs command line and out of memory

dpoquette (10/8/2014)
After making changes to the code, I'm not having any problems at all. Thanks for the help on the error trapping.
Please post the changes to the code so...
--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 8, 2014 at 11:47 am

#1751068
RE: Book example doesn't work, how come?

GilaMonster (10/7/2014)
The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000 databases any...
--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 7, 2014 at 7:51 pm

#1750813
RE: Performance of the new (2014) Cardinality Estimator

julian.fletcher (10/2/2014)
Has anybody had any experience (good or bad) with this? Microsoft's own documentation (http://msdn.microsoft.com/en-us/library/dn673537.aspx) hints at improvements while warning:
While many workloads will benefit from the new cardinality estimator changes,...
--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 7, 2014 at 7:50 pm

#1750812
RE: Work Pattern Calendar Tables

@itwhiz-2,
Are you all set or do you still need help?
--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 7, 2014 at 5:45 pm

#1750807
RE: Conversion of varchar to datetime

ramana3327 (10/7/2014)
It gave 2005. Sorry wrong place. I will post in the right place
Nah... no need now. Keep it here so that we don't lose any of the suggestions...
--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 7, 2014 at 5:32 pm

#1750806
RE: Help avoiding temp table with string of IDs passed into stored procedure

TheSQLGuru (10/7/2014)
Try your XML method under stress and see how it holds up. Or with lots of rows.
There are some very nice threads here on SSC.com about...
--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 7, 2014 at 5:25 pm

#1750805
RE: Why CTE should begin with semicolon or Go

I'll also add that you should start changing any code you touch for maintenance or any new code to include semi-colons for ALL statements that can take them because MS...
--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 7, 2014 at 9:29 am

#1750629
RE: Work Pattern Calendar Tables

itwhiz (10/5/2014)
Hi,
I need to prove that there is a speed issue with one of our stored procs/functions but to do this I need to create a large static work pattern...
--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 5, 2014 at 11:59 pm

#1750217
RE: Are the posted questions getting worse?

rodjkidd (10/5/2014)
Jeff Moden (10/4/2014)
rodjkidd (10/4/2014)
So in Utrecht, for SQL Sat Holland.
Early start, have coffee, seen some familiar faces, so going well so far!
Any one got a heckle for Grant? 🙂
Jeff...
--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 5, 2014 at 8:03 am

#1750185

Viewing 15 posts - 22,621 through 22,635 (of 59,067 total)