Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,661 through 30,675 (of 59,101 total)

RE: logic explanation

Lynn Pettis (3/16/2012)
Jeff Moden (3/16/2012)
capn.hector (3/16/2012)
Jeff,
Depending on the application would using the created on date for the first modified date be better than some future date?
so in the above query...
--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)

March 22, 2012 at 6:50 pm

#1463121
RE: Fetch table name,size

paul.knibbs (3/22/2012)
Jeff Moden (3/22/2012)
{EDIT} I've also removed the columns from the code on this thread so that future readers don't run into a problem. My apologies on 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)

March 22, 2012 at 10:15 am

#1462861
RE: sql_variant

It's pretty simple. Most people store their "changes" in Audit tables as VARCHAR and use some other method (interrogate sys.columns or somesuch) to figure out what the datatype of...
--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)

March 22, 2012 at 6:26 am

#1462647
RE: Fetch table name,size

paul.knibbs (3/22/2012)
Just tested your code out, Jeff--why does it seem to return a maximum 2048 for the max row size, even in cases where I know the maximum row size...
--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)

March 22, 2012 at 6:02 am

#1462633
RE: Remove GUID within a String Field

dwain.c (3/20/2012)
Rats! I was looking at PATINDEX and STUFF to solve this but didn't make the leap from RegEx to using the LIKE patterning to identify the GUIDs.
Then 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)

March 21, 2012 at 6:22 pm

#1462487
RE: Disable and enable trigger

Jizzy Wig (3/21/2012)
I want to make sure people realise that enabling and disabling a trigger (usually as part of an archiving procedure) is completely normal and safe.
There is alot of...
--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)

March 21, 2012 at 7:20 am

#1462118
RE: Attracting Talent

Nope. But that would certainly have set a better tone for the interview.
--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)

March 21, 2012 at 6:37 am

#1462100
RE: Triangle Join - Can I do it right or a replacement?

sorry... haven't abandoned you. Had to get some sleep because I had to be to work very early to swap some drives on a Dev Box. Currently at...
--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)

March 21, 2012 at 6:34 am

#1462099
RE: Remove GUID within a String Field

There's no need for the rigors of setting up any kind of external RegEx to solve this simple problem. While people that know me are likely going 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)

March 20, 2012 at 9:13 pm

#1462007
RE: BCP out slow first time, fast after. Help!

Oliiii (3/20/2012)
Eugene (B),
Try with INSERT xxx WITH (TABLOCK) ... SELECT.
If your destination table is a heap then it should always be minimally logged (on SQL 2008 and +) and 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)

March 20, 2012 at 7:29 pm

#1461999
RE: I need to get the rank 0f the students without using the rank functions

GuruGPrasad (3/20/2012)
create table #temp (ranks int identity ,s_id int,s_name varchar(20),marks numeric(9,0))
Insert into #temp select * from student order by marks desc
select * from #temp
drop...
--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)

March 20, 2012 at 7:19 pm

#1461997
RE: I need to get the rank 0f the students without using the rank functions

nkcherukuri (3/20/2012)
Hi thanks got it..
select
empno,
ename,
deptno,
sal,
(select count(sal)+1 from emp b where...
--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)

March 20, 2012 at 7:14 pm

#1461996
RE: Triangle Join - Can I do it right or a replacement?

codebyo (3/20/2012)
All the values must be cumulative. For example, if the table above contains these rows:
Date: 01/01/2011, Product: Bike, Vendor: X, Total: 200
Date: 01/01/2011, Product: Car, Vendor: X, Total: 200
Date:...
--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)

March 20, 2012 at 7:00 pm

#1461994
RE: urgent

mamatha17.r (3/20/2012)
Its Assignment thanks for help....:-):-)
So... do you actually understand any of the solutions given or are you going to worsen the cheat?
--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)

March 20, 2012 at 6:12 pm

#1461984
RE: urgent

ColdCoffee (3/20/2012)
CELKO (3/20/2012)
This guy is trying to get us to do his job interview. Let's hunt him down and keep him from hurting his employer by letting them know what...
--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)

March 20, 2012 at 6:08 pm

#1461982

Viewing 15 posts - 30,661 through 30,675 (of 59,101 total)