Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,311 through 20,325 (of 59,072 total)

RE: prevent sysadmin for access

Still, I continue to think it odd that possibly unqualified users can make changes through a GUI that might not have audit capabilities but DBAs aren't allow to see what...
--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 17, 2015 at 9:26 am

#1806112
RE: Need Ammunition for Developers Doing Select *'s

vliet (6/17/2015)
As much as I do agree with all the arguments against using SELECT * I still think that your developer does not have to change this bad habit until...
--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 17, 2015 at 9:15 am

#1806103
RE: prevent sysadmin for access

Sanz (6/17/2015)
Why would you want to deny access to sysadmin ?
Because a lot of companies make the huge mistake of allowing users and developers to have sysadmin privs. Only...
--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 17, 2015 at 9:07 am

#1806099
RE: Indexing Dates

DonlSimpson (6/16/2015)
pederson1234 (6/16/2015)
Hey all, thanks for the feedback, i'm not quite there yet... Trying to simplify how I'm stating my need:
This is what my table looks like:
Customers
Name, Date
‘John’, ‘2015-01-01’
‘John’,...
--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 4:31 pm

#1805923
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

Viewing 15 posts - 20,311 through 20,325 (of 59,072 total)