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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Generate Scripts is failing
Break it into smaller pieces. Do the tables, procs, functions, etc.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:BTW: Jeff is of course our SSIS expert 😉
Define "Expert"
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Reclaim disk space after truncate
If there is a large amount of free space, I would shrink it incrementally in smaller chunks.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: db permission problem
Try this link
https://lmgtfy.app/?q=login+failed+.+error+4064
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: db permission problem
No. Neither one of you are even close.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
J Livingston SQL wrote:Grant Fritchey wrote:J Livingston SQL wrote:So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 15 posts - 706 through 720 (of 2,356 total)