Viewing 15 posts - 1 through 15 (of 67 total)
Thanks for doing this Steve - I/we can be solitary in our work so an encouraging voice is a blessing, and maybe just enough to keep us going. We can...
April 3, 2020 at 11:52 am
Drop DST has my vote. Sounds like the consensus - internal GMT, display adjusted local time, forget DST with apologies to Mr Franklin. Some states are going to vote...
January 22, 2019 at 3:38 pm
Hearken back to much exaggerated and feared Y2K project...
I was responsible for assessing risk and proposing mitigation for a large hospital chain. Mostly with common sense...
January 22, 2019 at 12:40 pm
That phrase was originally designed for typists because in the original form it uses every letter of the alphabet - so what is missing? The letter 's' - the original...
May 7, 2018 at 5:12 am
Hi Steve,I'm planning a new web application and am considering Azure as the platform. Having read this older article of yours, I'm hoping you have either more info on...
May 23, 2017 at 6:44 am
Good solution Mak - clean, easy to inline so no udf performance hit - interesting if there are any counter points/other ideas
July 22, 2015 at 11:43 am
Not sure how this is supposed to work
I tried highlighting a table name in Object Explorer and pressing [Ctrl] 9 but get nothing
Tried dragging table name onto new query page,...
July 13, 2015 at 9:08 am
I wish it were that easy but the first problem is that the data is in a very large varbinary field(64-100Mb) that contains 50-150,000 lines (delimited Char(10)) as hex:
June 11, 2015 at 11:19 am
On my system the first insert worked,. the second fail for constraint violation and neither index was disabled... what gives Steve?
June 10, 2015 at 9:21 am
Thanks Jeff and Lowell,
Just to clarify the data, it looks like this in the table:
From this I need to break it into manageable (VARCHAR) pieces, like this...
June 10, 2015 at 8:29 am
The primary key is a GUID called ID - not my idea, but this is an inherited database...
What I need is a count of each of the 3 or...
June 10, 2015 at 6:07 am
The converted string (from varbinary) looks like these 3 records (targets around position 40 but may be up to position 73, ergo my thought on REGEX...):
June 9, 2015 at 2:54 pm
I agree that would be easiest however that still leaves the existing records, is there a smarter way of dealing with them?
Maybe I should build the search in binary...
June 9, 2015 at 1:26 pm
Depending on how you are setup, i.e.; number of databases and files - the SQL Activity monitor gives decent but coarse IO numbers.
At the database level, the standard report...
June 2, 2015 at 9:02 am
Most of (99+%) there is a discrete list of columns. Unfortunately I will end up parsing the binary data in the LOBs for another project.
Thank you for your help here,...
May 20, 2015 at 4:59 pm