Viewing 15 posts - 1 through 15 (of 128 total)
I was able to work my way through building out multiple BIML files to create an entire solution for loading my data warehouse, including using the INFORMATION_SCHEMA views to dynamically...
April 12, 2019 at 8:52 am
I would think the best way to see what is going on is to do some tracing, the query in SQL Server, the network traffic using Wireshark or similar, and...
June 3, 2016 at 11:26 am
Did you use the code that was listed at the link I posted to determine the request size? Solving this when it's just over the 64MB hard limit will likely...
June 3, 2016 at 8:09 am
I have been using tis one for a while, and only date and January will be returned. the numbers will be tokenized and discarded.
May 9, 2016 at 11:07 am
It would be wonderful to be able to work a normal 9 to 5 schedule, but most issues occur when everyone else from the office is sleeping, so I...
March 24, 2016 at 10:28 am
It would be wonderful to be able to work a normal 9 to 5 schedule, but most issues occur when everyone else from the office is sleeping, so I get...
March 24, 2016 at 9:46 am
It was not until very recently that society became so temporally focused, and it has been only for the past few decades in the "information age", that we as a...
March 22, 2016 at 12:58 pm
I frequently use SQL Server for queuing operations, and if I'm not mistaken, it is the backend persisted storage for MSMQ. I have found that by using triggers to...
February 3, 2016 at 10:12 am
#4 will result in an error since the orderstatus column does not exist...not sure how that is part of the correct answer.
December 30, 2015 at 11:26 am
Ran into this error when processing a cube on a legacy server. Digging a little deeper showed an error in the TDS stream, so I disabled the TCP chimney...
January 13, 2014 at 11:49 am
I guess I've been spending too much time looking at query plans lately. I saw merge join and went right for it and didn't even bother to look at...
November 4, 2013 at 12:04 pm
Disk is about to become more expensive. We are on the edge of a transition to flash storage which will make traditional disk go the way of the floppy...
October 28, 2013 at 8:49 am
My company is a large global enterprise and we're using things like flash storage arrays and putting everything in a VM, but with the main asset of the business being...
October 16, 2013 at 11:33 am
You mentioned that you truncated the trans log, but that's no longer possible with SQL 2008 R2. Are you certain the log was truncated? Regardless, the right way...
October 4, 2013 at 8:06 am
I disable it for Internet facing databases and grant specific permissions. It's also interesting that the article has not been reviewed in two years and SQL 2012 is not...
October 1, 2013 at 3:32 pm