Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,311 through 20,325 (of 59,098 total)

RE: Need Ammunition for Developers Doing Select *'s

Nadrek (6/19/2015)
Jeff Moden (6/18/2015)
...
if you can't prove it with code, there is no argument.
...
I believe that part of proving it with code is having valid, reliable measurements. Another...
--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)

June 19, 2015 at 8:46 am

#1806713
RE: EXCEL HELL!!!

h540663 (6/19/2015)
Good to see someone else has come to the conculsion I came to years ago. Besides, after 15 years of SQL I am still learning and damned if I'm...
--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)

June 19, 2015 at 8:34 am

#1806709
RE: Tricky hierarchy question

lewisdow123 (6/19/2015)
Hi,
I have reposted in here... http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx
Thanks
You really need to stop multi-threading. You should have posted your corrected data on this thread so that others can see the "development"...
--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)

June 19, 2015 at 8:25 am

#1806702
RE: Tricky hierarchy query

lewisdow123 (6/19/2015)
I could kick myself, I am running 2008 R2... so sorry
Heh... not to worry. We wanna kick you, too! 😀
Here's a solution that will work in 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)

June 19, 2015 at 8:23 am

#1806701
RE: EXCEL HELL!!!

pharryecoenen (6/19/2015)
Hi Jeff
Thanks for your reply.
I've seen your stuff at detroit.sqlpass.org and as usual learned a few tricks from it, before trying it.
Works great on 2008R2 after replacing (local)...
--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)

June 19, 2015 at 7:16 am

#1806663
RE: Error converting data type varchar to numeric

Minnu (6/17/2015)
Team
As per my requirment using below script to convert from varchar to numeric.
declare @stg varchar(50)
set @stg='12,000,00'
select CONVERT(NUMERIC(17,2),@stg)
getting error : Error converting data type varchar to numeric
Please help..
If the answer...
--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)

June 18, 2015 at 11:52 pm

#1806586
RE: Interactive sort on a text field having decimal numbers

rockstar283 (6/18/2015)
I have the following text field in SSRS report:
Version
2.0.0.0
1.0.0.0
1.2.0.0
2.1.8.8
...
--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)

June 18, 2015 at 11:46 pm

#1806585
RE: Need Ammunition for Developers Doing Select *'s

ZZartin (6/18/2015)
I'm also not going to listen to a dev without a strong DB background try to defend bad coding standards just because he's lazy.
That's precisely what I was talking...
--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)

June 18, 2015 at 9:44 pm

#1806581
RE: EXCEL HELL!!!

pharryecoenen (6/18/2015)
My conclusion thus far: you can go a long way using openrowset, and the excel files as they arrive, but it all depends, and if I have to open...
--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)

June 18, 2015 at 9:02 pm

#1806579
RE: "Automatic" partitioning

craig.g.smith (6/17/2015)
A common partitioning scenario is when the partition column has the same value for every record in the partition, as opposed to a range of values. Am 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)

June 18, 2015 at 1:56 pm

#1806514
RE: Tricky hierarchy question

Does the real "original" table actually have 5 columns in a manner similar to what your first table is or does it "just" have a "Parent" and "Child" column?
--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)

June 18, 2015 at 1:48 pm

#1806509
RE: A Syntax Mystery in a Previously Working Procedure

I don't know why this article only got 3 stars. I'll admit that I didn't do a deep dive on the article (I'm familiar with the problem) but 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)

June 18, 2015 at 7:57 am

#1806378
RE: Are the posted questions getting worse?

Sean Lange (6/17/2015)
BL0B_EATER (6/17/2015)
Brandie Tarvin (6/17/2015)
O. M. G.
You MUST read this link here.
I'm in stitches here.
Number 8 had me, having 2 under 2.5 years of age makes me feel like...
--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)

June 18, 2015 at 7:37 am

#1806367
RE: Question about xp_dirtree Procedure

Understood on the xp_CmdShell thing. I was trying to give you fuel for your fire but there's a lot of overwhelming FUD out there and some companies just flat...
--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)

June 18, 2015 at 7:25 am

#1806363
RE: Bulk inserts in batch

craig.g.smith (6/17/2015)
The other reason I thought about just using the date is I'd really like to partition this table on that date.
That was going to be my next recommendation. ...
--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)

June 17, 2015 at 11:27 pm

#1806260

Viewing 15 posts - 20,311 through 20,325 (of 59,098 total)