Surgery: Day After

Surgery went well.  I have been home trying to relax.  Pain is minimal for now and being maintained by 200-400mg Ibuprofen.  Haven't had to break into the Vicodin yet, so that's good! Eating and drinking is not going well.  I have manage to get down about 30oz. of gatorade since the day of surgery.  I did get about 8oz. of chicken noodle soup broth down and a few ounces of water as well. I am going to force myself to finish this gatorade and start a new one as well as get some food in my system. Pictures Continue reading →

Surgery

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

Wednesday morning I will undergo some much needed oral surgery.  I will be off work and away from most of the tech world until Monday.

I hope recovery is speedy.  I will try to update on my progress through the coming days.  The entire surgery should only take about an hour provided all goes well.

Show Jobs that Will Run in Microsoft SQL Server

I don't remember the link I found this little tidbit at, but it's useful. This will display the scheduled jobs on your Microsoft SQL Server instance that will be running in the future.
USE msdb
;WITH CTE AS (SELECT schedule_id, job_id, RIGHT('0'+CAST(next_run_time AS VARCHAR(6)),6) AS next_run_time, next_run_date
FROM sysjobschedules)
SELECT A.name Job_Name,
'Will be running today at '+
SUBSTRING(CONVERT(VARCHAR(10), CASE WHEN SUBSTRING (CONVERT(VARCHAR(10),next_run_time) , 1 ,2) > 12
THEN SUBSTRING Continue reading →

Index Fragmentation Report in Microsoft SQL Server

I came across something that I found useful today when troubleshooting some query performance reports.
I won't re-post the entire article, but here's what I found useful and I tweaked it to my needs by ordering by avg_fragmentation_in_percent as well as only displaying results with IPS.page_counts greater than 1000 and avg_fragmentation_in_percent greater than 75%.
--To Find out fragmentation level of a given database
--This query will give DETAILED information
--CAUTION : It may take very long time, Continue reading →

#performance

Display Data and Log File Paths for Microsoft SQL Server Instance

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

Find all the data and log file paths for all databases on Microsoft SQL Server instance.

SELECT name, physical_name AS current_file_location FROM sys.master_files