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 趨勢
- 1. Jamaica 163K posts
- 2. JUNGKOOK 942K posts
- 3. #NationalFirstRespondersDay N/A
- 4. Wikipedia 84.2K posts
- 5. #10SET 1,176 posts
- 6. Grokipedia 132K posts
- 7. Good Tuesday 36.4K posts
- 8. $MSFT 50.1K posts
- 9. Atlantic 32.6K posts
- 10. Hurricane Melissa 128K posts
- 11. Nelson 24.4K posts
- 12. #tuesdayvibe 2,523 posts
- 13. Eastern Pacific 4,889 posts
- 14. $PYPL 36.5K posts
- 15. Taco Tuesday 12.2K posts
- 16. #NationalChocolateDay N/A
- 17. Riley Gaines 83.4K posts
- 18. Freddie 115K posts
- 19. Jackie Robinson N/A
- 20. Christian Zionism 4,993 posts
Something went wrong.
Something went wrong.