Proc with input paramaters does not compile

Question

Proc with input paramaters does not compile

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

Express12 (11/11/2013)
Do you guys have a recommendation on a new flavor of a "smart reindex" process out there?

The general recommendation is Ola Hallengren's maintenance scripts. http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

Lynn Pettis (11/11/2013)
Just a suggestion based on my own philosophy, regardless of collation used (case sensitive or case insensitive) you should write your code as if it is always case sensitive. I do this and I don't run into issues like this.

I guess I just don't understand why anyone would make a whole server case sensitive even in non-English speaking countries. Columns, yes... servers, no. But that's just my opinion and I'm likely in the minority in that type of thinking especailly if you consider how many Oracle users there are.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Jeff Moden (11/11/2013)
Lynn Pettis (11/11/2013)
Just a suggestion based on my own philosophy, regardless of collation used (case sensitive or case insensitive) you should write your code as if it is always case sensitive. I do this and I don't run into issues like this.
I guess I just don't understand why anyone would make a whole server case sensitive even in non-English speaking countries. Columns, yes... servers, no. But that's just my opinion and I'm likely in the minority in that type of thinking especailly if you consider how many Oracle users there are.

Call me strange or weird but I actually prefer case sensitive, just don't ask me why as I haven't been able to answer it well myself.