Viewing 6 posts - 1 through 6 (of 6 total)
@dinors: the problematic process leans heavily on cursors - is actually a procedure that calls a dozen other procedures that each have their own cursor. If this causes...
October 2, 2019 at 5:53 pm
I was wrong: the windows log actually reads "starting up database," not the service. So the series of events was as follows:
1) database set offline
2) log...
May 2, 2018 at 9:41 am
I just confirmed with the windows logs that the sql server service was successfully restarted. Apparently [sys.dm_os_sys_info].[sqlserver_start_time] actually represents the OS start time, or it's simply inconsistent. Also confirmed that SQL...
May 1, 2018 at 12:03 pm
I finally cracked the haunted spreadsheets by installing office on the dbserver, installing the most recent office interop libraries from ms download, adding a folder named "desktop" to C:\Windows\System32\config\systemprofile &...
February 24, 2016 at 11:03 am
Lowell (2/22/2016)
...where a csv file was renamed to have an xls extension...so the file was not truely xls, so it could not be opened.
Ed Wagner (2/22/2016)
February 22, 2016 at 6:56 pm
This article was a great help.
My relational mindset is stubbornly resisting the hierarchical nature of xml and I was having a rough time with even the simplest operations....
July 16, 2012 at 1:23 pm
Viewing 6 posts - 1 through 6 (of 6 total)