Technology
So what happens when you run a query to check TempDB file sizes and SQL tells you that each file is 101 MB, but when you look in the file system, they’re actually a 45 GB each? Also, when you try to shrink the file, the shrink file dialog window...
- 2017-01-20
Just a quick note on a scenario I ran into, and what I did to fix it: Scenario A user was running a stored procedure that created a table. Rather than having a table created in the "dbo" schema, it was creating a table with their user name as the...
- 2016-12-28
EDIT 2017-07-30: I believe that Youmail has changed their Android interface. The “History” section has been removed, which is a major bummer. It still shows on the Android Market screenshots but it does not really exist. How do block robo calls now? Not sure yet. Ugh, the bane of my...
- 2016-12-22
Perhaps a bit off topic for this site, but maybe it will help someone who was stuck like I was. My laptop is an Asus Q301L (Sonic Master). Occasionally, when disconnecting the wireless keyboard, my "fn" key is stuck on, so the zero key becomes a forward slash, and other...
- 2016-12-20
When a High Availability (HA) environment failed over, on the node that became Secondary, the backup jobs did not gracefully handle the change. The Maintenance Plans are supposed to intelligently determine whether each database is Primary or Secondary in an HA environment, and skip the backup if it is not...
- 2016-12-02
Here is a situation I just came across (boiled down and simplified). An end user was having to manually find a user id, navigate to an image folder, and then search through hundreds of images to find the one corresponding with that user. Sure, they were in numerical order, but still,...
- 2016-08-04
This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in action ebook. The output shows the spid (process identifier), the ecid (this is similar to a thread within the same spid and is useful for identifying queries running in parallel), the database name, the user...
- 2016-08-04
PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528
- 2016-08-04