Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,081 through 22,095 (of 59,098 total)

RE: What's Coming True?

It's a great start to 2015. My good friend and fellow SQL warrior Gianluca Sartori (aka, the "Spaghetti DBA") has finally awarded the SQL Server MVP award! 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 2, 2015 at 4:49 pm

#1767509
RE: Are the posted questions getting worse?

spaghettidba (1/2/2015)
Now I see that my post could be seen as bragging, when all I wanted to do was nothing but say "thank you". I'm hopelessly bad at soft skills....
--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 2, 2015 at 3:45 pm

#1767498
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/2/2015)
If you're feeling the itch and things are slow.....
Looking for good ... articles on practical topics.
Heh... I've got a bunch that I've been researching...
--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 2, 2015 at 1:15 pm

#1767472
RE: Are the posted questions getting worse?

Eirikur Eiriksson (1/2/2015)
Stefan Krzywicki (1/2/2015)
Happy New Year everyone!
Who, like me, is at work today?
I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off but still...
--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 2, 2015 at 1:12 pm

#1767471
RE: Comparing Bits and Ints

Phil Parkin (1/2/2015)
Viewing the XML for the execution plan, there are references to the CONVERT_IMPLICIT() function.
I only looked at the "properties" in the execution plan. I'll go back 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 2, 2015 at 1:09 pm

#1767470
RE: Comparing Bits and Ints

I agree with Eirikur on this. I don't see an implicit conversion on the typical million row test and, not that you'd ever put an index on such 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 2, 2015 at 8:30 am

#1767399
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/2/2015)
Happy New Year everyone!
Who, like me, is at work today?
Me. Covering for the younger folks that have families.
--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 2, 2015 at 8:10 am

#1767394
RE: Wow!!! I didn't know that could be done - Datetime Calculations

ScottPletcher (1/2/2015)
GilaMonster (12/31/2014)
Luis Cazares (12/30/2014)
Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.
It's also far less clear than a DATEADD...
--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 2, 2015 at 8:09 am

#1767393
RE: Are the posted questions getting worse?

spaghettidba (1/1/2015)
Happy New Year everybody!
And there's a very special thank you message for every single one of you on my blog here! 🙂
Thank you for involving me in the most...
--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 1, 2015 at 7:24 pm

#1767334
RE: SQL Server 2014 Checklist for Performance

Ah... dang it! I forgot to do one of the most important things there is for the new year... change the bands on the pork chop launcher! 😛
--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 1, 2015 at 1:50 pm

#1767327
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/1/2015)
Happy New Year!
Happy New Year to you and yours, Steve!
Same to everyone else! Have a very happy New Year! Lot's of good stuff...
--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 1, 2015 at 1:44 pm

#1767326
RE: Mapping Hierarchical Relationships

Ah. Understood.
The first article the PietLinden pointed you to has a near twin right here on SSC. It's located at the following URL:
http://www.sqlservercentral.com/articles/Hierarchy/94040/
That article shows how to convert...
--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 31, 2014 at 6:14 pm

#1767306
RE: Mapping Hierarchical Relationships

pietlinden (12/31/2014)
I was waiting for Jeff Moden to answer, but since he hasn't yet, you might want to read his article:
http://www.sqlservercentral.com/articles/T-SQL/94570/
or
http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/25/hierarchies-convert-adjacency-list-to-nested-sets.aspx
Or maybe one by Dwain Camps
https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/
Thanks Pieter.
@JeeTee,
What I'm trying 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)

December 31, 2014 at 5:27 pm

#1767304
RE: Stairway to Test Automation and Continuous Integration for Databases Level 1: Why You Need TDD

Conrad Muller (12/31/2014)
This was management failure from end to end. First they screwed everything up in an ill advise attempt to save money, then they dumped the responsibility for their...
--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 31, 2014 at 5:16 pm

#1767302
RE: converting time string in temp table to military time then cast as integer

SQLalchemy (12/26/2014)
I need to take a temporary table that has various times stored in a text field (4:30 pm, 11:00 am, 5:30 pm, etc.), convert it to miltary time then...
--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 31, 2014 at 2:30 pm

#1767292

Viewing 15 posts - 22,081 through 22,095 (of 59,098 total)