DBA for @IntlPaperCo, and @AlabamaFTBL fan #rolltide! about.me/ken_wilson
Joined March 2012
- Tweets 1,552
- Following 129
- Followers 161
- Likes 33
46 Photos and videos
17 Oct 2022
Has anyone seen an issue with FILESTREAM access level runtime value reverting back to 0 after a reboot? This seems to be happening randomly in both 2014 and 2016. #sqlhelp
10 Feb 2022
I have a Availability Group with 2016 FCI and and a 2016 async secondary replica. According to Microsoft docs the log stream compressed by default for async replicas but I’m not seeing any compression. Trace 1462 is not on. Thoughts? #sqlhelp
1
14 Jul 2021
Has anyone experienced an issue with a linked server only allowing 99 rows to return when using Oracle 19c client? If more than 99 rows are returned we get “unexpected catastrophic failure” message and a stack dump. The dump shows a memory access violation. #sqlhelp
1
24 Jun 2021
If TDE certs still work and can be used to restore the database if expired, why rotate them to keep them up-to-date? #sqlhelp
1
18 Aug 2020
Transaction log is 1.75 TB in simple recovery and you want me to add another log file? Hahahaha No!
21 Jul 2020
I have some SQL Server 2014 Express instances running on Windows 10 machines. Has anyone seen the 1909 upgrade cause the sa password to be cleared or reset? Just curious if it’s happened to anyone else. #slqhelp
9 May 2020
Getting insufficient disk space error for a drive letter but I am restoring to mount points on that drive that have plenty of space. Trace flag 3104 is not helping bypass the space checks either. 1/2 #sqlhelp
1
2
9 May 2020
The setup is SQL Server 2012 SP4. Database is 20 GB. Disk configuration is root drive (1GB) then mount points SQLData 100GB and SQLLogs 100GB underneath. Same setup on our development server worked with no issues. Thoughts? 2/2 #sqlhelp
1
2
9 May 2020
Issue discovered...database default log path was incorrect and was attempting to restore to a folder at the root drive. Bad configuration was to blame. #sqlhelp
1
25 Mar 2020
Trying to delete data out of sys.syscolpars to fix metadata corruption as @PaulRandal blogged about but I’m getting ‘Ad hoc updates to system catalogs are not allowed’. #sqlhelp
7 Jun 2019
I backup the tail of the log on a database and the database is now in restoring mode. If I then attempt to restore and get an error that the mdf is in use. Is that something in the OS that is locking the mdf or could there be something in SQL Server? #sqlhelp
1
11 Oct 2018
Setting up AlwaysOn listener for an vendor application that uses four part naming in the queries. Several tables have xml columns so a linked server looping back on itself doesn’t seem to be an option. Any other options? #sqlhelp
1
6 Apr 2018
A user has created a database using db_creator. They are DBO but can’t access the database. Their application then created a user with the same login as DBO. Any thoughts on how this is possible? #sqlhelp
1
4 Jan 2018
The Windows SID is also incomplete as it is missing the last four digits. Any thoughts on how to track down what user this SID is tied to? 2/2 #sqlhelp
4 Jan 2018
Hello All, using sp_whoisactive I'm seeing connections that are displaying what looks to be a Windows SID instead of a friendly name. However, the database the login is connecting to has only SQL Server logins mapped to users. 1/2 #sqlhelp
1
23 Aug 2016
Everything looks up through cluster mgr and management studio. Servers are 2012 sp3 and this is not a multi-subnet env. 2/2 #sqlhelp
2
23 Aug 2016
After failover, it is taking longer for machines on a different subnet to connect to the AG listener. 1/2 #sqlhelp