Talvez você curta
WSFC for SQL AG - one node in another subnet fails validation for network comm. but passes all FW validations. Ideas? #SQLHELP
In Profiler, I saw an SP suddenly take 30s to finish (normally 200ms range) but it also shows CPU, Reads and Writes as 0. Clue? #SQLHELP
In SQL AG: Datacenter D1 has 2 nodes + 1 FSW. Datacenter D2 has 1 node on diff subnet. Would this setup work? Or D2 needs 2 nodes? #SQLHELP
What is the best way to consume XML provided by REST service in #SSIS? Should entire XML file be downloaded first then parsed? #SQLHELP
Any reason the same SP would run a lot slower as an RPC called vs a SQL Batch (as it appears in Profiler)? #SQLHELP
Stuck trying to move out a Cluster Core Resource (Name/IP) from inside a Role. Accidentally Assigned it to a Role #SQLHELP
I accidentally moved the Cluster Name/IP from Cluster Core Resource to a particular role's. Can you move that back? #SQLHELP #Win2012R2
Win2008R2. Can I force start cluster on my 1 offsite DR node? All other nodes are in HQ (simulated as gone) incl FSW. #sqlhelp
When connecting to listener in an AG, should @@SERVERNAME show the listener name rather than the actual node SQL instance name? #SQLHELP
Anyone seen sp_executesql throw a FK conflict but if I run the query outside of sp_executesql with same params then it works? #SQLHELP
A 3rd party app is using dynamic SQL and open to SQL injection. Cannot change the app unfortunately, any suggestions? #SQLHELP
#SSIS 2012 deployed as project.Runs fine if executed from catalog.If as agent job, it says "no column info returned by SQL command" #sqlhelp
Need to encrypt string using AES256 with key & IV provided by another party.Can I do this straight in #sqlserver ? Without CLR? #SQLHELP
Changing SQL Service & Agent to use new AD account. Agent failed to initialze SQL Agent log and won't start. Any way to sync perms? #SQLHELP
10 PROD servers + 10 more for TEST. For service account, do you use AD Account for each indv server? Or per env? Common practice? #SQLHELP
Permissions on folder look same but somehow SQL cannot write to folder. Anyway to sort of resync permission on folder for SQL? #SQLHELP 2/2
Data drive had issues so I stopped SQL & moved folder somewhere then new drive added (same drive letter). SQL is not starting #SQLHELP 1/2
Anyone using Win2012R2 getting the SCSI VPD error when validating for WSFC? support2.microsoft.com/kb/2531907 Says I "don't have inquiry data" #SQLHELP
In #SSRS RB3, I'm trying to select a shared data source. Default will show the http://realservername/...Is there a way to use FQDN? #SQLHELP
Is there a way to rename an AG listener name? Same IP and all, but just wanted to rename. #SQLHELP
United States Tendências
- 1. Skattebo 29.5K posts
- 2. Eagles 79.9K posts
- 3. Andy Dalton 5,808 posts
- 4. Falcons 25.9K posts
- 5. Myles Garrett 2,794 posts
- 6. 49ers 23.6K posts
- 7. #NYGiants 4,278 posts
- 8. Bears 54.7K posts
- 9. Saquon 13.4K posts
- 10. Niners 2,899 posts
- 11. James Cook 3,112 posts
- 12. Vini 135K posts
- 13. Nick Mangold 26K posts
- 14. Tush Push 13.8K posts
- 15. Ravens 37.2K posts
- 16. Bills 117K posts
- 17. #FTTB 3,040 posts
- 18. #Browns 2,453 posts
- 19. Bijan 4,051 posts
- 20. Raheem 3,967 posts
Talvez você curta
Something went wrong.
Something went wrong.