Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,391 through 21,405 (of 59,098 total)

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
RE: 10gb size of Index rebuild when space left overall 5gb

hcip.77 (3/2/2015)
I have 10 Gb index and disk space only left 5gb .
How can i rebuild index ?
I appreciate your time.
Not many choices left. You're going to need 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)

March 2, 2015 at 11:24 pm

#1781270
RE: bcp queryout not working with line break

The BCP command, including the embedded query, must be on a single line. The work around would be to use the "S" and "d" parameters and the query would...
--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 2, 2015 at 11:23 pm

#1781269
RE: Where do senior SQL DBAs land finally?

ZZartin (3/2/2015)
Jeff Moden (3/2/2015)
Don Halloran (3/1/2015)
(Also I hate web development 😛 )
Ah, yeah... we need to you move that smiley face one pixel to the right and change the color...
--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 2, 2015 at 6:48 pm

#1781261
RE: Where do senior SQL DBAs land finally?

Don Halloran (3/1/2015)
(Also I hate web development 😛 )
Ah, yeah... we need to you move that smiley face one pixel to the right and change the color on the tongue...
--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 2, 2015 at 3:26 pm

#1781239

Viewing 15 posts - 21,391 through 21,405 (of 59,098 total)