Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,596 through 8,610 (of 59,091 total)

Reply To: Catching a "kill job" event from within a SSIS package executed by that job.

Thanks, Sam. If you have the time, it would be interesting to know how you resolved the problem.
--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 9:07 pm

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

Thanks for the feedback, Sam. I'd love to hear what you end up 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)

September 25, 2019 at 8:59 pm

#3683444
Reply To: Database mail not working.

trgrassijr wrote:
Thank you
I figured it out
It was the Server name was incorrect. The MSTDC setup on the Cluster was wrong after correcting that email starting working.
Thanks again for all 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 25, 2019 at 8:56 pm

#3683441
Reply To: ASCII sql server

larimin55 wrote:
I want to block exponential numbers in sql, how can i do this?

I don't know because I don't know what you mean by "exponential numbers" nor what such 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 25, 2019 at 2:22 am

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

Viewing 15 posts - 8,596 through 8,610 (of 59,091 total)