Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,236 through 23,250 (of 59,099 total)

RE: What if interviewer is wrong?

dan-572483 (7/9/2014)
Well, I have confirmed with someone still working at my former employer that a DBCC CHECKDB job I set up to run overnight on a 1TB+ production database shows...
--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)

July 9, 2014 at 9:18 pm

#1728249
RE: OpenRowset Issue

What is it that you actually want to do? Are you just trying to insert data or do you want it to insert the data and then tell 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)

July 9, 2014 at 8:08 pm

#1728248
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

sqldriver (7/9/2014)
Does anyone else smell spackle? 🙂
🙂
--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)

July 9, 2014 at 8:06 pm

#1728247
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

mister.magoo (7/9/2014)
One to add to the list:
5. Use a single statement WHILE whenever possible (i.e. no BEGIN...END) and you may be surprised at the performance - especially when recoding 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)

July 9, 2014 at 8:05 pm

#1728246
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

sqldriver (7/7/2014)
Jeff Moden (7/7/2014)
Luis Cazares (7/7/2014)
david.holley (7/7/2014)
Jeff Moden (7/7/2014)
jfogel (7/7/2014)
Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses...
--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)

July 9, 2014 at 5:16 pm

#1728237
RE: Optimize SQL

I love being the one with the slowest machine on the block. It means that when I write something that run fast on it, it's usually going to smoke...
--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)

July 9, 2014 at 5:00 pm

#1728235
RE: BCP

So.... any luck here?
--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)

July 9, 2014 at 4:47 pm

#1728233
RE: OpenRowset Issue

I guess the point trying to be made is why would you do a SELECT * here? The remote store procedure returns no rows. It only does INSERTs.
--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)

July 9, 2014 at 4:25 pm

#1728228
RE: What are the options for splitting/reducing large mdf files?

azenon (6/4/2013)
I have a database with 2 mdf files. One file is 750gb and the other file is 112gb. There are performance issues with backing up this database and 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)

July 9, 2014 at 2:51 pm

#1728221
RE: Unused space in a table

Vets5 (7/9/2014)
Hello all,
Following a large cleanse of data I now have a lot of unused space in a table. The problem I have is this is not reflected in 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)

July 9, 2014 at 12:28 pm

#1728189
RE: Doing healthcheck on 40+ SQL Servers centrally.

Just a reminder... ask yourself what happens if the "central" system goes down.
--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)

July 9, 2014 at 12:20 pm

#1728187
RE: Approximate hours per month to monitor and maintain the health of MSSQL databases?

So far, I haven't seen much in this thread insofar as a "Business Continutiy Plan". Shoot... I don't even see anything about backups.
--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)

July 9, 2014 at 12:18 pm

#1728186
RE: Index Fragmentation?

ScottPletcher (7/9/2014)
...identities are vastly over-rated as a clustering key, and on average are best for only about 15-25% of tables
To that I'll say [font="Arial Black"]"IT DEPENDS"[/font].
--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)

July 9, 2014 at 12:05 pm

#1728180
RE: Interview question :critical issue faced by dba

SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup." 😉
Was that also a failure?:w00t:
Heh... no. I studied real hard on...
--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)

July 8, 2014 at 8:18 am

#1727792
RE: Interview question :critical issue faced by dba

Oh, I don't mind open ended questions for the very reasons you mean. I just hate THOSE types of open ended "explain to me how you've failed" questions. ...
--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)

July 8, 2014 at 7:02 am

#1727753

Viewing 15 posts - 23,236 through 23,250 (of 59,099 total)