Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,206 through 23,220 (of 59,102 total)

RE: how to increase resource pool memory

On a 4GB machine, I'd let SQL Server have a max of 3GB (3000MB) instead of just 1.5GB (1500mb).
--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)

July 15, 2014 at 11:52 pm

#1729723
RE: Log files running out of space after rebuild

murnilim9 (7/15/2014)
sorry ... I hv just realized there is something that I haven't answered yet..
I perform the default rebuild indexes which has the feature ( Sort_temp = off ) 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)

July 15, 2014 at 11:48 pm

#1729722
RE: Encrypt SSN Example (TDE)

Welsh Corgi (7/15/2014)
GilaMonster (7/15/2014)
That's the exact article I would have given you as an example. See the other examples that it links to.
Bear in mind this isn't something you implement...
--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)

July 15, 2014 at 11:07 pm

#1729718
RE: Are the posted questions getting worse?

The Dixie Flatline (7/15/2014)
Sometimes I think MVPs are a real pain in the ***. Present company excepted.
Heh... now what on Earth brought that up? I ask because...
--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)

July 15, 2014 at 10:26 pm

#1729714
RE: Are the posted questions getting worse?

SQLRNNR (7/15/2014)
Lynn Pettis (7/15/2014)
Jeff Moden (7/15/2014)
GilaMonster (7/15/2014)
Ah, why not
(link to one of my later posts in the thread, but you can just scroll up)
You're right. Pork chops won't work...
--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)

July 15, 2014 at 10:11 pm

#1729713
RE: Are the posted questions getting worse?

GilaMonster (7/15/2014)
Ah, why not
(link to one of my later posts in the thread, but you can just scroll up)
You're right. Pork chops won't work there. Has to 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)

July 15, 2014 at 5:13 pm

#1729679
RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

Evil Kraig F (7/15/2014)
below86 (7/15/2014)
The concern I'm hearing is the overall size of the transactional log. And that doing the 'Insert' into these tables using the SSIS dataflow does...
--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)

July 15, 2014 at 4:28 pm

#1729674
RE: Are the posted questions getting worse?

Lynn Pettis (7/15/2014)
OMG, how can someone who has been working with SQL Server for over 9 years still behave like an entry level DBA/Developer??
Whose turn with the silver spoon??
Link, please?...
--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)

July 15, 2014 at 3:15 pm

#1729653
RE: OpenRowset Issue

KGJ-Dev (7/14/2014)
Hi Mister,
Finally i got green flag to go with Linked Server from my client. But for my self learning i will need to try your sample. Thank again...
--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)

July 15, 2014 at 8:43 am

#1729494
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/15/2014)
Miss me?
As Scotty said to Kirk, "The engines just don't feel right, Captain".
Glad you're back. How's the knee?
--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)

July 15, 2014 at 8:23 am

#1729484
RE: Is It Time To Clear Out Those Quirky Functions?

Phil Factor (7/11/2014)
@Alan.B
After reading your comment, I've nervously put the routine in a test harness. It clocked at 0.054 Ms. per execution. I have to say that when I'm optimizing,...
--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)

July 14, 2014 at 3:59 pm

#1729298
RE: Is It Time To Clear Out Those Quirky Functions?

Alan.B (7/14/2014)
Jeff Moden (7/10/2014)
Alan.B (7/10/2014)
Phil, you can make this more than twice as fast by turning it into an inline table value function like this:
To that, I say... are you...
--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)

July 14, 2014 at 3:53 pm

#1729296
RE: Is It Time To Clear Out Those Quirky Functions?

Andy Warren (7/11/2014)
Jeff, did I just see you plug for Access?:-)
Heh... not quite. I figure if even lowly Access can have an incredible and easy to use PIVOT function,...
--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)

July 14, 2014 at 3:48 pm

#1729293
RE: Remove Hyphen from End of String

Eirikur Eiriksson (7/14/2014)
My bad or rather a lack of tanker sized industrial strength coffee this morning, the RIGHT function isn't available in SQL Server 2000, sorry about the confusion here.
😎
We're...
--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)

July 14, 2014 at 2:47 pm

#1729282
RE: Remove Hyphen from End of String

GF (7/14/2014)
First let me say think you to both of you for your responses.
The TRIM(SUBSTRING([description],1,LEN([description])-1))
Worked as I hoped it would.
However, I would like to know why the Replace(right(description,1),'-','') did not...
--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)

July 14, 2014 at 2:46 pm

#1729281

Viewing 15 posts - 23,206 through 23,220 (of 59,102 total)