Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,016 through 39,030 (of 59,072 total)

RE: Get Date only from getdate() function

wallace.dave (4/5/2010)
I thnk it is a good solution if you work (like me) in an environment where you must try wherever possible to adhere to cross platform standards - I'm...
--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)

April 5, 2010 at 9:14 pm

#1146240
RE: XCOPY depreiated, use ROBOCOPY

Lynn Pettis (2/9/2010)
I have found that XCOPY has been depreciated in Windows Server 2008 and we should be using ROBOCOPY.
Can anyone point me toward more documentation on ROBOCOPY? 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)

April 5, 2010 at 9:03 pm

#1146228
RE: Cause of a lock being placed on the database

Bill Kline-270970 (4/2/2010)
We have a third-pary application and the users are complaining about performance.
...
Can someone enlighten me?
Yes... it seems that everyone approaches the problem of 3rd party code incorrectly......
--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)

April 5, 2010 at 9:00 pm

#1146224
RE: how can i do this convert

Here's the necessary tweek to cfradenburg's good code to make it work without surprises...
declare @param1 nvarchar(10)
set @param1 = '4,8,12'
declare @current_datetime datetime
set @current_datetime = getdate()
declare @get_min varchar(2)
select @get_min = datepart(mi,@current_datetime)
if patindex('%,'+@get_min+',%',','+@param1+',')...
--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)

April 5, 2010 at 8:54 pm

#1146222
RE: how can i do this convert

cfradenburg (4/5/2010)
Personally, if possible, I like the idea of storing the list of values in a table better because it ends up being more flexible. But if that doesn't...
--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)

April 5, 2010 at 8:49 pm

#1146216
RE: staging table and indexes

Rob Schripsema (3/25/2010)
pablavo (3/24/2010)
I should have added that the main table will be truncated before every import and the new data added to it. So you suggest that it's a...
--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)

April 5, 2010 at 8:42 pm

#1146208
RE: ever take a salary cut to move into a field you wanted experience in?

winston Smith (3/8/2010)
ive been working with sql server for 4 or so years from a support and admin point of view. im not a fulltime administrator, but i do a...
--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)

April 5, 2010 at 8:30 pm

#1146204
RE: Answering to the Business

david_wendelken (4/5/2010)
Jeff Moden (4/5/2010)
What if we as developers or database people had a way to present different options to business people in more clear cut terms.
Interesting idea but reality gets...
--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)

April 5, 2010 at 8:27 pm

#1146203
RE: I don't know how to do it :(

COldCoffee (4/5/2010)
Jeff Moden (4/5/2010)
That will work for only 1 level of approval.
Jeff i did not have the time to execute the query, my bad :doze:.. but the solution using the...
--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)

April 5, 2010 at 8:13 pm

#1146196
RE: Modifying Trigger

Are you logged in with SysAdmin privs?
--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)

April 5, 2010 at 7:55 pm

#1146182
RE: How much fees MCITP SQL 2005 DBA 6695 Certification

ssk0507 (4/5/2010)
is Certification is necessary for all organizations.?
Heh... that's been the subject of many a heated debate. My experience has been that people with certifications haven't learned much 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)

April 5, 2010 at 7:52 pm

#1146178
RE: Get top 5 highest value columns using tsql

Sql Student-446896 (4/5/2010)
Thanks a lot. I tried soemthing like this initally, but did not do order by. I did give a sample table (i has to edit initial post) ...dont...
--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)

April 5, 2010 at 7:44 pm

#1146168
RE: Getting decent sql server performance despite a slow drive

TheSQLGuru (4/5/2010)
Marts, I HIGHLY recommend that you try to convince your company to hire a performance tuning professional for a day or two to give your system a review and...
--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)

April 5, 2010 at 7:38 pm

#1146165
RE: BI Certification

Heh... a bit ironic... you lost your job to the recession and it was because the BI failed to begin with. 😉
--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)

April 5, 2010 at 7:30 pm

#1146160
RE: Answering to the Business

What if we as developers or database people had a way to present different options to business people in more clear cut terms.
Interesting idea but reality gets in the way....
--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)

April 5, 2010 at 7:29 pm

#1146159

Viewing 15 posts - 39,016 through 39,030 (of 59,072 total)