Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 59,067 total)

Reply To: QQ regarding DB_ID()

I haven't tried it but, perhaps, Detaching/Attaching. I think that Offline/Online would still keep the same value.
--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)

January 27, 2022 at 1:12 am

#3977721
Reply To: Defining DevOps

Heh... speaking of "better" for DevOps, I tried to rate the post and I'm logged in and yet it still says that I have to login to rate it and...
--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)

January 26, 2022 at 11:02 pm

#3977693
Reply To: Are the posted questions getting worse?

Ok... no response from the WebMaster on this issue. @steve-2 Jones... any help here?
Heh... probably not because you're probably not being notified of this post, either. 🙁
--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)

January 26, 2022 at 10:51 pm

#3977692
Reply To: MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

Michael L John wrote:
Good stuff!
I use the dbatools to do the same things. https://dbatools.io/commands/
There are a few different commands that copy logins and permissions between servers.
I've not delved into DBATools.io much. Which...
--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)

January 26, 2022 at 10:44 pm

#3977690
Reply To: Report Format - Not rounding to 2 Decimal Places

I'm a bit confused. Can you post the actual value of what FileSize is BEFORE your modifications, please? Also, what are you using as a reporting tool?

--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)

January 26, 2022 at 10:42 pm

#3977688
Reply To: SSIS - Data Conversion Transformation/Derived column - Varchar to Integer, Null

I'm bumping this for you, Karen. Seems like it should be simple to do in SSIS but I don't use SSIS and can't help.

--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)

January 26, 2022 at 10:36 pm

#3977687
Reply To: Reusing Tools for New Purposes

If you're using SomeDateCol BETWEEN FirstOfMonth and EOMonth, then you have closed/closed and it's not bullet proof because SomeDateCol could have a time in it.
Using the basic criteria of SomeDateCol...
--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)

January 26, 2022 at 10:34 pm

#3977686
Reply To: Auditing Missing Records

Lou wrote:
The problem will be querying those files for users in charge of this.
BULK INSERT may be your friend here.
--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)

January 26, 2022 at 10:30 pm

#3977673
Reply To: How to reclaim space from a table

WhiteLotus wrote:
Thanks for the reply all . Much appreciated ..
tonight i will try alter table rebuild and see how it goes
So... how'd it go?
--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)

January 26, 2022 at 10:29 pm

#3977672
Reply To: Restore autmomation
1. Do you have any PII or other sensitive information on the original databases that you've backed up?
2. What are you using to do the original backups?
3. Does the server...
--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)
January 26, 2022 at 10:24 pm

#3977671
Reply To: How to calculate delta in timestamp

Awesome! Yeah, that previous state an time made life a whole lot easier! Nicely done on the research.
--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)

January 26, 2022 at 10:20 pm

#3977670
Reply To: Restore is not progressing at all . Please kindly help

So, enquiring minds want to know... Is it done yet? 😀
--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)

January 26, 2022 at 9:59 pm

#3977665
Reply To: non-prod database data scrambling

sqlfriend wrote:
Thank you both.
The product is good, but it is expensive. Not sure if we can get approval to have budget for that.
Any other recommendations?
Thanks
It'll be cheaper that writing your...
--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)

January 26, 2022 at 9:57 pm

#3977664
Reply To: 20 Temp table tracking

You're going to have to write some code that checks sys.tables for names using wild cards and check their "create_date" for the date and time they were created. If 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)

January 26, 2022 at 9:54 pm

#3977663
Reply To: PLE & Tempdb spills

If, however, it's ALWAYS in the proverbial toilet, THAT can be an indication of a much larger problem.
It may not actually show up as "spills", either.
--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)

January 26, 2022 at 9:41 pm

#3977662

Viewing 15 posts - 4,006 through 4,020 (of 59,067 total)