Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,506 through 35,520 (of 59,099 total)

RE: First time semi-complex query - its slow!!!

CELKO (1/3/2011)
Jeff Moden (12/30/2010)
Ok... forgot a question I was going to ask you, Joe. If you're so set against "mag tape" technology, why do you always recommend converting 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 3, 2011 at 6:31 pm

#1268714
RE: Clouds Are In our Future

Steve Jones - SSC Editor (1/3/2011)
Jeff Moden (1/3/2011)
If someone doesn't already have enough reasons to avoid the cloud, here is a recent post that may contain some additional reasons 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 3, 2011 at 6:13 pm

#1268710
RE: Are the posted questions getting worse?

Craig Farrell (1/3/2011)
Jack Corbett (1/3/2011)
Glad you found out the owner and go the issue solved.
Happy New Year and Birthday to you as well. I just wish I was 35...
--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 3, 2011 at 6:08 pm

#1268709
RE: Are the posted questions getting worse?

Brandie Tarvin (1/3/2011)
Quick question for those on LinkedIn. I just received a message over the past two days (two messages actually) asking for advice on performance tuning tools. The messages...
--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 3, 2011 at 6:05 pm

#1268708
RE: Are the posted questions getting worse?

Craig Farrell (1/3/2011)
For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.
Happy...
--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 3, 2011 at 6:01 pm

#1268706
RE: Performance Goals

Tara-1044200 (1/2/2011)
Hi
I was just wondering what would be the perforamnce golas in general for a DBA, I was doing all contracy jobs before where i was not worried about 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)

January 3, 2011 at 6:51 am

#1268458
RE: Performance Goals

Heh... Grant. Spoken like a true DBA but that's not the type of "performance goals" being talked about here. It's the ol' "fill-in-your-own-evaluation-because-your-manager-doesn't-know-how-to-evaluate-you" time again. 😉
--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 3, 2011 at 6:47 am

#1268456
RE: Happy 2011

2011 is going to be a great year! Happy New Year Everyone!
--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 3, 2011 at 6:44 am

#1268453
RE: Clouds Are In our Future

If someone doesn't already have enough reasons to avoid the cloud, here is a recent post that may contain some additional reasons you may not have been aware of...
http://www.sqlservercentral.com/Forums/Topic1041653-392-1.aspx
Rumor 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)

January 3, 2011 at 6:43 am

#1268451
RE: Clouds Are In our Future

Heh... we found out how to guarantee hard disk capacity being available for the next 5 years... all we had to do was cleanup the crap the old "DBAs" left...
--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 3, 2011 at 6:36 am

#1268445
RE: restore database failed because database size would exceed your licensed limit of 4096 MB

deba_20032004 (1/3/2011)
Dear Sir,
I am in big trouble I am using SQL Server Express Edition Version 9.00.3042.00
When I am restoring my database size approx 6GB then giving below the message as...
--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 3, 2011 at 6:24 am

#1268434
RE: SQL Server High Avilabilty Solutions

Nick123-481228 (12/22/2010)
Thanks for your advise.
On price table it does :
if Price Date exists with different value then moves data from Main table to archieve table
then Updates with new values 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)

January 3, 2011 at 6:12 am

#1268425
RE: Regarding cursors

sqlpassion (1/2/2011)
Hi all,
I ran a cursor (XYZ) to delete some records from a table.
Can we somehow track
cursor name
cursor ran date time
cursor duration (ran time)
affected tables
affected records
or atleast 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 3, 2011 at 5:54 am

#1268422
RE: Loading XML Data into SQL Server (SQL Spackle)

I have to admit, I've not yet had to enter the realm of loading XML files. But now I know where to go for a quick reference. 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 3, 2011 at 12:49 am

#1268376
RE: Are the posted questions getting worse?

RBarryYoung (1/1/2011)
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congrats Gus! (Man, everyone is passing me!)
Well, as...
--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 2, 2011 at 4:55 pm

#1268340

Viewing 15 posts - 35,506 through 35,520 (of 59,099 total)