Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,336 through 13,350 (of 59,095 total)

RE: Difference between dates displayed in days, hours, minutes and seconds

robinson.netdevelop - Monday, December 18, 2017 9:14 AM
It is right?
CREATE FUNCTION dbo.ufn_DifferenceBetweenDates
(
@Date1 Datetime, -- Dia inicio
@Date2 Datetime -- Dia...
--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)

December 22, 2017 at 3:00 pm

#1973303
RE: I don’t know how to help with database…

Grant Fritchey - Friday, December 22, 2017 6:21 AM
A yahoo email address, so I suspect spam too.
However, in the interest of being...
--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)

December 22, 2017 at 9:28 am

#1973277
RE: Can someone explain how this works

macbaze72 - Thursday, December 21, 2017 4:04 PM
This code works, but I don;t understand it. The part I need some clarification is...
--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)

December 22, 2017 at 9:26 am

#1973275
RE: Suggestions on a query plan

vsamantha35 - Thursday, December 21, 2017 12:48 PM
Thanks Lynn. One more thing, I want to ask is that, how can we make...
--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)

December 22, 2017 at 6:48 am

#1973258
RE: usage of DISTINCT OPERATOR

From the code alone posted so far, it's a bit difficult to make out what you're actually trying to do. From the description and a couple of hints in the...
--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)

December 22, 2017 at 6:37 am

#1973257
RE: Split a Record using Substring

mk.kamalanand - Friday, December 22, 2017 1:53 AM
Hi All,
I have records stored in a table in below formats . Want the result...
--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)

December 22, 2017 at 6:05 am

#1973255
RE: t-sql 2012 split function

wendy elizabeth - Tuesday, December 19, 2017 2:02 PM
How about what is wrong with what I just submitted? The splitter function works...
--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)

December 21, 2017 at 6:23 pm

#1973237
RE: views,tables,stored procedures are rolled back to previous versions

adisql - Thursday, December 21, 2017 2:57 PM
is there any way to find what jobs modifying these objects .
because these objects are...
--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)

December 21, 2017 at 4:07 pm

#1973223
RE: Graph DB edge tables

Lynn Pettis - Thursday, December 21, 2017 9:41 AM
Jeff Moden - Thursday, December 21, 2017 9:24 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)

December 21, 2017 at 3:51 pm

#1973220
RE: Graph DB edge tables

I'll admit that it's a totally different take on the answer to this but, like many things, I find that the built in functionality is just totally bloated and would...
--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)

December 21, 2017 at 9:24 am

#1973111
RE: Help with aggregate function

ger_serrano - Wednesday, December 20, 2017 7:34 AM
Awesome Jeff!!. Thanks a lot. I think the following query is also rdbms agnostic:
with newtab...
--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)

December 21, 2017 at 7:53 am

#1973086
RE: Ola's maintenance solution taking too long on VLDB's

Ah... almost forgot the most important part...
If you have indexes that have a FILL FACTOR of 0 or 100 and the average percent of page fullness decreases 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)

December 20, 2017 at 9:49 am

#1972941
RE: Ola's maintenance solution taking too long on VLDB's

ffarouqi - Tuesday, December 19, 2017 10:10 AM
Is there a way I can cut down the run time and still complete the...
--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)

December 20, 2017 at 9:35 am

#1972935
RE: SQL 2012 - Interview Questions (Sample)

Grant Fritchey - Wednesday, December 20, 2017 5:23 AM
Jeff Moden - Tuesday, December 19, 2017 1:49 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)

December 20, 2017 at 9:14 am

#1972925
RE: Restore full backup at first and restore diff backup later, can I?

Perry Whittle - Wednesday, December 20, 2017 5:08 AM
Jeff Moden - Tuesday, December 19, 2017 6:25 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)

December 20, 2017 at 8:56 am

#1972919

Viewing 15 posts - 13,336 through 13,350 (of 59,095 total)