Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,211 through 39,225 (of 59,072 total)

RE: DateTime input with time always at 00:00:00.0000

john.campbell-1020429 (3/22/2010)
select cast(cast(getdate() as varchar(12)) as datetime)
gives
2010-03-22 00:00:00.000
John.
Like I said in my previous post above... that's a bad idea for performance.
--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, 2010 at 7:23 am

#1137582
RE: what to call the daily reporting server?

Heh... and whatever you don't, don't put dashes in the name. Use underscores if you must but never dashes. (Well, unless you also have a great amount of love...
--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, 2010 at 7:22 am

#1137581
RE: Table Splitting

DBTeam (3/22/2010)
Hi All,
I have 28+ million table with 30 columns. Now we want to split into
multiple tables.
It having the information
like name info, address info , company info, employees,...
--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, 2010 at 7:16 am

#1137571
RE: where to learn 'advanced' querying

AndrewSQLDBA (3/22/2010)
I think the BOL tells all
I agree that it's a very good start but it won't teach you to think of things like how to use a Tally 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)

March 22, 2010 at 7:12 am

#1137568
RE: Does a development DBA need to learn dot.net language. ?

DonaldW (3/22/2010)
Jeff Moden (3/21/2010)
I guess I'm the oddball. I've totally removed myself from such languages and have concentrated on T-SQL. Sounds stupid, I know, but when folks hire...
--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, 2010 at 6:44 am

#1137543
RE: Representing a hierarchy from comma separated values

Thanks for posting the solution. I apologize... for some reason I wasn't getting the fact that you were trying to create the Adjacency Set from the Hierarchical Path. ...
--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, 2010 at 5:47 am

#1137509
RE: Selecting list of month numbers between two dates

Thanks for the feedback, sivakumar.
--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, 2010 at 10:24 pm

#1137407
RE: DateTime input with time always at 00:00:00.0000

Agreed on the FLOAT conversion. Bad thing to do for the future.
Same goes with the CONVERT not because it's a bad thing for the future but because...
--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, 2010 at 10:20 pm

#1137405
RE: How to transform table with few rows to one row?

Jagger-784276 (3/21/2010)
Hi,
I am beginner.Just an example. If I have table with 3 rows and 3 columns:
customer number notes last visit...
--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, 2010 at 10:00 pm

#1137403
RE: Dyamic SQL Cursor is not working in SQL 2008

lmu92 (3/21/2010)
Sounds like "fun" to write software in an unknown language...
Heh... I've found that a lot of people who write T-SQL are actually writing in an unknown language. 😛
--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, 2010 at 9:59 pm

#1137402
RE: compare dates

lmu92 (3/21/2010)
Hi Prakash,
either the column names you provided is wrong or you're using the wrong column (PId=31).
Other than that I guess you want to find the rows where your parameters...
--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, 2010 at 9:53 pm

#1137400
RE: Does a development DBA need to learn dot.net language. ?

I guess I'm the oddball. I've totally removed myself from such languages and have concentrated on T-SQL. Sounds stupid, I know, but when folks hire me, they're hiring...
--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, 2010 at 9:36 pm

#1137397
RE: Ensure Unique Value Across Records

SwePeso (3/21/2010)
david.c.holley (3/19/2010)
Is there a way to do this AND allow Nulls? In other words, the when the WindowsUserId is provided, it must be unique, but it may not exist...
--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, 2010 at 9:17 pm

#1137395
RE: Selecting list of month numbers between two dates

BTW... you should never find the last day of the month because you may miss all but the first instant of that last day all together. Instead, you should...
--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, 2010 at 9:15 pm

#1137394
RE: Selecting list of month numbers between two dates

sivakumar.ss (3/20/2010)
Hi jeff,
xlnt solution.......
One doubt !
My requirement is like that instead of start date of every month [01/04/2007], i required end date of every month [31/04/2007]
bcoz no. of days...
--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, 2010 at 9:12 pm

#1137393

Viewing 15 posts - 39,211 through 39,225 (of 59,072 total)