Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 59,067 total)

Reply To: Index Spool Eager Pool issue

If partitioning IS present, why is there a need for any of this? SWITCH the old data out. Copy it to a new table in the archive. Then SWITCH 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)

May 10, 2023 at 1:13 pm

#4187394
Reply To: Want to load data on a staging table.

Teewhy wrote:
I will want to have this solution in my arsenal. What is the code to install ACE Drivers? How do I set it up?
Please, show me easy and step...
--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)

May 10, 2023 at 12:56 pm

#4187383
Reply To: Want to load data on a staging table.

David Burrows wrote:
Jeff Moden wrote:
homebrew01 wrote:
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets...
--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)

May 9, 2023 at 7:11 pm

#4186848
Reply To: System versioned tables permissions

I think the answer is "because". 😉 I've not checked privs on system versioned temporal tables before but it may very well be that if the user has write 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)

May 9, 2023 at 7:02 pm

#4186842
Reply To: Log File continue growing

datkop wrote:
Thanks for the advice.
So i read this before and did a log backup.
Backup Type: Transaction Log
It doesnt work... Or do you mean anything else?
Edit: So i turned the 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)

May 9, 2023 at 6:55 pm

#4186836
Reply To: Log File continue growing
If you look for the accepted answer at the following link...
https://social.msdn.microsoft.com/Forums/en-US/1fb51bb5-a09f-4bd6-8880-4f0c15227db5/what-does-it-mean-when-dbcc-loginfo-returns-many-rows-with-status-2-and-dbcc-opentran-returns-no?forum=sqldatabaseengine
... it says...
```
Status = 2 means that VLF can't be reused (overwritten) at this time and it...
```
--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)
May 9, 2023 at 6:07 pm

#4186809
Reply To: Want to load data on a staging table.

homebrew01 wrote:
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets ((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)

May 9, 2023 at 5:57 pm

#4186806
Reply To: Dirty Reads with Read Committed?

AVB wrote:
Hi Jeff,
Thanks for the reply.
It only deletes some of the data. Also, the query that isn't returning data only pulls from that subset that gets deleted.
Those rows are locked...
--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)

May 9, 2023 at 5:55 pm

#4186805
Reply To: Employee count based on target date

samservice wrote:
I have table for employee activity with the following fields:
[Emp ID] , [Hire Date] , [Term Date] , [Mod Date] , [Old Div] , [New Div]
When an employee is...
--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)

May 9, 2023 at 5:52 pm

#4186804
Reply To: how to get previous year and current year data in coma separated values in sql

kbhanu15 wrote:
Hi Ratbak,
Thanks for your reply but order is the only my main problem.
--Expected o/p : Previours years following by current year data --Jan-2022,January-2022,Jan-2023,01-01-2023,Jan-2023,Jan-2023
Thanks
Bhanu
Since this seems new to you, read...
--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)

May 9, 2023 at 5:45 pm

#4186801
Reply To: How to check the value of database property TRUSTWORTHY?

wrote:
By enabling cross-database ownership chaining or by designating a database as trusted by the instance using the TRUSTWORTHY attribute, a trust relationship between databases can be created. The sys....
--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)

May 9, 2023 at 5:20 pm

#4186790
Reply To: Dirty Reads with Read Committed?

Are you saying that the DELETE in the hourly process deletes ALL of the data in the table or just some of the data?

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

May 9, 2023 at 5:09 pm

#4186789
Reply To: SQL Managed Instance Accelerated Database Recovery

I can "azure you" that I can't answer your question because I've never used Azure before. 😀
I just want to say "Thank you" for the link to what looks like...
--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)

May 9, 2023 at 5:02 pm

#4186785
Reply To: Want to load data on a staging table.

Teewhy wrote:
Probably a few more times. Is there anything I should be concerned about or something else I can do to improve the process?
I was going to suggest that if...
--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)

May 9, 2023 at 4:45 pm

#4186758
Reply To: Restore further T-Log Backups

The other method is "WITH NORECOVERY". But, people need to find and read the documentation to know of either option before they tackle the two most important things a DBA...
--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)

May 9, 2023 at 4:39 pm

#4186755

Viewing 15 posts - 1,471 through 1,485 (of 59,067 total)