Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,331 through 12,345 (of 59,095 total)

RE: Where Waits coming from?

Yuri55 - Wednesday, May 16, 2018 10:18 AM
Thanks Jeff- will double check with Dev team. Good to know about your real life...
--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)

May 16, 2018 at 10:40 am

#1990712
RE: Packaged-Application Database Nightmares - A Horror Story.

andrew gothard - Wednesday, May 16, 2018 9:44 AM
Jeff Moden - Wednesday, April 25, 2018 4:17 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)

May 16, 2018 at 10:11 am

#1990708
RE: Creating Filters like Previous Week, from Tuesday to Monday

kyagi.jo - Wednesday, May 16, 2018 8:45 AM
I was using SET STATISTICS IO ON, along with reading through the query plan 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)

May 16, 2018 at 10:01 am

#1990704
RE: SQL server 2014 profiler bottom pane not displaying trace -- please help...

jellybean - Wednesday, May 16, 2018 6:34 AM
Hi,
I hipe I'm posting in the correct forum. Apologies if I'm not...I using...
--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)

May 16, 2018 at 8:28 am

#1990672
RE: Creating Filters like Previous Week, from Tuesday to Monday

kyagi.jo - Wednesday, May 16, 2018 8:16 AM
Thanks, the simplified way of calculating the date range produced a much faster query plan than...
--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)

May 16, 2018 at 8:25 am

#1990671
RE: Query taking more time

haichells - Wednesday, May 16, 2018 6:50 AM
Dear All,
I have a table and it just have 34K rows in it. I 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)

May 16, 2018 at 8:19 am

#1990669
RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

ThomasRushton - Wednesday, May 16, 2018 6:54 AM
sunilchand - Wednesday, May 16, 2018 3:54 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)

May 16, 2018 at 8:01 am

#1990664
RE: DeadLock --trying to figure out what resource-list is telling me?

456789psw - Wednesday, May 16, 2018 7:17 AM
Solved!
<SyncPoint> is an indication of an Exchange event. If you run profiler trace...
--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)

May 16, 2018 at 7:58 am

#1990662
RE: Performance Question

Budd - Wednesday, May 16, 2018 7:35 AM
Hi,
I have much more to learn than to teach, but I have a habit 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)

May 16, 2018 at 7:55 am

#1990661
RE: Creating Filters like Previous Week, from Tuesday to Monday

kyagi.jo - Wednesday, May 16, 2018 3:49 AM
Hi,
If I needed to create some kind of filter that would get the data between...
--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)

May 16, 2018 at 5:33 am

#1990632
RE: Where Waits coming from?

Yuri55 - Tuesday, May 15, 2018 6:24 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)

May 15, 2018 at 12:11 pm

#1990582
RE: Storing multiple variations of the same data?

Personally, I think it's a totally unnecessary duplication of data and it doesn't stop at just what is visible in the table. It's also likely that the same people that...
--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)

May 15, 2018 at 11:59 am

#1990577

Viewing 15 posts - 12,331 through 12,345 (of 59,095 total)