Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,051 through 43,065 (of 59,102 total)

RE: Create a Tally or Numbers Table

I'd have a hard time doing that because Number is a reserved word but to each their own. Also, are you implying that you have two separate tables? ...
--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)

July 14, 2009 at 4:59 am

#1024315
RE: Are the posted questions getting worse?

Matt Miller (7/13/2009)
Jeff Moden (7/13/2009)
Dave Ballantyne (7/13/2009)
You can lead a horse to water but you cant force him to drink
Heh... well... you can if you don't mind getting your lips...
--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)

July 14, 2009 at 4:44 am

#1024310
RE: Update where field is NULL

On most systems, you cannot say WHERE something NULL... instead, you usually have to say WHERE something IS NOT NULL or WHERE something IS NULL depending on what you're...
--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)

July 13, 2009 at 10:27 am

#1024027
RE: Are the posted questions getting worse?

Dave Ballantyne (7/13/2009)
You can lead a horse to water but you cant force him to drink
Heh... well... you can if you don't mind getting your lips dirty. I'm going...
--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)

July 13, 2009 at 8:59 am

#1023937
RE: Split string using XML

Eralper (7/10/2009)
Actually, I made a simple test to see that the xml function is quicker.
Actually, let's see THAT test. 😉 I already posted mine.
--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)

July 13, 2009 at 8:24 am

#1023910
RE: Split string using XML

Kindred spirit, Goldie. 🙂
--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)

July 13, 2009 at 8:13 am

#1023900
RE: The Worst Advice

rf44 (7/12/2009)
Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL 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)

July 13, 2009 at 6:55 am

#1023838
RE: The Worst Advice

rf44 (7/11/2009)
Answering "never, ever use a cursor" or something equally smart.
The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked for...
--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)

July 12, 2009 at 7:57 am

#1023612
RE: The Worst Advice

Dave Ballantyne (7/11/2009)
Only heard it once , but it was from a trainer on a vb .net course from one of the largest training companies in the uk.
Dont use...
--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)

July 12, 2009 at 7:49 am

#1023611
RE: The Worst Advice

Charles Kincaid (7/10/2009)
If you got Jeff, Joe, Andy, Phil, and Steve in a a single room the angels would not commence singing and no sparkly glowing would start.
Heh... I 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)

July 10, 2009 at 4:48 pm

#1023426
RE: Are the posted questions getting worse?

Paul White (7/10/2009)
Sometimes, MVP = Mighty Vacuous Post
Thread Link
So I couldn't resist - sue me! :laugh:
Heh... there are 10 types of MVP's... those that know, and those that don't. ...
--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)

July 10, 2009 at 9:54 am

#1023169
RE: DBCC IND - how can I run it when there is a locked row in the table I am looking at?

Gaby Abed (7/10/2009)
2) be prepared in case Microsoft suddenly removes an undocumented feature in the next version of SQL Server (and sometimes even in the next Service Pack)
Shoot.... be prepared...
--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)

July 10, 2009 at 9:52 am

#1023167
RE: How to find Total Number of Tables in All the databases on a Server?

apat (7/9/2009)
Hello All,
How to find total number of tables in each database for all the databases on one particular server?
Thanks,
apat
I've seen this question from various folks over the years 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)

July 9, 2009 at 5:58 pm

#1022799
RE: Job Interview Questions

In most cases (there are exceptions), claims to SQL by other than people interviewing specifically for SQL Developer or DBA usually mean that they were actually in the same room...
--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)

July 9, 2009 at 5:56 pm

#1022796
RE: set commands

Duplicate post. Please don't post replies here. Instead, see the following URL...
http://www.sqlservercentral.com/Forums/Topic750661-146-1.aspx
--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)

July 9, 2009 at 5:38 pm

#1022790

Viewing 15 posts - 43,051 through 43,065 (of 59,102 total)