Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,141 through 10,155 (of 59,102 total)

RE: Build a db server just for reporting purpose

Above all else, one solid truth of the matter is that you're standing up a PRODUCTION server. That means licensing fees for both Windows and 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 6, 2019 at 1:52 pm

#2018099
RE: Translate Sql Query to Clr

meryemkurs072 - Sunday, January 6, 2019 12:16 PM
Thank you for your attention.
I want to translate query security to sqlclr.
I need this c...
--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 6, 2019 at 12:26 pm

#2018096
RE: Does Stored Proc Complete if Machine Rebooted?

tinausa - Sunday, January 6, 2019 8:46 AM
Thanks Jeff, but the code is being transitioned to something bigger nad better so no...
--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 6, 2019 at 9:52 am

#2018088
RE: Log file and data file growth

NP. Thanks 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 5, 2019 at 4:07 pm

#2018079
RE: Lack of Memory

ZZartin - Friday, January 4, 2019 10:16 AM
robert.sterbal 56890 - Friday, January 4, 2019 8:44 AM
--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 5, 2019 at 2:12 pm

#2018076
RE: SSIS Help!

Heh... doesn't matter. Real Excel file or Excel converted to CSV... you'll have the same problems because the problem isn't in the file type. Unless the Excel file is laid...
--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 5, 2019 at 1:48 pm

#2018075
RE: UTF-8 Requirement for DB - will it work with SQL2014

krypto69 - Friday, January 4, 2019 6:06 AM
HI,
My sys admin sends me an email asking me to install a new DB....
--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 5, 2019 at 12:56 pm

#2018074
RE: Log file and data file growth

Tac11 - Thursday, January 3, 2019 11:56 AM
Hi Gurus,
Is there anyway to query to see if log or/and data file growing 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)

January 5, 2019 at 12:53 pm

#2018073
RE: SQL Memory & Tempdb usage

sqlguy7777 - Saturday, January 5, 2019 2:36 AM
HiI agree with you completely, but weâ€™re kind of stuck with it. The top brass...
--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 5, 2019 at 10:55 am

#2018071
RE: Insert Faster way

RGP - Saturday, January 5, 2019 3:37 AM
Jeff Moden - Friday, January 4, 2019 11:55 PM
--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 5, 2019 at 9:05 am

#2018070
RE: Insert Faster way

p.p.s. BTW, what's the data type of that JOB_INFO column?
--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 4, 2019 at 11:55 pm

#2018064
RE: SQL Memory & Tempdb usage

sqlguy7777 - Friday, January 4, 2019 10:57 PM
Hey thanks everyone for your great responses so far.....
"What problems are you trying to solve?"
In...
--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 4, 2019 at 11:40 pm

#2018063
RE: Insert Faster way

p.s. We really need to fix that 50% FILL FACTOR thing. It's wasting a ton of memory. We can look at that once we've solved your original problem.
--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 4, 2019 at 11:25 pm

#2018062
RE: Insert Faster way

Ok... here we go...
First, I wanted to make sure that I had the same volume of data you have. I'd forgotten to ask you to post the DDL...
--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 4, 2019 at 11:13 pm

#2018061
RE: Insert Faster way

RGP - Friday, January 4, 2019 7:21 PM
Thanks Jeff, no issues at all, Iâ€™m so glad that you are so responsive 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)

January 4, 2019 at 9:12 pm

#2018056

Viewing 15 posts - 10,141 through 10,155 (of 59,102 total)