Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,976 through 21,990 (of 59,072 total)

RE: CHOOSE() a RAND() vowel not working???

Phil Parkin (1/7/2015)
If something is non-deterministic, then it's very possible for the re-evaluations of the object test to miss all of the WHEN's and produce a NULL if there...
--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 10:00 pm

#1768957
RE: Deployment Concept

Unless you have two systems where you can turn one off, deploy to it, and then do a switch to deploy to the other system, there's no guarantee that 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)

January 8, 2015 at 7:44 pm

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

dwain.c (1/8/2015)
Luis Cazares (1/8/2015)
Maddave (1/8/2015)
Jeff Moden (1/8/2015)
Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is...
--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 5:41 pm

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

ScottPletcher (1/8/2015)
Jeff Moden (1/8/2015)
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...
--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 4:04 pm

#1768924
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

Viewing 15 posts - 21,976 through 21,990 (of 59,072 total)