Forum Replies Created
Viewing 15 posts - 706 through 720 (of 2,356 total)
-
Reply To: Good query plan gone bad - can I pinpoint a cause with no repro?
This is not an uncommon issue with a search procedure. The fact that you are getting good performance most of the time is great.
As a first step, I would attempt...
-
Reply To: Generate Scripts is failing
Break it into smaller pieces. Do the tables, procs, functions, etc.
-
Reply To: large table cleanup using Delete
Depending upon how much data you are saving, it may be faster/easier to select what you want to keep into a new table. Drop the PK, FK and indexes on...
-
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:BTW: Jeff is of course our SSIS expert 😉
Define "Expert"
-
Reply To: Using Secondary Replica to perform a Copy-Only Backup
How are the backups set up in the AG confiratiopn?
This setting overrides that
OverrideBackupPreference
Override the backup preference for availability groups. This option only applies to copy-only full backups and regular transaction...
-
Reply To: Last Run Date on a Stored Procedure with parameter values
This is a great resource on Extended Events
https://www.sqlservercentral.com/stairways/stairway-to-sql-server-extended-events
-
Reply To: SQL Server 2019 Distributed Availability Groups
DK wrote:Hello, I am attempting to create a SQL Server Distributed Availability Group in my Azure EC3 environment. When I attempt to alter my Distributed AG on AG2 using the...
-
Reply To: Reclaim disk space after truncate
If there is a large amount of free space, I would shrink it incrementally in smaller chunks.
-
Reply To: db permission problem
The Stairway series on this site is also a very good learning resource
https://www.sqlservercentral.com/stairways/stairway-to-sql-server-security
-
Reply To: db permission problem
Ok,
spectra wrote:No. Neither one of you are even close.
Yes. I can go there as per the screenshot.
I don't see anything significant there. Its just couple of...
-
Reply To: db permission problem
No. Neither one of you are even close.
-
Reply To: db permission problem
homebrew01 wrote:Setting a default database is not permissions. It just tells SQL which database to set the initial connection for that user.
Correct. But if you won’t or can’t change the...
-
Reply To: db permission problem
spectra wrote:One is to change the options of how the user connects,
User will use Windows Authentication login in SSMS. No change here.
What are the DEFAULT options when...
Viewing 15 posts - 706 through 720 (of 2,356 total)