Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,856 through 36,870 (of 59,098 total)

RE: Are the posted questions getting worse?

Alvin Ramard (9/13/2010)
Speaking of the Bit datatype, here's an old one for you:
"There are 10 types of people in the world. Those that understand binary, and those who don't."
...
--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)

September 14, 2010 at 6:36 am

#1220627
RE: XML "CSV" Splitter

Dave Ballantyne (9/13/2010)
---- EDIT bum steer
Heh... "Mad cow"? 😀
--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)

September 13, 2010 at 11:23 pm

#1220447
RE: XML "CSV" Splitter

TheSQLGuru (9/13/2010)
Can I ask why everyone is putting their code inside a UDF? Can't the code just be inlined as necessary?
Actually, the testing I'm doing works against both methods...
--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)

September 13, 2010 at 11:18 pm

#1220445
RE: XML "CSV" Splitter

Brad Schulz (9/13/2010)
Hi Jeff...
Just wanted to quickly respond... I've been busy all day (mostly writing my T-SQL Tuesday Blog Post).
Regarding the plethora of CROSS APPLYs in my code for 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)

September 13, 2010 at 11:16 pm

#1220444
RE: Blocking on tempdb system tables

sporoy (9/13/2010)
What I'm trying to figure out is if the blocking unavoidable in these circumtances? Should I contact with SCOM support? This does not look as SQL's fault..
It's not SCOM's...
--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)

September 13, 2010 at 10:28 pm

#1220433
RE: Are the posted questions getting worse?

Heh... since Steve shut it down (probably a very good thing), I guess I'm a "bit" too late to make any further suggestions. I do have to admit 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)

September 13, 2010 at 10:25 pm

#1220431
RE: Are the posted questions getting worse?

GilaMonster (9/13/2010)
Hey Jeff. Please join the club of people that clearly don't know what a BIT column is. How dare you say that the working code is not working! :-D...
--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)

September 13, 2010 at 10:13 pm

#1220429
RE: Unexpected Columns being set to NULL with record updates

d_s_man (9/13/2010)
Im new to Partitioning so excuse my ignorance.
From what I can see these are real partitions. There is a file for each partition with partition function and range defined.
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)

September 13, 2010 at 12:14 pm

#1220240
RE: Searching for Plans

Eric Russell 13013 (9/13/2010)
Jeff Moden (9/12/2010)
The "best plan" is dictated only by four things and only two of those really matter where performance is concerned...
4. Code - This 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)

September 13, 2010 at 12:06 pm

#1220232
RE: Blocking on tempdb system tables

I absolutely agree with the above. You should just about never include a temp table in a transaction especially (but not limited to) the creation of a temp table.
--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)

September 13, 2010 at 12:01 pm

#1220227
RE: SQL SERVER 2000 DataType

Lennie (9/12/2010)
Hi Good Guys, :w00t:
I have found the solution to my non Stored Procedure or TRansactSQL SQL String. It working now on the VBNET2008 Form and 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)

September 13, 2010 at 11:43 am

#1220216
RE: XML "CSV" Splitter

@Wayne,
Yep... I was getting similar results (didn't want to post my results because I didn't want to "taint" people's opinions).
This is why I say I'm looking for a much better...
--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)

September 13, 2010 at 6:45 am

#1219996
RE: XML "CSV" Splitter

@dave-3,
Yep... understood especially on the plan. And thanks for the code. I'll go though it tonight.
I did make an entry on Brad's forum that there might be something...
--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)

September 13, 2010 at 6:38 am

#1219990
RE: Sql query help

I need to ask just because you're "new" to SQL. Are you 100% sure that you're using at least SQL Server 2005?
And, yeah... I agree. Wayne does 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)

September 13, 2010 at 4:56 am

#1219952
RE: XML "CSV" Splitter

Dave Ballantyne (9/13/2010)
Brad Schulz has done a nice round up
http://bradsruminations.blogspot.com/2010/08/integer-list-splitting-sql-fable.html
I'll have to revisit that one sometime in the near future because a proper Tally table solution is between 5 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)

September 13, 2010 at 4:36 am

#1219941

Viewing 15 posts - 36,856 through 36,870 (of 59,098 total)