Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,686 through 32,700 (of 59,099 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/29/2011)
Anyone see plagiarism here:
http://www.sqlservercentral.com/articles/context_info()/74332/
http://www.thecodepage.com/post/TIP-A-Call-Stack-in-SQL-Server.aspx
I wish I could say "Yes" to try to help the person feeling infringed upon but, No I don't. Not...
--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 29, 2011 at 9:17 pm

#1374801
RE: Are the posted questions getting worse?

GilaMonster (8/29/2011)
Jeff Moden (8/29/2011)
GilaMonster (8/29/2011)
mtillman-921105 (8/29/2011)
But communism is not seriously considered a real option anymore.
Come down and tell some people in government here that. It would come as 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)

August 29, 2011 at 7:33 pm

#1374791
RE: Are the posted questions getting worse?

Agreed... I should have been a bit more specific, Tom.
--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 29, 2011 at 7:22 pm

#1374788
RE: Running totals

Alright... I'm trying to simulate what you might have for data just to be sure performance is ok so I need to ask just a couple of more questions.
On average...
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 29, 2011 at 7:18 pm

#1374787
RE: Build string from passed parameters

You only need 1 SELECT. Since you're also just checking for NULL values, you also don't need any CASE statements.
DECLARE @Name ...
--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 29, 2011 at 4:35 pm

#1374767
RE: Are the posted questions getting worse?

GilaMonster (8/29/2011)
mtillman-921105 (8/29/2011)
But communism is not seriously considered a real option anymore.
Come down and tell some people in government here that. It would come as a revelation to them.
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)

August 29, 2011 at 2:54 pm

#1374736
RE: Running totals

Perfect. Now that I have that information, this is actually a fairly simple task. I'll work on it after work tonight.
--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 29, 2011 at 11:03 am

#1374593
RE: varbinary(float) to int

That's kind of what I'm suggesting, Henrik.
--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 29, 2011 at 8:30 am

#1374504
RE: Are the posted questions getting worse?

GilaMonster (8/29/2011)
Brandie Tarvin (8/29/2011)
Jeff, it is totally worth it to make the effort. Not a lot of copyright thieves will come back and assert "their rights," only the really crooked...
--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 29, 2011 at 8:26 am

#1374502
RE: SQL 2008 - T-SQL query assistance

My opinion there is quite a bit different. You still have to write some pretty nasty stuff to effectively use the HierarchyID especially compared to using the Nested Set...
--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 29, 2011 at 8:22 am

#1374498
RE: change names on the tables

Unless there's a pattern to the names, no.
--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 28, 2011 at 9:37 pm

#1374364
RE: Are the posted questions getting worse?

Understood, but the infringer needs only file a counter notice and "boom", the ISP has to put the material back within 10-14 days. Sure, that's done under penalty 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 28, 2011 at 7:17 pm

#1374361
RE: varbinary(float) to int

henrik staun poulsen (8/24/2011)
Hi Jeff,
Well, yes that might be true. But my meta data says that it is a float. So my transform job crashed.
With my improvement, the code continues...
--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 28, 2011 at 6:52 pm

#1374359
RE: View vs Ad-hoc T-SQL

uncle_boris (8/23/2011)
Unfortunately I do not know the technique or protocol to display two execution plans in this forum so they are viewable.
Run the code with the "Actual Execution Plan" turned...
--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 28, 2011 at 6:47 pm

#1374358
RE: The Talent Crunch

Lynn Pettis (8/24/2011)
Jeff Moden (8/23/2011)
IceDread (8/23/2011)
Hehe, getdate() however reads the clock from windows and if you change that one you are screwed.. that sql server relies on the os operated...
--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 28, 2011 at 5:30 pm

#1374353

Viewing 15 posts - 32,686 through 32,700 (of 59,099 total)