Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,001 through 36,015 (of 59,102 total)

RE: Space used by NULL value in different data type columns

only4mithunc (11/21/2010)
Thanks a lot Jeff,
When I tried those two things, I'm able to see the difference... 🙂
And thank you for the feedback.
--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)

November 21, 2010 at 5:46 pm

#1253544
RE: unable to shrink log file

steveb. (7/24/2008)
-Take a full backup
-Change database to Simple logging
-Shirnk Log
-Change database back to full logging
Be careful though as Log files grow to a size that they need to, ...
--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)

November 21, 2010 at 5:43 pm

#1253542
RE: Transforming string for ImagePath

And, apparently, the REPLACE is not necessary. 😉
--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)

November 21, 2010 at 5:37 pm

#1253541
RE: Are the posted questions getting worse?

LutzM (11/20/2010)
bitbucket-25253 (11/20/2010)
...
All this gibbering and jabbering about age -- Your are all youngsters.
I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff Moden once...
--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)

November 21, 2010 at 5:31 pm

#1253539
RE: Space used by NULL value in different data type columns

only4mithunc (11/21/2010)
Friends,
Did you get a chance to look into my previous reply? 🙁
Mostly yes. You forgot to do two things in your testing. You really do need 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)

November 21, 2010 at 7:47 am

#1253494
RE: Pivot Query Question

The "hard part" has been done. Please try adding the additional column on your own. As you say, it's an INNER JOIN.
--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)

November 21, 2010 at 7:37 am

#1253493
RE: Running Total using T-SQL

Thanks for the "cover", Wayne. I haven't had the time to get to the forums much in the last 3 days. We have a problem at work and...
--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)

November 20, 2010 at 12:30 pm

#1253431
RE: How to Monitor for High CPU utilization in SQL Server

I can't wait for an article on the dashboard. 😛
--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)

November 20, 2010 at 1:24 am

#1253383
RE: FLATTEN OUT ROW BASED STRUCTURE TO COMMA DELIMITED

Paul White NZ (11/19/2010)
A better query plan is produced if you make the following small modification:
SELECT DISTINCT
attribute_id,
...
--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)

November 19, 2010 at 6:31 am

#1253005
RE: Use of temp table

Paul White NZ (11/19/2010)
GilaMonster (11/18/2010)
Jeff Moden (11/18/2010)
Actually, that's not the best advice. IIRC (Gail, please correct me if I'm wrong), Temp Tables have space reserved and the definition is...
--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)

November 19, 2010 at 6:29 am

#1253004
RE: Use of temp table

GilaMonster (11/18/2010)
Jeff Moden (11/18/2010)
Actually, that's not the best advice. IIRC (Gail, please correct me if I'm wrong), Temp Tables have space reserved and the definition is preserved for 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)

November 19, 2010 at 6:28 am

#1253002
RE: Running Total using T-SQL

The post where Paul White describes the beautiful safety check he wrote is at the following URL: http://www.sqlservercentral.com/Forums/Topic802558-203-3.aspx#BM859559
DO make sure you incorporate 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)

November 19, 2010 at 6:19 am

#1252997
RE: Running Total using T-SQL

Alex S-483693 (11/18/2010)
I'm pretty excited about this method (trawling through the article now) and plan to use it in a couple of other slow updates that I have (for 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)

November 19, 2010 at 6:12 am

#1252988
RE: Running Total using T-SQL

Alex S-483693 (11/18/2010)
If I am not wrong, this should work for your requirement. This splits the Running Total by SKU and sorts by Required (date). I assumed this...
--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)

November 19, 2010 at 6:08 am

#1252986
RE: Export with Headers

Steve Jones - SSC Editor (11/18/2010)
How can you export data from a query, using bcp, SQLCMD, etc. and include the column headers at the top? The export would be CSV...
--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)

November 18, 2010 at 8:13 pm

#1252830

Viewing 15 posts - 36,001 through 36,015 (of 59,102 total)