Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,581 through 8,595 (of 59,072 total)

Reply To: How to check the log of Export Import database wizard

I have to ask... what does the Export/Import Wizard have to do with a Database Restore?

A Database Restore should show up in the SQL Server log.
--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 2:14 am

#3683162
Reply To: User accounts

Ah... got it, Sue. It looked like you were referencing my reply. Sorry.
--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 1:49 am

#3683159
Reply To: Database mail not working.

You don't give us much to go on except to say it's broke.
With that in mind, check the profile(s) and make sure one of them is setup as a default.
--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 1:48 am

#3683158
Reply To: MERGING RECORDS

Itzik Ben-Gan wrote an incredible article on this subject. You can find it at the following URL:
https://blogs.solidq.com/en/sqlserver/packing-intervals/
Because you're not using SQL Server 2012 or above, we can't use his...
--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 1:38 am

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

Viewing 15 posts - 8,581 through 8,595 (of 59,072 total)