Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,006 through 22,020 (of 59,098 total)

RE: Platform Comparison - SQL vs. Oracle (Need benefits)

I'll add that if the shop will primarily be a .NET shop, I'd go with SQL Server.
On a personal note, I've found Oracle to be pretty restrictive in some of...
--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 8, 2015 at 1:57 pm

#1768897
RE: BCP in tab separated file to a table

That's from a pretty old post of mine. Jet drivers are not available on 64 bit machines. You'll need the new ACE drivers from MS. It's pretty...
--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 8, 2015 at 1:52 pm

#1768895
RE: Using BCP to bulk load a table. But getting garbage characters.

The problem could be that the file is actually a Unicode file and you might need to use the "-w" option. Look at the first 3 bytes of 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 8, 2015 at 1:37 pm

#1768890
RE: Ola's Maintenance Solution- differential backups have .bak instead of .dif - will this cause any problems with restore

plamannkathy (1/8/2015)
Hi All
I am using Ola Hallengren's Maintenance Solution. I noticed that the differential backups have the .bak extension. Does anyone know how I could change this to a .dif...
--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 8, 2015 at 8:41 am

#1768804
RE: how to answer interview question "what is the hardest sproc you have created?"

Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is "How do you get the current...
--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 8, 2015 at 8:31 am

#1768798
RE: how to answer interview question "what is the hardest sproc you have created?"

I don't think it was a weird question at all and Lowell is [font="Arial Black"]absolutely [/font]spot on about the question. There's so much that you can tell about 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)

January 8, 2015 at 8:12 am

#1768785
RE: Are the posted questions getting worse?

SQLRNNR (1/7/2015)
So, just a point of curiosity.
Will there ever be a fix for that snafu a bit back that obliterated points for a bunch of threadizens?
Heh... nah... just renenter all...
--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 7, 2015 at 4:47 pm

#1768646
RE: Are the posted questions getting worse?

Ed Wagner (1/7/2015)
Koen Verbeeck (1/7/2015)
Sean Lange (1/6/2015)
I agree completely. Maybe a nice enhancement would be to conditionally add a button in a thread that you are subscribed to that 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)

January 7, 2015 at 4:46 pm

#1768644
RE: how to answer interview question "what is the hardest sproc you have created?"

JP10 (1/7/2015)
I was stumped because there really hasn't been a hard sproc mostly all I do is join tables and return the data. Anybody have suggestions on how 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)

January 7, 2015 at 1:20 pm

#1768588
RE: "Best Practices" Questions

All six of those recommendations are absolute cannon fodder written by people who obviously have no clue about anything having to do with SQLServer. Some of them are, 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)

January 7, 2015 at 1:16 pm

#1768587
RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Herpington_McDerpington (1/6/2015)
@MWise - I've a question I'm hoping you can assist with. I've done some searching but have been unable to come up with a solution so far.
Thus far I've...
--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 7, 2015 at 9:12 am

#1768501
RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Herpington_McDerpington (1/6/2015)
Thank you both for your assistance. I'm probably going to go the SSIS route since we've a good amount of existing packages today (and xp_cmdshell is presently disabled). Thanks...
--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 7, 2015 at 9:10 am

#1768499
RE: How to hide/disable the menus New Database, Restore Database in SQL Server Management Studio

Grant Fritchey (1/6/2015)
One other point, I'm not sure what industry you're working in, but many, especially healthcare, now have criminal penalties if you expose personal data to people without permission...
--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 6, 2015 at 11:44 pm

#1768333
RE: Are the posted questions getting worse?

dwain.c (1/6/2015)
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days 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)

January 6, 2015 at 11:36 pm

#1768332
RE: cpu consumption rate

djordan 4543 (1/6/2015)
I found the solution from this hp article http://www8.hp.com/h20195/v2/Getdocument.aspx?docname=4AA4-2072ENW I am able to calculate Cpu consumption core rate at 360 mb/s
It won't help. As with every installation...
--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 6, 2015 at 11:34 pm

#1768331

Viewing 15 posts - 22,006 through 22,020 (of 59,098 total)