Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,136 through 24,150 (of 59,099 total)

RE: TEMPDB on RAM

Admingod (3/14/2014)
Configuring SQL to put TEMPDB completely on RAM? .If RAM is dedicate to TempDB will improve performance?
Thanks
To answer this question, probably not nearly as much as people would have...
--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)

March 16, 2014 at 3:45 pm

#1697518
RE: SSRSh - Dynamically changing calendar parameters

I pretty much don't even know how to spell "SSRS". With that though in mind, here's how I'd do it in T-SQL. I would imagine that it wouldn't...
--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)

March 16, 2014 at 3:23 pm

#1697515
RE: Split String with row terminator

born2achieve (3/15/2014)
Hi,
i read the below link article and and use the below function for splitting the string. I love the Jeff moden's split string and below code has modified...
--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)

March 16, 2014 at 3:13 pm

#1697512
RE: cancling a rebuild clustered index

Joy Smith San (3/16/2014)
Thanks all.....Once one of our weekly index rebuild which normaly takes 7 hours was not compeleted till Monday morning. However when I cancelled the job it took...
--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)

March 16, 2014 at 2:33 pm

#1697509
RE: Multiple backup at the same time

obtllc (3/15/2014)
If I have 30 players, it will simply be 30/5 = 6. Simple.
The teams are grouped as follows:
Best player (largest db) - group 1
Second best (second largest 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)

March 16, 2014 at 1:40 pm

#1697507
RE: Are the posted questions getting worse?

andrew gothard (3/15/2014)
GilaMonster (3/15/2014)
Wow, the things you learn around here.
If you check index fragmentation, enable locked pages and enable (but don't configure) resource governor, SQL will magically start to use...
--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)

March 16, 2014 at 11:48 am

#1697495
RE: Are the posted questions getting worse?

andrew gothard (3/15/2014)
Jeff Moden (3/14/2014)
TomThomson (3/14/2014)
jcrawf02 (3/13/2014)
Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? 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)

March 16, 2014 at 11:40 am

#1697494
RE: TEMPDB on RAM

Jeff Moden (3/15/2014)
jeffrey yao (3/15/2014)
@jeff Moden, the wish that all developers will be able to write high-quality code was, is and will still be a wish. But just because of...
--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)

March 16, 2014 at 10:48 am

#1697489
RE: TEMPDB on RAM

jeffrey yao (3/15/2014)
@jeff Moden, the wish that all developers will be able to write high-quality code was, is and will still be a wish. But just because of the fact...
--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)

March 15, 2014 at 9:00 pm

#1697457
RE: Calculating Bandwidth Data

Nice job on posting readily consumable data!
I believe the following is one way of doing it for you. It keeps things down to just two scans of the table...
--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)

March 14, 2014 at 10:12 pm

#1697379
RE: Are the posted questions getting worse?

TomThomson (3/14/2014)
jcrawf02 (3/13/2014)
Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? I mean, I've never worked...
--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)

March 14, 2014 at 8:07 pm

#1697374
RE: TEMPDB on RAM

jeffrey yao (3/14/2014)
Actually putting tempdb totally in memory is a great idea in general.
10 years ago, we never imagine MS will have in-memory OLTP technology, so I bet in future,...
--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)

March 14, 2014 at 8:00 pm

#1697372
RE: Help with hierarchical structure without hierarchical relation field...

dwain.c (3/13/2014)
I agree that an INDEXed, computed PERSISTED column is the way to go if you can change the table structure.
If you can't change the table structure, build a "Sister...
--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)

March 14, 2014 at 5:48 pm

#1697365
RE: get the first date and weekday of every month in a year

@scott,
I really like this line of clever code...
WHEN DATEDIFF(DAY, 0, first_day_of_month) % 7 = 5 THEN 2 ELSE 1 END
--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)

March 14, 2014 at 5:44 pm

#1697364
RE: get the first date and weekday of every month in a year

I originally missed what Scott was talking about and had to edit this post. Like he said, no biggee on this one but I agree... seems like there's 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)

March 14, 2014 at 5:18 pm

#1697361

Viewing 15 posts - 24,136 through 24,150 (of 59,099 total)