Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,701 through 26,715 (of 59,099 total)

RE: read registry w/o sysadmin, is it possible?

sporoy (1/9/2012)
Perry Whittle (1/6/2012)
granting permissions on the xp worked for me, i suspect the account trying to grant has insufficient permissions
In my case when I make the executing user sysadmin,...
--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 6, 2013 at 8:40 pm

#1621948
RE: Calculate Page number

rlouch (6/6/2013)
I have a table that I need to return with a dynamically calculated page number. The number of items on a page are not the same but 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 6, 2013 at 8:34 pm

#1621947
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Michael Meierruth (6/6/2013)
PS
Jeff, how long did it take you to unformat that sample code? Is there a tool to do that? 😀
If you're talking about the single line code example...
--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 6, 2013 at 5:57 pm

#1621944
RE: Fizz Buzz interview questions for phone screens?

Dird (6/6/2013)
Jeff Moden (6/6/2013)
Out of the last 20 developers I've interviewd, NONE of them has used a setbased method or a Tally Table. I can train people to 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 6, 2013 at 4:52 pm

#1621942
RE: Fizz Buzz interview questions for phone screens?

Heh... FizzBuzz... my old friend during interviews. I don't ask about FizzBuzz on phone interviews. I do use it as one of the questions on the pre-interview written...
--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 6, 2013 at 8:49 am

#1621771
RE: Fizz Buzz interview questions for phone screens?

Dird (6/5/2013)
Luis Cazares (6/5/2013)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
The problem with that is you'd have to create the table separately, when you...
--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 5, 2013 at 4:53 pm

#1621567
RE: Forum Etiquette: How to post data/code on a forum to get the best help

rphilips (6/5/2013)
Could you add another paragraph to the article with the directions for putting code in the scrolling window? It would be great to have those posting tips in 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 5, 2013 at 4:10 pm

#1621557
RE: Forum Etiquette: How to post data/code on a forum to get the best help

pchirags (6/5/2013)
Great article, Jeff..
Awesomely presented and well explained article about presenting and putting your question in correct way.
Thanks Jeff.
Thank you very much for the feedback. I appreciate 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 5, 2013 at 4:08 pm

#1621556
RE: SSIS - What is the best practice for creating a fixed length flat file.

Sigerson (6/5/2013)
I agree with both of you. I've used BCP and SSIS repeatedly. Each technique has its good uses and I probably should have mentioned that most...
--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 5, 2013 at 3:41 pm

#1621544
RE: SSIS - What is the best practice for creating a fixed length flat file.

MWise (6/5/2013)
Jeff, I hear what you are saying but the original question was about using SSIS. So that choice has already been made. If one of my developers...
--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 5, 2013 at 2:15 pm

#1621514
RE: Counting Days with Reset

David.Lester (6/5/2013)
After digging into the data, and learning more about the history of this, it appears that the business has changed the logic of this about every other year, 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)

June 5, 2013 at 1:19 pm

#1621492
RE: Forum Etiquette: How to post data/code on a forum to get the best help

aochss (6/5/2013)
All,
Good points everyone on the perils and pitfalls of getting a well formed question.
I would like to also add that when answering the questions that 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 5, 2013 at 1:16 pm

#1621489
RE: Help with next date in SQL query

Tyekhan (6/5/2013)
Tired that code again but still not working,
Randomizing ContactID's and CallDateTime's...
(1000000 row(s) affected)
Building/populating the #HistoryTest table...
Msg 208, Level 16, State 1, Line 19
Invalid object name 'AdventureWorks.Person.Contact'.
J Livingston SQL (6/5/2013)
that's...
--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 5, 2013 at 10:56 am

#1621426
RE: How to view individual records?

vxhughes (6/4/2013)
Hi, Jeff Moden -
Thanks for the tip; that's what I'll do.
The reason I didn't think of that is because I know NOTHING about SQL yet. You have to...
--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 4, 2013 at 5:04 pm

#1621148
RE: MSDB Huge, and Rapid Growth !!

Would it help if I showed you how to send emails without setting up email on a server?
--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 4, 2013 at 4:46 pm

#1621146

Viewing 15 posts - 26,701 through 26,715 (of 59,099 total)