Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,906 through 22,920 (of 59,102 total)

RE: Convert Excel formula to SQL

davidmckee (8/19/2014)
This is the exact result...except it seems to be in MSSql...the web server runs MySql
I did some research after copying the code into the query and receiving errors...maybe this...
--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 19, 2014 at 9:19 pm

#1739456
RE: Grouping and Sorting challenge

Any feedback? Is there something missing?
--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 19, 2014 at 9:10 pm

#1739454
RE: High value of work files and Work table

WhiteLotus (8/19/2014)
GilaMonster (8/19/2014)
Firstly, is that value a problem? Is it higher than usual? Is it causing problems?
Thanks for your response! appreciate it !
Yes I use SOLARWIND to monitor SQL Performance...
--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 19, 2014 at 8:41 pm

#1739449
RE: Convert Excel formula to SQL

davidmckee (8/19/2014)
I connect to the server/table using phpMyAdmin[font="Arial Black"] I believe it is a MySQL database[/font]
Wellllll.... crud. I came up with something fun but now I don't know if...
--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 19, 2014 at 8:12 pm

#1739448
RE: present yyyymm in format good for calcuation

CELKO (8/19/2014)
5. Keep the rows short by using computed columns that are not materialized until needed for somethings. Overloading rows in a Calendar is a common problem.
Careful now... "It Depends"...
--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 19, 2014 at 5:58 pm

#1739440
RE: Artist or Scientist?

Gary Varga (8/19/2014)
Jeff in my experience most DBAs improving stored procedures or operational scripts do so with the purpose of refinement and optimisation (performance, resource usage, etc.), however, most 3GL...
--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 19, 2014 at 5:19 pm

#1739430
RE: Coalesce in query

The comments in the code will prove helpful...
--===== Create and populate a test table on the fly.
-- This is NOT a part of the solution....
--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 19, 2014 at 5:10 pm

#1739428
RE: Artist or Scientist?

vliet (8/19/2014)
For most forms of art, even a (trained) spectator can see the difference between a craftsman and a dabbler.
That's the comparison that I would have made instead of "artist...
--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 19, 2014 at 4:46 pm

#1739424
RE: Artist or Scientist?

crussell-931424 (8/19/2014)
What drives me crazy are the programmers that always seem to want to make the code better, improve it, optimize it, when it is running just fine now. 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 19, 2014 at 4:42 pm

#1739423
RE: Finding special characters within character strings

wes_springob (8/19/2014)
You say you run this every morning? Why not just set up a constraint on the column to prevent the problem characters from getting in, in the first place?
Heh......
--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 19, 2014 at 8:24 am

#1739237
RE: Is It Time To Clear Out Those Quirky Functions?

I'd almost rather MS stopped trying to improve T-SQL because they either leave out critical functionality of new features, deprecate and delete useful stuff, or things run slower than "Black...
--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 19, 2014 at 8:07 am

#1739230
RE: Denormalized XML File

ringovski (8/18/2014)
I have altered the XSL code\file and have managed to get columns in 4 outputs, item, Items, invoice, invoices.
...{snip}...
Though the objective is to try the four outputs 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 18, 2014 at 7:08 pm

#1739072
RE: Same database on multiple cluster nodes for performance?

protix (8/18/2014)
Well, I'm interested in the performance mainly.
If that's true, then look into the code. SQL Server is VERY well equipped to handle some very high loads. ...
--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 18, 2014 at 6:52 pm

#1739071
RE: Running out of space on the data drive.

pssudarshan (8/18/2014)
Table partitioning - one of the solutions suggested above really had me excited for a minute. Then I realized that we were on SQL 2005 Std edition 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)

August 18, 2014 at 4:14 pm

#1739055
RE: DYNAMICS Pivot Function

Yep. Use the ACE drivers and OPENROWSET.
--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 16, 2014 at 3:21 pm

#1738645

Viewing 15 posts - 22,906 through 22,920 (of 59,102 total)