Maybe it was a trick question where the expected answer was "you can't do that" or "that's a completely meaningless thing to do". Remember, the purpose of interview questions...

Thanks, David. I really appreciate you taking the time to provide feedback.

I went overtime because I got comfortable and slowed down.  I needed to keep the pace up on that...

See... that's a problem...

Asking for and getting a consistent format for incoming data from multiple clients is often wishful thinking. Sure, if you've done previous conversions from a system(s) that is the...

Unfortunately, that actually proves that they don't know.  Bob Ward is still talking about the use of reorganize for index maintenance. ...

Thanks Jeff

That and control characters 28 thru 31.

I'm writing them how I would decode them in JavaScript -

Row split:

data.split("\u001e")

column split:

data.split("\u001f")

It is possible to define a whole set of JavaScript...

Something else folks may not consider and that's the "native" format for transmitting data from SQL Server to SQL Server.  It does really cool stuff such as leaving INTs in...

With the proliferation of file formats, perhaps it is time to revisit the delimited file and how its problems can be overcome.

CSV stands for comma separated values. As we...

On the subject of LOB compaction and deletes and page splits...

It may take 10 runs for REORGANIZE to actually get it to work right (yep... tried it and measured it).

On...

Don't forget: Microsoft is a Cloud Service provider. Quite a big one. With no plans of retreating.

Increased load on in-house servers makes the argument for a company to move...

😀

Thanks for the response, Jeffrey.  If you go to the first article I provided a link for and then search for "A/B", that 3 character link will take you to...

If it's done right on both the part of the sender and the receiver, it's actually not a "lengthy process".  It can be nasty fast and super easy to setup...

You never said... what's the closest city you're moving to?

I also wish you luck with the move and, just like getting a DBA involved, I'll also say that the 6%...

Hi,

Table schema

RouteID bigint,

DLRStatus tinyint,

DLRID nchar(50)

ReceivedDate datetime

This table contains millions of records and we need to fetch the record by DLRID which is received from several sources from outside the...