Jeff Moden

Forum Replies Created

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

RE: What if interviewer is wrong?

GilaMonster (7/10/2014)
Jeff Moden (7/9/2014)
hoping that you'd explain how your previous company managed to make it so on a 1TB database.
Maybe I'm missing something, but the way I did it (SQL...
--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 10, 2014 at 10:25 am

#1728449
RE: What if interviewer is wrong?

dan-572483 (7/10/2014)
How can you tell if it creates a hidden snapshot - given that it's hidden?
Whether it did or not, it still runs in under 5 hours and there were...
--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 10, 2014 at 9:34 am

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

Eirikur Eiriksson (7/9/2014)
More for fun but fitting the discussion, kind of before and after:-D
😎
Before
create function sys.fn_numberOf1InBinaryAfterLoc (@byte binary, @loc int)
returns int
as
begin
declare @index int, @mark-3 int, @counter...
--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 10, 2014 at 12:12 am

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

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