Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,656 through 20,670 (of 59,072 total)

RE: Boring or Scripting

xsevensinzx (5/18/2015)
Jeff Moden (5/18/2015)
TomThomson (5/18/2015)
Jeff Moden (5/17/2015)
Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does...
--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)

May 18, 2015 at 4:18 pm

#1798860
RE: Need Ammunition for Developers Doing Select *'s

Vyper426 (5/18/2015)
Ed Wagner (5/15/2015)
A SELECT * in a cursor...So that means if a column is added to a table the system uses, the interface breaks at every point where 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)

May 18, 2015 at 4:09 pm

#1798858
RE: Formatting a email from a SQL job

You can also get a decent example right out of "Books Online". Lookup sp_send_dbmail and look at the last example.
--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)

May 18, 2015 at 3:51 pm

#1798857
RE: Testing Simple Calculations and UDFs with tSQLt

Great article. I'm just not sure why anyone needs to use tSQLt for such a thing. It seems like an extra layer that's not needed. There's also...
--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)

May 18, 2015 at 3:43 pm

#1798855
RE: Accidentally set max server memory to 0

Eirikur Eiriksson (5/18/2015)
Jeff Moden (5/18/2015)
Just so that everyone knows, this does not work in a clustered environment.
Quick question Jeff, would restoring the latest master be of any help, IIRC 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)

May 18, 2015 at 3:09 pm

#1798849
RE: Accidentally set max server memory to 0

Just so that everyone knows, this does not work in a clustered environment.
--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)

May 18, 2015 at 12:04 pm

#1798755
RE: How to eliminate deadlocks involving 'Select' statements

bray_tim (5/18/2015)
Thanks Jeff, having one of those days!
Absolutely not to worry. My comment wasn't directed at you. It was directed at the people that I know have tons...
--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)

May 18, 2015 at 8:44 am

#1798650
RE: Boring or Scripting

TomThomson (5/18/2015)
Jeff Moden (5/17/2015)
Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does very well through...
--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)

May 18, 2015 at 8:37 am

#1798642
RE: Here are some SQL Server Interview Questions

andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
This one is actually true.
Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that understands and can easily do...
--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)

May 18, 2015 at 7:48 am

#1798615
RE: Here are some SQL Server Interview Questions

Eric M Russell (5/18/2015)
Jeff Moden (5/16/2015)
I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment...
--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)

May 18, 2015 at 7:42 am

#1798612
RE: What is the best way to copy the tables of a database...

I agree with Grant. You should be doing nightly backups anyway. Just do a restore of one system's backup to the other system.
--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)

May 18, 2015 at 7:27 am

#1798610
RE: Import XML only gives Null results

I was looking at the title of this post and thinking "Hmmmm, some XML that's actually space efficient". 😛
--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)

May 17, 2015 at 10:28 pm

#1798536
RE: Display all months even if values are NULL

Credits to Navy beans says the op probably doesn't care about the performance or technique improvements because he has a solution that works even though the rCTE isn't what any...
--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)

May 17, 2015 at 10:27 pm

#1798535
RE: rebuild index with sort in tempdb option ON

It's not possible to say why it suddenly started taking longer. It could be that someone did a major dataload or update. It could be that someone else...
--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)

May 17, 2015 at 10:24 pm

#1798534
RE: Byte Me: The Nectar of Life

TomThomson (5/13/2015)
I see no wine, beer or whicky so unless that's gaelic cofee he can't be a real dba.
Heh... that's not his belly sticking out. That's the pillow-tank that...
--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)

May 17, 2015 at 8:55 pm

#1798529

Viewing 15 posts - 20,656 through 20,670 (of 59,072 total)