Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,341 through 20,355 (of 59,098 total)

RE: Indexing Dates

p.s. The ROW_NUMBER method I mentioned previously will still work for 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)

June 16, 2015 at 3:00 pm

#1805904
RE: Indexing Dates

Is January 1st a holiday for 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)

June 16, 2015 at 2:54 pm

#1805902
RE: Indexing Dates

p.s. You're brand new here. Welcome aboard! 🙂
The people on these forums generally like to test their answers before they post them. Please help those that want...
--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)

June 16, 2015 at 12:57 pm

#1805844
RE: Indexing Dates

pederson1234 (6/16/2015)
Hello SQL ServerCentral,
I have a quick question. I am trying to index dates to numbers with a large data set.
The first colums is index, the next is FactorsS,...
--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)

June 16, 2015 at 12:55 pm

#1805842
RE: Delimiters - Importing Data - SQL Server Import Wizard

You're probably good to go then. If it were something that needed to be done on a regular basis, we likely could have hammered it out with BULK INSERT...
--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)

June 16, 2015 at 7:48 am

#1805739
RE: xp_cmdshell --> "Access is denied."

Maxxxie74 (6/16/2015)
12. Finally, don't forget to grant non-sysadmins the right to run xp_cmdshell:
grant execute on xp_cmdshell to [DOMAIN\username]
Good post but you don't ever want to grant users to execute xp_CmdShell...
--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)

June 16, 2015 at 7:44 am

#1805738
RE: Primary Key / Index Question

Jeff Moden (6/3/2015)
David Burrows (6/3/2015)
Jeff Moden (6/3/2015)
If the PeriodNo is ever increasing, then yeah, I agree.
Thanks Jeff
Yes PeriodNo will always be increasing
I will go with Tom's suggestion 🙂
Just one...
--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)

June 16, 2015 at 7:35 am

#1805735
RE: Delimiters - Importing Data - SQL Server Import Wizard

Is this a one-off exercise or something that will need to be done on a regular basis, Kevin?
--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)

June 16, 2015 at 7:31 am

#1805734
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Sorry, NO.
What is PASS anyway ?
PASS is the "Professional Association for SQL Server". It's responsible for many things in the SQL Server community including but not limited...
--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)

June 16, 2015 at 7:14 am

#1805727
RE: log file does not match primary file

This is going to sound terrible but I believe that you've just proven that the "3rd Party Backup Guys" aren't quite up to snuff on how to do Point-in-Time restores....
--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)

June 15, 2015 at 4:30 pm

#1805608
RE: OPENROWSET problem

sgmunson (6/15/2015)
Jeff Moden (6/12/2015)
sgmunson (6/12/2015)
Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect a registry...
--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)

June 15, 2015 at 4:13 pm

#1805606
RE: xp_cmdshell --> "Access is denied."

rightontarget (6/2/2015)
Thanks Jeff,
2008 server (A) runs under "local system" account
2012 server (B) runs under "qa" account
Do I need to add "local system" to the "administrator" group on server B?
Thanks,
Most 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)

June 15, 2015 at 4:06 pm

#1805603
RE: Executing SQL Job from SProc

Definitely a puzzle. My apologies. Hopefully, someone else can help on this problem because I'm out of tricks on this one. :blush:
--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)

June 15, 2015 at 9:28 am

#1805497
RE: OPENROWSET problem

n.heyen (6/15/2015)
Thanks for the suggestion Jeff. I did find the db owner was changed to me after I refreshed the contents from a backup. (Have to remember to do 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)

June 15, 2015 at 9:26 am

#1805495
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Ann Arbor, MICHIGAN 48105
Drop by if you are closeby
Auburn Hills, MI here. Do you ever go to the PASS meetings in Southfield?
--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)

June 15, 2015 at 9:23 am

#1805492

Viewing 15 posts - 20,341 through 20,355 (of 59,098 total)