Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,051 through 40,065 (of 59,072 total)

RE: Patern Matching

Lowell (1/29/2010)
if your column is varchar or nvarchar, it's fairly easy; you know the exact length of the string to catch, and can use charindex or patindex to find where...
--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)

January 29, 2010 at 8:13 pm

#1111092
RE: How do I do an update/insert to certain fields in a certain order?

If it's only 5 DB's, why not simply have a stored proc that takes the parameters and does 5 inserts using the 3 part naming convention?
--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)

January 29, 2010 at 7:53 pm

#1111091
RE: Rotating Keys

Ummm... I'm confused. Wouldn't the real key be to keep people from getting a copy of the database to begin with??? :blink:
--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)

January 29, 2010 at 7:49 pm

#1111090
RE: Why moving a database slowed it down a lot?

Heh... Rumor has it that you probably need to rebuild stats because they don't "move" with the data.
--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)

January 29, 2010 at 7:17 pm

#1111086
RE: Extract X and Y coordinates out of a string and check if within range

Hi Charlotte,
I do have a question about the data you were kind enough to provide... how can a polygon have a single "X" coordinate and no "Y" coordinate? Why...
--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)

January 29, 2010 at 7:13 pm

#1111085
RE: Database Design- IS NOT NULL always better choice?

As has been suggested, you could start a real religious war over this.
I believe there are two questions here... the first is "should we use nulls" and the second is...
--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)

January 29, 2010 at 6:47 pm

#1111083
RE: Are the posted questions getting worse?

Grant Fritchey (1/29/2010)
Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like...
--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)

January 29, 2010 at 5:50 pm

#1111079
RE: spliting the data using replace function

You bet. Thank you for the feedback.
--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)

January 29, 2010 at 5:45 pm

#1111077
RE: Are the posted questions getting worse?

Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like 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)

January 29, 2010 at 6:18 am

#1110675
RE: How Do You Handle the Stress of Being a DBA?

😛
Ben Moorhouse (1/25/2010)
Ha! So true Jeff!
I've been working alongside another person in my team, and I keep having to solve stupid mistakes.
Such as records not being deleted even though I'm...
--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)

January 28, 2010 at 8:22 pm

#1110434
RE: How Do You Handle the Stress of Being a DBA?

Nicholas Cain (1/27/2010)
I like to make poke fun at us SQL DBA's with our Oracle counterparts in the group. Once you admit to them that SQL Server is just a...
--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)

January 28, 2010 at 8:18 pm

#1110432
RE: any one no where to place these 3 below statements in a CURSOR to find get info on the cursor

adam spencer (1/28/2010)
Lynn and All, thank you for your help. I quit my job, moved my wife and I to Austin Texas (Texas is ranked high as having IT/IS jobs...
--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)

January 28, 2010 at 8:16 pm

#1110431
RE: spliting the data using replace function

anitha.cherukuri (1/28/2010)
Unfotunately If notetext does not have searching strings ,its giving error.
I was under the impression that all of the "searching strings" would be available for every row. Since...
--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)

January 28, 2010 at 8:09 pm

#1110426
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (1/27/2010)
Jeff,
Code has been moved to PROD. Execution time is 26 seconds.
Dynamic Sql Part : 13 Seconds
Quirky Update(#...
--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)

January 28, 2010 at 6:54 pm

#1110415
RE: Are the posted questions getting worse?

Heh... seems to be the week for Twitter... I've gotten a half dozen emails and a couple of in person queries as to why I'm not on Twitter, FaceBook, etc,...
--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)

January 28, 2010 at 6:41 pm

#1110409

Viewing 15 posts - 40,051 through 40,065 (of 59,072 total)