Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,421 through 33,435 (of 59,099 total)

RE: Passed My Exam

mikes84 (6/30/2011)
I'm not sure anyone really cares, but I earned my
MCTS: SQL Server 2008, Database Development
certification today. It took a lot of studying as many of you know, 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)

June 30, 2011 at 8:21 pm

#1346830
RE: Generate all possible characters for UNICODE using SQL Script

j.miner (6/30/2011)
🙂
Hi Jeff & Lowell,
All and all, it is cool stuff and I have squirelled the E16 example away.
I will have to remember to use it in the real world.
-John
Start...
--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 30, 2011 at 3:17 pm

#1346779
RE: Are the posted questions getting worse?

Grant Fritchey (6/30/2011)
SQLkiwi (6/30/2011)
Trey Staker (6/29/2011)
I wish there were ratings on posts, maybe a thumbs up or down on answers like on Ask SCC.
Interesting idea. One effect might be...
--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 30, 2011 at 3:14 pm

#1346774
RE: Are the posted questions getting worse?

jcrawf02 (6/30/2011)
Gianluca Sartori (6/29/2011)
One of the worst Celko posts ever.
He must have stepped on dog poop today.
Do me a favor, and translate that to Italian in your post? That's hilarious...
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 30, 2011 at 3:09 pm

#1346770
RE: Generate all possible characters for UNICODE using SQL Script

j.miner (6/30/2011)
Hi Jeff,
I think you presented Tally Tables at the SQL Server Users Group in Southern New England last summer.
Nope... You guys already had a speaker. I was just...
--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 30, 2011 at 8:12 am

#1346565
RE: Generate all possible characters for UNICODE using SQL Script

Lowell (6/30/2011)
also, using sys.columns is just an easy way to find a lot of items;
if you doi this:
--SQL 2005= 419
--SQL 2008= 483
select count(*) from model.sys.columns
that shows me that on...
--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 30, 2011 at 8:03 am

#1346553
RE: Generate all possible characters for UNICODE using SQL Script

j.miner (6/30/2011)
I converted the complicated tally table example into a while loop and stored the characters into a table.
What makes you think the Tally table example is so "complicated" compared...
--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 30, 2011 at 6:11 am

#1346459
RE: Round a number to lower bound

Bhogadi (6/29/2011)
Hi All,
Would like to round number to lower bound instead of upper bound in SQL.
Example: round(xxx.555,2) is retruning xxx.56. I want get result as xxx.55.
Thanks in Advance.
Please lookup 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 29, 2011 at 7:18 pm

#1346307
RE: Symantec Backup Exec

As a side bar, I don't backup to tape. I backup to disk and then back that up. It makes life a little more convenient for me.
--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 29, 2011 at 7:05 pm

#1346306
RE: Update Query

CELKO (6/29/2011)
You also have no idea what ISO-11179 naming rules for data elements are. {snip} In RDBMS, data elements are universal and need exact names
UPDATE Foobar
...
--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 29, 2011 at 6:58 pm

#1346304
RE: Efficient ways to reset lost sql sa password

duocaiduoyi2009 (6/28/2011)
Thanks a lot for your guys sharing.
i am a newbie, i would like to recommend one software named SQL password recovery to those novices.
Just several clicks, you can reset...
--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 28, 2011 at 8:19 pm

#1345613
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/26/2011)
Jeff Moden (6/26/2011)
They're very useful for things other than xp_CmdShell. A simple example is where you want someone to use a proc that truncates a real table...
--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 28, 2011 at 8:08 pm

#1345612
RE: Code Ownership - DBA vs. Developer

Craig Farrell (6/28/2011)
Here's where that concept gets caught. Yes, YOU as a DBA may own your server's code. I know many, including myself depending on the environment, who don't.
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)

June 28, 2011 at 7:52 pm

#1345609
RE: Combining Multiple Records Into One

Readability? Absolutely. You'll get no argument from me there.
Performance? I gotta go with a "maybe" (or at least IMHO :-P). On another link, you said it...
--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 28, 2011 at 7:43 pm

#1345608
RE: Are the posted questions getting worse?

Gianluca Sartori (6/28/2011)
Yeah! 3000 points for me!
It's a small step for most of you, it's a great step for me.
Way to go, Gianluca! 🙂
--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 28, 2011 at 6:35 pm

#1345598

Viewing 15 posts - 33,421 through 33,435 (of 59,099 total)