Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,066 through 22,080 (of 59,072 total)

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
RE: Synonyms and Temp Tables

Ed Wagner (12/29/2014)
Steve Jones - SSC Editor (12/27/2014)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/120079/">Synonyms and Temp Tables</A>
I don't use global temp tables very much myself, but...
--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 1:36 pm

#1767283
RE: SA Account

On that same note, the application absolutely MUST NOT have SA or DBO privs. My personal preference should be apps that only have PUBLIC privs and the privs 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 1:23 pm

#1767281
RE: Are the posted questions getting worse?

Lynn Pettis (12/31/2014)
[font="Arial Black"]Happy New Year from far off Afghanistan!!![/font]
Same to you, Lynn!!!
--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 1:16 pm

#1767280
RE: Faster way to populate number table variation with inline tally?

Eirikur Eiriksson (12/31/2014)
Michael Meierruth (12/30/2014)
Jeff, so what was the trick?
I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.
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)

December 31, 2014 at 12:12 pm

#1767258
RE: Faster way to populate number table variation with inline tally?

Michael Meierruth (12/30/2014)
Jeff, so what was the trick?
I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.
Still, getting anything...
--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 10:56 am

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

Great article on what can go wrong and how to make it right, Sebastian. What you've described is a classic failure that could certainly have been prevented by 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 31, 2014 at 9:58 am

#1767226
RE: Split Columns of Months into Columns of Weeks

@jesse.owen,
I'm totally confused as to what the purpose of the YearMonth column in the #tab_MonthlyData table is. If you have columnar month data, why is each row associated with...
--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 8:54 am

#1767205
RE: Data Drive is full. how to resolve it?

This sounds like an interview question.
--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 30, 2014 at 6:48 pm

#1767119
RE: xp_cmdshell issues

schleep (12/12/2014)
One more question:
Let's assume I go with the certificate method.
Each night, we do database transfers to various target servers, using smo.Transfer.
Does the certificate/permissions granted by the cert...
--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 30, 2014 at 6:24 pm

#1767117
RE: Top SQL DBA Tools

Heh... at best, all of those tools are only second best to the most important administrative tool of them all... the brain of the DBA. 😉
--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 30, 2014 at 6:20 pm

#1767116
RE: suspicious results

This certainly looks like a Windows problem on a disk. As the error message states, perhaps a bad disk or maybe just a bad sector.
First, verify that the files...
--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 30, 2014 at 6:10 pm

#1767115

Viewing 15 posts - 22,066 through 22,080 (of 59,072 total)