Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,001 through 21,015 (of 59,098 total)

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
RE: Log File Management

keshab.basnet (4/19/2015)
Thanks Sir.
I take full database and Transaction log backup once a day at night time when there is almost no transaction in database. Can i shrink log file 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:03 pm

#1791888
RE: Use cursor to run dynamic SQL to find special characters used in database

ScottPletcher (4/17/2015)
Cursoring through the tables is fine, but you should process all columns in a single table in one pass (scan), not a separate pass for each column.
Agreed. iTVFs...
--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 11:55 am

#1791887
RE: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

Gary Harding (4/17/2015)
Wayne West (4/17/2015)
Jeff Moden (4/16/2015)
My greatest disappointment is that MS doesn't have a datetime conversion for Pig Latin. 😛
It's in Alpha testing right now and will release next...
--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 11:51 am

#1791886
RE: Are the posted questions getting worse?

Eirikur Eiriksson (4/19/2015)
Jeff Moden (4/19/2015)
SQLRNNR (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction,...
--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 11:43 am

#1791884

Viewing 15 posts - 21,001 through 21,015 (of 59,098 total)