I started out with SQL Server 6.0 many moons ago, as well as Ingress II, Informix 8, and shortly thereafter Oracle 7.3, all of it except for SQL Server running...

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...

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...

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...

I have been using tis one for a while, and only date and January will be returned. the numbers will be tokenized and discarded.

RonKyle (3/24/2016)

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...

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...

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...

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...

#4 will result in an error since the orderstatus column does not exist...not sure how that is part of the correct answer.

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...

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...

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...

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...

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...