Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,616 through 51,630 (of 59,102 total)

RE: I got burned today at a SQL Server Interview!

Brandie Tarvin (3/19/2008)
Oooohhh. Idea!!! :exclamationmark: Let's build our own maturity test.
No sense in me taking something I would fail... remember, I'm the guy that ripped one off during an...
--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 19, 2008 at 11:24 am

#791584
RE: Are temp tables better than table variables

Marios Philippopoulos (3/19/2008)
OK, I hear poor old table variables sobbing in a corner somewhere, so I have to step in here...
I should mention, while we are on the subject,...
--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 19, 2008 at 11:00 am

#791570
RE: Finding the current table name in the context of an insert statement

Would you share what you figured out, please? We'd like to know how you did it.
--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 19, 2008 at 10:49 am

#791564
RE: Importing vertical data using the flat file task?

TonyP (3/19/2008)
Well, it is not exactly inserting each application file into many tables. It is more like taking information out of the application file and sending it to 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 19, 2008 at 10:48 am

#791563
RE: trigger on a row level

but when i couldn't i found far too many project managers who would never challenge anything, big or small.
Now, there's something I agree with... that's why the "shop" needs 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 19, 2008 at 10:11 am

#791537
RE: I got burned today at a SQL Server Interview!

I sure do understand that... politics and education, profit and learning... frequently, they are diametric opposites.
Grant is pretty much spot on... you're probably an absolute Ninja at Oracle and...
--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 19, 2008 at 9:46 am

#791520
RE: Importing vertical data using the flat file task?

Hello Jim,
Heh... I'm just going to assume that you meant "Jeff"... 😛
When I originally read your solution, it seem like you got the impression that I was looking to take...
--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 19, 2008 at 9:28 am

#791503
RE: I got burned today at a SQL Server Interview!

Heh... you mean besides "impressive" 😀
If I were you, I'd list the following in my objectives on a resume...
Manager/Director of IT/MIS
Hybrid DBA (Systems/Application/ETL)
Data Architect/Modeler
Certified Instructor/Mentor
If you don't want to be...
--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 19, 2008 at 8:50 am

#791485
RE: SQL Server File Query

yep... that and if Crystal Reports is on the server, dunno if it still does this but it used to leave 1 file per page rendered and never removed them....
--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 19, 2008 at 8:36 am

#791471
RE: Insert Taking A Long Time

Deletes tmpTable on Sql Server
By that, do you mean it uses a DROP TABLE command, A DELETE statement to remove all rows, or a TRUNCATE to remove all rows?
--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 19, 2008 at 8:30 am

#791466
RE: Importing vertical data using the flat file task?

Tony, let's not build this one little requirement at a time... how about posting a whole user (like I asked before, no private info, please) so we can help you...
--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 19, 2008 at 8:25 am

#791463
RE: Select date columns value which are older than 10 days from today?

Heh... did I make ya blow coffee out your nose, Matt? 😛
--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 19, 2008 at 7:27 am

#791432
RE: Vardecimal

Heh... yeah... nothing like the "TimeStamp" data type here... isn't hind site wonderful? :hehe:
--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 19, 2008 at 7:25 am

#791431
RE: Vardecimal

Heh... Hence the name... varDECIMAL 😛
--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 19, 2008 at 7:07 am

#791422
RE: Basic Query Taking Too Long

No link required, actually... The term "Well formatted" should be common knowledge. But even if it's not, here's what your text attachments look like because you have no carriage...
--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 19, 2008 at 7:03 am

#791419

Viewing 15 posts - 51,616 through 51,630 (of 59,102 total)