Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,881 through 32,895 (of 59,099 total)

RE: a=b=c?

R.P.Rozema (8/16/2011)
However, in situations where readability is more important than raw execution speed
You're absolutely barking up the wrong tree with me on that subject. 😉 For me, performance...
--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)

August 16, 2011 at 12:17 pm

#1369251
RE: a=b=c?

SQLSandwiches (8/16/2011)
I was just going for 3 variables but I do appreciate the explanation.
So if ALL isn't useful. Why still keep it around? MSSQL is released every couple years....
--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)

August 16, 2011 at 12:06 pm

#1369235
RE: SSIS 2005 two digit year

Try putting the cutoff year at 60 (NOT 49! That's going in the wrong direction!). That'll solve your immediate problem.
You're longer term problem is, of course, the 2...
--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)

August 16, 2011 at 12:45 am

#1368944
RE: Not Able to reduce % of Index Fragmentation Please suggest....Urgent..

I'm sure that Grant Fritchey or Gail Shaw will have the precise numbers in their head but, yes... small tables (especially those less than 1 extent) won't be defragged because...
--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)

August 16, 2011 at 12:39 am

#1368941
RE: a=b=c?

I've used ALL once before... to show the same thing. 😉
Still, I'm always open to something different... what else could you use ALL for? I ask because I've never...
--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)

August 16, 2011 at 12:35 am

#1368939
RE: Creating nested xml tree

I've gotta say it again... ya just gotta love XML tag bloat. All of this data would likely fit in a single well formed, properly delimited, single character delimited...
--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)

August 16, 2011 at 12:18 am

#1368937
RE: Extracting only the date part (leave out time)

A second run without rebuilding the test table shows a slightly different story, as well...
========== DATEADD/DATEDIFF ==========
SQL Server Execution Times:
CPU time = 1326 ms, elapsed...
--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)

August 16, 2011 at 12:05 am

#1368936
RE: Extracting only the date part (leave out time)

Evil Kraig F (8/15/2011)
Chuck Hottle (8/15/2011)
This is good and simple too.
SELECT CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
I was originally going to call this a bad idea, but I decided a little...
--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)

August 16, 2011 at 12:00 am

#1368935
RE: Extracting only the date part (leave out time)

Evil Kraig F (8/15/2011)
Jeff Moden (8/15/2011)
You might want to check again... what happens on May 31st?
I'm confused here Jeff, nothing bad happens on May 31 + 3 months. August...
--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)

August 15, 2011 at 11:35 pm

#1368933
RE: Get the count of a result set

My recommendation would be to lookup what @@ROWCOUNT might do for 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)

August 15, 2011 at 11:12 pm

#1368930
RE: a=b=c?

I believe the following will do the trick according to the updated requirements quite simply.
DECLARE @a int = 102733019,
@b-2 int = 102733019...
--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)

August 15, 2011 at 11:07 pm

#1368929
RE: Does querying a view extract values for all rows before WHERE?

Eliyahu (8/14/2011)
Now is the question:
When I run SELECT * FROM myView WHERE myCondition, will the SQL Server first extract values from the XML column for all 10,000 rows and then...
--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)

August 15, 2011 at 5:00 pm

#1368900
RE: Extracting only the date part (leave out time)

You might want to check again... what happens on May 31st?
--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)

August 15, 2011 at 4:27 pm

#1368880
RE: How do I get an entry level job with a cert?

SQL Kidd (8/14/2011)
Ha-ha I'd like to thank you all for helping me with my non-SQL related mess. Sorry for this garbage and I apologize to everyone for this. I...
--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)

August 15, 2011 at 7:31 am

#1368595
RE: Are the posted questions getting worse?

Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...
Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close...
--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)

August 12, 2011 at 8:55 pm

#1368301

Viewing 15 posts - 32,881 through 32,895 (of 59,099 total)