Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,866 through 41,880 (of 59,067 total)

RE: Help writing a SQL

Turn off the execution plan and see what you get.
--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 18, 2009 at 12:18 pm

#1055791
RE: Are the posted questions getting worse?

Paul White (9/18/2009)
¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i
Heh... I guess it literally depends on how you look at it. 😛
I've gotta know......
--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 18, 2009 at 9:35 am

#1055690
RE: Help writing a SQL

That works but be careful... recursive CTE's are as slow as a While Loop in most cases and are actually a form of RBAR.
--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 18, 2009 at 6:54 am

#1055557
RE: Pulling Filename from Windows directory into table

erouse (9/18/2009)
Attached file shows results 250 to 260. Note that after row 255 all the file details are the same yet the row number changes.
That looks like a bug in...
--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 18, 2009 at 6:50 am

#1055554
RE: How To Efficiently Index Using a VARCHAR Column?

Matt Miller (#4) (9/17/2009)
With a combo like that - be sure to say hi to the Pink Elephants that come by:)
Ohhhhh... THAT's what those are. 😀
--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 18, 2009 at 6:40 am

#1055547
RE: Parse data colunm into 3 columns

Thanks for the table statement. This will be easy and, no, it doesn't matter what it looks like, we don't need to go through the rigors of XML 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)

September 18, 2009 at 6:36 am

#1055546
RE: Single table format

DBCC UPDATEUSAGE does nothing more than update the sysIndexes table with the latest information. It may take a while to run but it will cause no harm.
As for not...
--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 18, 2009 at 6:31 am

#1055543
RE: Help writing a SQL

Heh... I'm actually worse... I just don't let people put CLR's in my systems. It's not that I'm against them... it's that they're not worth having to go through...
--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 17, 2009 at 10:56 pm

#1055381
RE: how to write the query with sub sub query

rajeshhalyal (9/17/2009)
I have a field in table which contains comma delimited id values for each related record.
Now I want to find the records from main table with Ids not in...
--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 17, 2009 at 10:48 pm

#1055378
RE: how to write the query with sub sub query

lmu92 (9/17/2009)
This link should help you further.
Heh... not so funny, Lutz 😉 ... the very first article that shows up contains both a UDF and a While Loop. ...
--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 17, 2009 at 10:39 pm

#1055376
RE: Why do we need to reboot the SQL server..?

I'm with Grant... you should be able to run a server for years without a reboot. I'm also with the others on shrinking stuff. Don't do it unless...
--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 17, 2009 at 10:34 pm

#1055374
RE: Parse data colunm into 3 columns

Ah... almost forgot... I need to know the name of the table and I need to know some details about what the Primary Key is. The easiest way 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)

September 17, 2009 at 10:14 pm

#1055366
RE: Parse data colunm into 3 columns

vmon,
Will the single column ALWAYS contain the data in the same order?
--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 17, 2009 at 10:12 pm

#1055364
RE: Parse data colunm into 3 columns

vmon (9/17/2009)
I have data stored in a single varchar(500) column. It contains data that is pipe delimited, 3 pieces of information that I want to put in 3 seperate...
--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 17, 2009 at 10:11 pm

#1055363
RE: Help writing a SQL

Greg Snidow (9/17/2009)
Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? ...
--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 17, 2009 at 10:06 pm

#1055358

Viewing 15 posts - 41,866 through 41,880 (of 59,067 total)