Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,611 through 8,625 (of 59,098 total)

Reply To: User accounts

Perhaps the following will help...
https://www.databasejournal.com/features/mssql/using-powershell-to-generate-logins-server-and-database-permissions.html
--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)

September 25, 2019 at 12:03 am

#3683151
Reply To: Removing a corrupted filegroup

What you need to do now is figure out why the data became corrupted. Do you have a disk or controller going bad? Was there a sudden power outage that...
--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)

September 24, 2019 at 11:58 pm

#3683150
Reply To: User accounts

Sue_H wrote:
The Generate Scripts is at the database level so that can also cause some problems - the logins need to be there as that tool generates statements like CREATE...
--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)

September 24, 2019 at 11:53 pm

#3683149
Reply To: DELETE SQL Query

Considering the content of the delete table, I'm thinking that you also need to include the ID in the delete criteria.
--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)

September 24, 2019 at 10:51 pm

#3683131
Reply To: SQL Licencing and a move to Opensource RDBMS'

Whenever someone proposes such a massive change, I always ask them to show me their prototype and prove that it can actually do the job. I'm sometimes overridden but my...
--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)

September 24, 2019 at 10:47 pm

#3683130
Reply To: Security Best Practices Question

Bennett Scharf wrote:
Does anyone have any thoughts on this?
Yes... tell them sorry but NO. There should never be shared logins, period. The closest you should ever come to something like shared...
--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)

September 24, 2019 at 10:45 pm

#3683129
Reply To: UpdateStatistics

p.s. Stop doing REORGANIZE on tables that don't have LOBs or tables that do have them but they don't need to be compacted. You're just blowing out your log file...
--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)

September 24, 2019 at 10:37 pm

#3683128
Reply To: UpdateStatistics

gana79950 wrote:
Hi Jeffrey,
Right after running IndexOptimise, I'm seeing that the rows_sampled column going back to a small percentage of the total rows.
Any thoughts?
Yes... carefully read the documentation that Ola provides...
--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)

September 24, 2019 at 10:33 pm

#3683127
Reply To: Update statement is very slow recently
drew.allen wrote:
ScottPletcher wrote:
One should always try to avoid a function on a table column being used for lookup. Therefore, for the last JOIN, do this instead:
```
 ...
```
--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)
September 24, 2019 at 9:25 pm

#3683109
Reply To: User accounts

sp_Help_RevLogin does not migrate server level privs. You'll need to do a search for a proc the will generate a script for those 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)

September 24, 2019 at 9:22 pm

#3683108
Reply To: ASCII sql server

What do you mean when you say "but still people can login using exponential numbers"?
--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)

September 24, 2019 at 9:20 pm

#3683107
Reply To: After 2014 to 2017 Upgrade, table unused space growing massively.

David Burrows wrote:
Jeff Moden wrote:
TF 1118 and 1117 are automatically implemented in 2016. You can turn them off for all databases except for TempDB. I wouldn't turn 1118 off anywhere but 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)

September 24, 2019 at 8:55 pm

#3683102
Reply To: What value need to be set for MAXDOP ?

I agree with the others about MAXDOP and Cost Threshold for Parallelism (CTP from here on) being more of an observational art rather than a science. I also agree that...
--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)

September 24, 2019 at 3:44 pm

#3682975
Reply To: After 2014 to 2017 Upgrade, table unused space growing massively.

jimkern wrote:
I have a suspicion that the same behavior would have been seen in SQL2016, but no proof and no reason to personally research it at the moment. BTW...we are...
--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)

September 24, 2019 at 2:51 pm

#3682958
Reply To: Remove first comma from stuff

Papil wrote:
Hi,
I am doing STUFF in my query which is concatenating the blank data too and data looks like below. Sometimes there is space+comma and sometimes only comma in 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)

September 23, 2019 at 10:13 pm

#3682746

Viewing 15 posts - 8,611 through 8,625 (of 59,098 total)