Jeff Moden

Forum Replies Created

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

RE: scalable hardware solution for 10TB now to 100TB in 3 years

mlbauer (12/23/2010)
All queries will take twice the time for twice the data.
Not really true and "It Depends" pevails a whole lot in that area. Partitioned tables can really...
--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 7:32 pm

#1268722
RE: parsing email id from string

What if the string contains an "@" that isn't actually part of an email address?
--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 7:25 pm

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

weharrelson (1/3/2011)
FWIW, We have weekly imports of ~25MB of XML. The sp_xml_preparedocument method ran circles around the new ways (x.data.value...)
Care to share the snippet that imports those weekly files?
--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:41 pm

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

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