Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,631 through 21,645 (of 59,072 total)

RE: The Number that shouldn't be a number

jarick 15608 (1/31/2015)
Jeff, I think we must have run into the same consultants. I had one of my clients hire a data warehouse expert that did not know...
--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)

February 1, 2015 at 10:04 am

#1774638
RE: The Number that shouldn't be a number

Eirikur Eiriksson (1/31/2015)
jwiseh (1/31/2015)
I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in...
--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)

February 1, 2015 at 9:54 am

#1774637
RE: Rename a Live database

sm_iransoftware (1/31/2015)
1- Create a new database with same structure.
I guess my question is, if it's the same structure, why are you bothering to do this in the first place?
--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 31, 2015 at 11:16 pm

#1774605
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

yoshii (1/31/2015)
Thanks to Jeff and others' contributions. All discussions are valuable.
@jeff. Thanks for the valuable feedbacks!
In my opinion, communication not only happens verbally, but also at implication level...
--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 31, 2015 at 11:01 pm

#1774604
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

xsevensinzx (1/31/2015)
Regardless, I've experienced simple questions like that in my past as a new guy to SQL Server. I think my last one is whether or not I knew what...
--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 31, 2015 at 10:38 pm

#1774602
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

Lynn Pettis (1/31/2015)
When we meet at PASS 2015 you are going to have to show me that trick with the quarter.
Not sure I can make it to PASS 2015 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)

January 31, 2015 at 4:14 pm

#1774583
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

Heh... almost forgot. I asked you a question so that we might be better able to help and you didn't answer it because you were too busy taking things...
--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 31, 2015 at 2:42 pm

#1774576
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

To continue a bit, if you don't go into an interview with a nicely indexed couple of clamshell clear folders that clearly demonstrate that you know how to solve problems...
--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 31, 2015 at 2:34 pm

#1774574
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

yoshii (1/31/2015)
not sure where's this thinking of "reading interview questions = cheating a job" coming from. there're billions of people on earth. there are people trying to cheat a 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)

January 31, 2015 at 2:11 pm

#1774571
RE: The Number that shouldn't be a number

mister.magoo (1/31/2015)
Storing currency values in a FLOAT is my least favourite, as I am constantly having to do stupid things like this
WHERE ABS(table1.column1 - table2.column2)<0.01
just to check for equality...
Wow. ...
--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 31, 2015 at 9:20 am

#1774559
RE: The Number that shouldn't be a number

I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in a day. Anyone want...
--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 31, 2015 at 12:27 am

#1774536
RE: somtimes 'SELeCT getdate()' takes 5 sec to complete

There can be a thousand reasons. CPU is occasionally pegged to the wall. I/O is occasion pegged to the wall. The "pipe" is occasionally full. Auto-negotiate...
--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 31, 2015 at 12:24 am

#1774535
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

yoshii (1/30/2015)
@jeff
I don't think it's worth it...
the tech questions are too basic and the answers are too short. For situational questions, I pretty much was able...
--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 30, 2015 at 11:32 pm

#1774533
RE: Parsing data to from a field into a new record of a different table

Heh... I congratulate you on your innovation but you export the data to a spreadsheet, write a VB function, manually code the VB function into a spreadsheet once for...
--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 30, 2015 at 11:20 pm

#1774532
RE: Problem with duplicate lines

You're not actually doing it "bad". It's running the way I'd expect it to without any additional information. With that thought in mind...
Please identify what you want 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 30, 2015 at 11:13 pm

#1774531

Viewing 15 posts - 21,631 through 21,645 (of 59,072 total)