Jeff Moden

Forum Replies Created

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

RE: Converting datetime to bigint: Native formats: reverse engineering.

The function isn't any kind of "implicit" conversion. The function is based on a CLR.
I have no idea what the time base for this function is. Normally these...
--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 5:31 pm

#1697525
RE: Split String with row terminator

I don't know how many "rows" will be in each string that you get. If it's more than a couple hundred, Adi's good code is going to get real...
--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 5:06 pm

#1697524
RE: Split String with row terminator

born2achieve (3/16/2014)
Hi Adi, thanks for your reply, sample and appreciate your time on this post.
Hi Jeff,
Thanks for your reply
So from your statement it's not good to use the function which...
--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:57 pm

#1697521
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

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