Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,016 through 30,030 (of 59,101 total)

RE: Teambuilding and Bonding

Ivanova (5/14/2012)
The other great advantage of email is that I get to choose when I answer it (assuming it's not truely urgent, which very little of it is). Phone or...
--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)

May 14, 2012 at 5:50 pm

#1487467
RE: Teambuilding and Bonding

TravisDBA (5/14/2012)
CYA is very practical.
Nah... CYA is all the cruddy emails that happen when you haven't done your job and provided or demanded proper documentation to begin with. Continuing...
--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)

May 14, 2012 at 5:46 pm

#1487464
RE: Teambuilding and Bonding

djackson 22568 (5/14/2012)
Same here, and the ones who complain about using email so much are ALWAYS the ones who like to blame others for their failures!
If you don't mind, I'll...
--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)

May 14, 2012 at 5:32 pm

#1487461
RE: transpose rows into columns without aggregate

nitin_456 (5/14/2012)
There can be maximum of 20 allocation per comm id and how can I do pivot on multiple columns.
It's easy. "Must look eye." Take a look 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)

May 14, 2012 at 5:25 pm

#1487457
RE: Converting an integer to datetime

dan-572483 (5/14/2012)
I stand corrected. Now why would a developer use anything other than a datetime to store a timestamp? It seems to lead to more complexity with no...
--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)

May 14, 2012 at 5:21 pm

#1487455
RE: Query performance issue

a2zwd (5/14/2012)
Hi all,
I have a table which has 120m rows.
Another table which is used in the join with above table that has 2m rows.
I have written 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)

May 14, 2012 at 4:40 pm

#1487442
RE: CTE

Just sort by the "Name" column that you built up instead of the ID.
--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)

May 14, 2012 at 4:21 pm

#1487438
RE: How many tables indexes are too many?

sdruid71 (5/14/2012)
I have a very large table with with over 40 fields and millions of records. There are currently 7 non-unique, non-clustered indexes on this table. There 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)

May 14, 2012 at 4:14 pm

#1487436
RE: Converting an integer to datetime

SQL_Enthusiast-AZ (5/14/2012)
Never mind. My inability to spell has struck me yet again. I was able to add the DATEADD(...) to to query and it worked... Once I spelled SUBMITDATE right......
--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)

May 14, 2012 at 4:09 pm

#1487434
RE: Converting an integer to datetime

dan-572483 (5/14/2012)
I believe the datatime datatype was new with SQL 2005,...
The DATETIME datatype has been around for a lot longer than SQL Server has been. It started out 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)

May 14, 2012 at 4:07 pm

#1487433
RE: RegEx for DBAs

David.Poole (5/14/2012)
Jeff Moden (5/13/2012)
I might go so far as to say that if youre trying to find items like the example you gave, then the data probably shouldn't be...
--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)

May 14, 2012 at 4:02 pm

#1487432
RE: Converting an integer to datetime

I believe it's based on the number of seconds since the 1980 epoch which means the following will make your life a whole lot easier if you take the time...
--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)

May 14, 2012 at 2:10 pm

#1487379
RE: Converting first letter of every word to uppercase

opc.three (5/14/2012)
bitbucket-25253 (5/12/2012)
opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some...
--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)

May 14, 2012 at 2:00 pm

#1487377
RE: Where are the good Senior Level DBA's?

JamesMorrison (5/14/2012)
It has been my experience that most IT people have no business even conducting interviews.
Many lack the understanding of the real goal of the interview.
Often it becomes more...
--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)

May 14, 2012 at 1:55 pm

#1487372
RE: does ss2008 maintain an internal timestamp of data updates?

Ummm.... are you talking about the trigger or the rowversion column because the rowversion column is virtually no overhead except for the physical column space and that's not any bigger...
--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)

May 14, 2012 at 1:47 pm

#1487367

Viewing 15 posts - 30,016 through 30,030 (of 59,101 total)