Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,701 through 41,715 (of 59,102 total)

RE: WORD UP!

Jeff Moden (9/16/2009)
I'm still trying to fix this. My Google search may have found something to fix it but we'll see. Here's the "fix" article I found 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)

October 3, 2009 at 5:05 pm

#1061389
RE: CRL Assembly after reboot

Dale Burrell (10/3/2009)
@jeff Moden haha... now that would be telling 🙂 we have a document system accessed by a web interface. Documents are built from document templates which contain merge...
--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)

October 3, 2009 at 4:50 pm

#1061387
RE: How I can make look like I expert on SQL Server?

:Whistling:
--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)

October 3, 2009 at 2:22 pm

#1061371
RE: The Incidental DBA

To the point of this article, incidental DBA's probably wouldn't use a Tally table even if they knew what it was. The only thing most IDBA's are likely using...
--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)

October 3, 2009 at 1:49 pm

#1061367
RE: SQL Server 2000 4000 character query limit for adhoc queries

Most people don't know about it, but you can also create temporary stored procedures that begin with #.
--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)

October 3, 2009 at 12:33 pm

#1061358
RE: The Incidental DBA

To continue the car analogy... one should at least know which side of the road to drive on and maybe how to put the car in "drive".
--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)

October 3, 2009 at 11:22 am

#1061352
RE: How split delimiters and get the values

This will help get you started...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

October 3, 2009 at 11:17 am

#1061351
RE: how to store large files in sqlserver 2008

rockingadmin (10/3/2009)
Hi,
file stream was introduced in sql2008. I am bit eager to know, what about earlier versions of sqlserver2000 and 2005?
i thank each and every one for sharing ideas.
Regards,
Rock..
For files...
--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)

October 3, 2009 at 11:13 am

#1061350
RE: CRL Assembly after reboot

I'm always curious about what people use CLR's for. What does this one do?
--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)

October 3, 2009 at 11:07 am

#1061349
RE: Are the posted questions getting worse?

bitbucket-25253 (10/2/2009)
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
Well we might soon know. Sent an email to the web master 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)

October 3, 2009 at 11:01 am

#1061348
RE: Are the posted questions getting worse?

Jack Corbett (10/2/2009)
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
I don't have a problem with it. The OP isn't directly trying to sell...
--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)

October 3, 2009 at 10:57 am

#1061347
RE: Converting Datetime Field To Text

Roger Abram (10/3/2009)
I did figure it out.
Would you mind posting what your final code is? Thanks.
I am setting it up to use in the body of an...
--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)

October 3, 2009 at 10:51 am

#1061346
RE: How I can make look like I expert on SQL Server?

ItalianOlgi (10/3/2009)
Thank you for very good advice but maybe someone has the list I was asking about?
Also, I am looking for information like "if they ask about X, first answer...
--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)

October 3, 2009 at 10:39 am

#1061343
RE: SQL Book Signing : Reminder

Thanks.
--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)

October 3, 2009 at 7:52 am

#1061337
RE: SQL Book Signing : Reminder

What's your handle there?
--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)

October 2, 2009 at 8:20 pm

#1061294

Viewing 15 posts - 41,701 through 41,715 (of 59,102 total)