Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,361 through 21,375 (of 59,072 total)

RE: EXCEL HELL!!!

Thanks for the notes, Gosta.
This isn't actually for any application. It was actually an example spreadsheet that I saw on one of the threads that I've modified a bit....
--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)

March 4, 2015 at 8:26 am

#1781661
RE: Job Interview question: slow queries

jwiseh (3/4/2015)
Jeff Moden (3/4/2015)
Heh... whether you're interviewing for a Developer's position or a DBA's position, one of the most important things would be "communication". You and I have just...
--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)

March 4, 2015 at 2:20 am

#1781554
RE: BREAK

Heh... the correct answer is @j-2. 😛
Great question, BTW.
--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)

March 4, 2015 at 1:38 am

#1781549
RE: Job Interview question: slow queries

It's 3:30 AM here. I've gotta be up-and-at-em in a little over 3 hours. I'll be back but I need to know the answers to my questions about...
--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)

March 4, 2015 at 1:36 am

#1781548
RE: Job Interview question: slow queries

...since I know putting a calculation or concatenation on the left side of the WHERE clause comparison forces a table scan, even if there is an index, because the concatenation...
--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)

March 4, 2015 at 1:21 am

#1781546
RE: Job Interview question: slow queries

Heh... whether you're interviewing for a Developer's position or a DBA's position, one of the most important things would be "communication". You and I have just failed that because,...
--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)

March 4, 2015 at 1:02 am

#1781543
RE: Job Interview question: slow queries

jwiseh (3/3/2015)
Wow... I just checked back on my humble little post: 27 views, and no one willing to take a crack at the answer. Okay, you 27 don't get 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)

March 3, 2015 at 11:46 pm

#1781533
RE: EXCEL HELL!!!

Matt Miller (#4) (3/3/2015)
Jeff Moden (3/3/2015)
Matt Miller (#4) (3/3/2015)
By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)
http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D
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)

March 3, 2015 at 8:17 pm

#1781526
RE: Calculating Work Days

Awesome. Thanks for the feedback, JeeTee. It's not often that a decade old thread gets feedback like this.
--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)

March 3, 2015 at 8:08 pm

#1781525
RE: What is the equivalent to Yes/No data type in SQL?

CELKO (3/3/2015)
While what you say is absolutely true, there are so many nice ways to say this and so many ways to make this useful and you managed 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)

March 3, 2015 at 2:00 pm

#1781485
RE: EXCEL HELL!!!

Matt Miller (#4) (3/3/2015)
By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)
http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D
That said - you're still right...
--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)

March 3, 2015 at 11:34 am

#1781459
RE: What is the equivalent to Yes/No data type in SQL?

CELKO (3/3/2015)
We do no use assembly language bit flags in RDBMS. Please read:
https://www.simple-talk.com/sql/t-sql-programming/bit-of-a-problem/
You do not think in predicates yet and probably do not understand 3VL.
While what you say is absolutely...
--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)

March 3, 2015 at 11:18 am

#1781456
RE: Flip data in SQL

helal.mobasher 13209 (3/3/2015)
Thanks Luic for dynamic SQL. Very elaborate and I need to test it. However, on your note "Are you seriously taking the advice and code from someone from...
--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)

March 3, 2015 at 8:49 am

#1781390
RE: 10gb size of Index rebuild when space left overall 5gb

hcip.77 (3/3/2015)
It is clustred.
Thank You.
In that case, you don't have the room to do a REBUILD. If your log file is on a different drive, you could try doing...
--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)

March 3, 2015 at 8:27 am

#1781375
RE: Very little space of harddisk problem

WhiteLotus (3/2/2015)
Hi Jeff ,
hmm I just did defragmentation for all indexes in that particular database as discussed before .
It turns out the database file size is the same (...
--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)

March 3, 2015 at 6:22 am

#1781334

Viewing 15 posts - 21,361 through 21,375 (of 59,072 total)