Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,901 through 24,915 (of 59,102 total)

RE: what performance metrics to show before and after optimization/tuning - to show improvement

Ravid_ds (1/3/2014)
You can test by mentioning SET STATISTICS ON/OFF while executing the SP.
Oh be careful now. SET STATISTICS is a known liar when it comes to certain forms...
--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 3, 2014 at 10:24 pm

#1677486
RE: Merry Christmas Everyone :)

bitbucket-25253 (12/24/2013)
For those that want to hear what I want for Christmas ....
http://www.songfacts.com/detail.php?id=9570
Speaking of Christmas, I got a nice present just before the holiday. One of my sessions was...
--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 3, 2014 at 9:13 pm

#1677483
RE: Get Previous month data based on condition

born2achieve (1/3/2014)
Also i verified with my production data and it works perfectly.
Thanks a lot Michael. Appreciate your time on this post.
Now, for the really tough question. Do you understand...
--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 3, 2014 at 8:47 pm

#1677481
RE: Updating a column in one table from another table

Just to be clear, Chris was trying to get the OP to teach themselves how to answer such simple questions on their own instead of making them permanently dependent on...
--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 3, 2014 at 8:42 pm

#1677479
RE: Breaking Down Barriers

below86 (1/3/2014)
Jeff Moden (1/3/2014)
..."Tips'n'Tricks" ....
Is there a place on this site where these type tips and tricks can/are posted? Under 'Scripts'? Or is there a place under 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)

January 3, 2014 at 8:11 pm

#1677477
RE: Are the posted questions getting worse?

We really dodged the bullet with the "Hercules" snowstorm than nailed New England. We only got about 6 inches here about 20 miles north of Detroit.
That's about to change......
--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 3, 2014 at 8:00 pm

#1677476
RE: SQL rollback issues keep occurring due to lack of drive space

mbrady (1/3/2014)
Just as an FYI I found that error in case anyone else comes searching for a similar issue.
Msg 9002, Level 17, State 4, Line 3
The transaction log for database...
--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 3, 2014 at 7:48 pm

#1677475
RE: sort by serialcode

The following will handle more levels than you can shake a stick at with numbers as large as 99999999. You'll need the DelimitedSplit8K function for this and I've included...
--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 3, 2014 at 5:18 pm

#1677471
RE: DBCC

JohnFTamburo (1/3/2014)
nihal9200_kwada (1/3/2014)
Can I use DBCC RULEOFF and DBCC RULEON in a trigger ? I want to disable merge and hash joins optimizer rules.
And also Do I need to provide...
--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 3, 2014 at 4:24 pm

#1677463
RE: SQL rollback issues keep occurring due to lack of drive space

mbrady (1/3/2014)
Wash, rinse and repeat for as many times as it takes to fill the table using all the distinct codes. This was working fine until I forgot 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 3, 2014 at 4:15 pm

#1677461
RE: Breaking Down Barriers

andrew.morrell 67746 (1/3/2014)
DBAs and Developers are at times both purists but I find that developers tend to be a little more pragmatic in allowing some things to wait until 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)

January 3, 2014 at 12:56 pm

#1677418
RE: DBCC

nihal9200_kwada (1/3/2014)
Can I use DBCC RULEOFF and DBCC RULEON in a trigger ? I want to disable merge and hash joins optimizer rules.
And also Do I need to provide any...
--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 3, 2014 at 12:28 pm

#1677413
RE: There is insufficient system memory in resource pool 'default' to run this query

krishnamohan6669 (1/1/2014)
Perl script job which inserts data for about 5GB daily.and they are doing the same process from many months and they are experiencing the problems from recent months.
Can u...
--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 3, 2014 at 12:24 pm

#1677410
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

jimgawn (1/3/2014)
Thank you for your gracious response!
With respect to formatted Date tables, I think a lot of data warehousing folks would beg to differ. People like Ralph Kimball advocate...
--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 3, 2014 at 11:56 am

#1677403
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

dwain.c (1/2/2014)
Thanks yet again for an insightful article (probably one of the few of your I hadn't read prior). Indeed, a crack was filled.
I was curious what the SQL...
--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 3, 2014 at 9:06 am

#1677335

Viewing 15 posts - 24,901 through 24,915 (of 59,102 total)