Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,166 through 42,180 (of 59,067 total)

RE: WORD UP!

CirquedeSQLeil (8/27/2009)
Ever thought of upgrading to a previous version. Sorry guys - not a fan of Office 2007, ribbons and frilly things - yuck.:-D
Man, do I agree with THAT!...
--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 27, 2009 at 12:46 pm

#1045799
RE: WORD UP!

crookj (8/27/2009)
Another thing I came across is...
Make sure that you have a licensed software version and that it has been activated.
Still looking.....
Joe
Thanks. Just to assure everyone, I'm so honest...
--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 27, 2009 at 12:11 pm

#1045767
RE: Creating tables on tempdb. is it a good idea

I think it's a bad idea because what will happen if two instances of your code are executed at the same time?
--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 27, 2009 at 11:52 am

#1045753
RE: How to decide to aggregate data in SQL Server or in Report Server

There's really only one way to know for sure... try both with Profiler running. Select the one that uses the fewest resources for CPU and Reads. Both should...
--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 27, 2009 at 11:28 am

#1045726
RE: When will the next 13th fall on a Friday?

Rimvydas Gurskis (8/27/2009)
How about set-based approach:
SET DATEFIRST 1
;WITH days(Date) AS
(
--Get 13th of this month
SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)
UNION ALL
--Get 13th...
--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 27, 2009 at 8:29 am

#1045572
RE: Are the posted questions getting worse?

Elliott W (8/26/2009)
Do none of these people know how to google a problem before they post? I've had a couple that their resolution was already posted in another thread...
--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 26, 2009 at 10:11 pm

#1045323
RE: First run of a query takes much longer

glu (8/26/2009)
Lynn is right. After I run
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
the query took 32 seconds, the next run 6 seconds. execution plan takes 1 seconds, recompile takes...
--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 26, 2009 at 10:08 pm

#1045322
RE: Storing IPv4 Addresses for Performance

Elliott W (8/25/2009)
Good point... No flames... just thoughts.... If all you intend to do is split the octets, then the six line T-SQL solution that uses PARSENAME is almost as...
--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 26, 2009 at 12:31 am

#1044703
RE: Overselling Yourself

Steve, great editorial, as usual. My recent bout with folks that have been copying my articles as my own has led me to take one extra step on 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)

August 25, 2009 at 11:00 pm

#1044673
RE: Overselling Yourself

sjsubscribe (8/25/2009)
This has been a perpetual problem for govt employment. For some jobs we could not even acknowledge product familiarity much less evaluate or offer critical advice. So most 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 25, 2009 at 10:25 pm

#1044660
RE: Sending multiple rows to the Database from an Application: Part II

Need to pass as many delimited strings as the number of parameters.
Not true... please consider the following...
http://www.sqlservercentral.com/articles/T-SQL/63003/
Since, delimited string would be passed as a string data type, so limitation...
--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 25, 2009 at 8:50 pm

#1044640
RE: Are the posted questions getting worse?

RBarryYoung (8/25/2009)
Steve Jones - Editor (8/23/2009)
I don't have a personal blacklist, but I'm happy to walk away from a post/thread if someone can't respond or maintain a sense of decorum.
and...
--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 25, 2009 at 7:14 pm

#1044624
RE: Storing IPv4 Addresses for Performance

Elliott W (8/25/2009)
Guys, I just got to thinking about this, but it seems this kind of conversion is right up SQLCLR's alley, once it is in memory I would think...
--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 25, 2009 at 6:36 pm

#1044617
RE: WORD UP!

No, not yet. Still have too many fires with sticks in them. :hehe:
--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 25, 2009 at 10:48 am

#1044358
RE: find the position of the charcter in delimited string

Bob Hovious (8/25/2009)
Most of the credit goes to Jeff. He taught me everything I know about Tally tables.
:blush: Thanks, Bob. I really appreciate the kudo. ...
--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 25, 2009 at 7:57 am

#1044190

Viewing 15 posts - 42,166 through 42,180 (of 59,067 total)