Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,141 through 40,155 (of 59,098 total)

RE: Normalization

Jeff Moden (1/23/2010)
So, when YOU create an address table, do you have a "second address" line or do you normalize it? Enquiring minds want to know. 🙂
I'd still like...
--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)

January 23, 2010 at 10:20 pm

#1107875
RE: extract days,hour,min,sec

I'd say you've made it hard on yourself...
SELECT STR(DATEDIFF(dd,0,GETDATE()-@Sql_Start_Time),5) + ' Days, '
+ DATENAME(hh,GETDATE()-@Sql_Start_Time) + ' Hours, '
...
--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)

January 23, 2010 at 10:14 pm

#1107873
RE: Where are you?

Heh... you're not lion... guess you'll have to grin and bear 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)

January 23, 2010 at 1:02 pm

#1107809
RE: SQL tables

As a side bar... That's one of the things I miss about SQL Server 2000 and Query Analyzer where you could just press {f4} for such a thing.
--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)

January 23, 2010 at 12:49 pm

#1107805
RE: SQL Scripts - How to run and get results

I've never done it so don't know for sure but rumor has it that C2 auditing is rather fierce in the amount of data it captures. I'm not sure...
--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)

January 23, 2010 at 12:47 pm

#1107804
RE: Normalization

So, when YOU create an address table, do you have a "second address" line or do you normalize it? Enquiring minds want to 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)

January 23, 2010 at 12:34 pm

#1107798
RE: How Do You Handle the Stress of Being a DBA?

Heh... lately for me, a better question would be "How do you deal with the stress of other DBA'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)

January 23, 2010 at 12:04 pm

#1107789
RE: Display date in DD/MM/YYYY HH:MI:SS:MMMAM

This will do it...
SELECT CONVERT(CHAR(10),GETDATE(),103) + ' ' + RIGHT(CONVERT(CHAR(26),GETDATE(),109),14)
--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)

January 23, 2010 at 11:57 am

#1107788
RE: Tempdb is full

CirquedeSQLeil (1/23/2010)
There is a poorly written runaway sql statement causing heavy tempdb usage.
Concur. In fact, I've found that to be the norm rather than the exception.
--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)

January 23, 2010 at 11:35 am

#1107785
RE: Where are you?

Detroit. We have Lions here, too, but they have no teeth. 😉
--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)

January 23, 2010 at 11:30 am

#1107782
RE: Finding duplicate row values

malleswarareddy_m (1/23/2010)
ok i did not hijack others thraed
but this is my urgent requirement report in company.
so i posted here understanding me
ok sorry.
As a side bar, any time something 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)

January 23, 2010 at 11:23 am

#1107781
RE: how to get only duplicate rows from table

malleswarareddy_m (1/22/2010)
the sample table looks like
1 malli o2o2020
2 malli 878hjh8
3 reddy ghhg5
4 reddy 56656
5 eswa ttt656
6 rama ettt
here 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)

January 23, 2010 at 11:13 am

#1107780
RE: extract days,hour,min,sec

Mad-Dog (1/23/2010)
Hi,
how can i extract the days,hour,min,sec from a datetime value when it compare to current date like this example?(final results like that
27 Days, 7 Hours, 19 Minutes, 7...
--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)

January 23, 2010 at 10:32 am

#1107771
RE: Is there any justification for really using SQL CLR

Yep... more than you can imagine.
--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)

January 23, 2010 at 10:21 am

#1107770
RE: HUGE Database Update (> 550 million rows)

Brian.Dunat (1/23/2010)
Jeff,
Thanks for the hint on the clustered index. I was checking out the table and the execution plan and was scrolling through everything that would be affected and found...
--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)

January 23, 2010 at 9:06 am

#1107763

Viewing 15 posts - 40,141 through 40,155 (of 59,098 total)