Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,971 through 20,985 (of 59,072 total)

RE: Embrace Stored Procedures

RonKyle (4/20/2015)
I agree with the previous comment regarding language. We should be able to express ourselves more professional. I'm not above swearing, but I don't swear at others...
--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)

April 20, 2015 at 9:32 am

#1792111
RE: Embrace Stored Procedures

bdenning (4/20/2015)
I started to read this article and didn't get past the first paragraph. Why technical people resort to street language to express themselves is beyond me. 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)

April 20, 2015 at 9:15 am

#1792085
RE: Embrace Stored Procedures

ddriver (4/20/2015)
So the database is the center of the universe just because turning it off brings the system down? You could say the same thing about a router, a switch,...
--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)

April 20, 2015 at 9:06 am

#1792073
RE: Embrace Stored Procedures

ddriver (4/20/2015)
So the database is the center of the universe just because turning it off brings the system down? You could say the same thing about a router, a switch,...
--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)

April 20, 2015 at 9:03 am

#1792069
RE: Embrace Stored Procedures

Yet Another DBA (4/20/2015)
Jeff Moden (4/18/2015)
I read Rob's article when it first came out. What a refreshing change it was from the dogma that I've been reading about 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)

April 20, 2015 at 8:57 am

#1792063
RE: Embrace Stored Procedures

IceDread (4/20/2015)
Just because a system would use an ORM does not mean that the ORM itself can not use stored procedures.
Jeff Moden (4/18/2015)
To coin a phrase, "If you don't 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)

April 20, 2015 at 8:56 am

#1792062
RE: Alter Function - took long time ...

It might just be a bad error message. MS is sometimes pretty good at that. You might have to drop the proc that uses it (after saving its...
--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)

April 19, 2015 at 9:56 pm

#1791916
RE: Find/Replace based on a table - strange results

With only 5 known characters to replace so far and very few that could remain, I recommend keeping this as simple and fast as possible. You could easily turn...
--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)

April 19, 2015 at 9:05 pm

#1791912
RE: Alter Function - took long time ...

davidku (4/19/2015)
Hi,
I created a scalar user defined function and when I try to modify / alter the script, it just takes long time to execute.
So, I decided to delete 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)

April 19, 2015 at 8:51 pm

#1791911
RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

Eirikur Eiriksson (4/19/2015)
Jeff Moden (4/19/2015)
hurricaneDBA (4/19/2015)
Thanks thats actually a great idea 🙂
Ah, be careful now. There's a price to be paid with Global Temp tables. Code that uses...
--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)

April 19, 2015 at 8:12 pm

#1791909
RE: Get Surrounding text in a string?

markpringle (4/19/2015)
It uses a Temp table, but temp tables can't be used in functions, right? I am just not SQL savvy enough to know how to repurpose it.
I see nothing...
--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)

April 19, 2015 at 5:56 pm

#1791906
RE: SSMS hesitation

Brandie Tarvin (4/17/2015)
My workplace is getting ready to upgrade to SQL 2012. While I wait for the servers to be built, I started playing with 2012 SSMS pointing to our...
--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)

April 19, 2015 at 3:37 pm

#1791894
RE: Get Surrounding text in a string?

markpringle (4/19/2015)
Thanks. Is it possible to put this into a function? Or how would I use that within a select statement?
Sure. I'd make sure that it was an "Inline...
--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)

April 19, 2015 at 3:17 pm

#1791893
RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

hurricaneDBA (4/19/2015)
Thanks thats actually a great idea 🙂
Ah, be careful now. There's a price to be paid with Global Temp tables. Code that uses them might not 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)

April 19, 2015 at 12:14 pm

#1791890
RE: Get Surrounding text in a string?

Eirikur Eiriksson (4/19/2015)
Second solution, which is more efficient than the previous one as it doesn't use the XML concatenation.
/* Find the group where the search word is closest 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)

April 19, 2015 at 12:12 pm

#1791889

Viewing 15 posts - 20,971 through 20,985 (of 59,072 total)