I LOVE utility scripts like this that build off of metadata, it's a great way to learn how SQL Server stores information internally. Thanks!

dhart (3/25/2016)

---

When I run this and...

They need Jeff Goldblum from Independence Day. The dude connected a Mac laptop to an alien network, he can handle an iPhone hack.

I read this morning[/url] that a hospital...

"In the cloud" = "On someone else's server that we access across the internet at WAN, rather than LAN, speeds....

That's a pretty good stumper. Personally I would turn on compression, aside from saving space it will frequently also save time as it compresses the data after the read...

http://xkcd.org/1626/

http://xkcd.org/1619/

Interesting article, Tim. Definitely not an easy thing to code. I've never worked with Web Edition, so I know my approaches would be different. For what you...

I try to get my wife out the door 45 minutes before a movie start time. I can't seem to get it through my wife's head that it takes...

That's not really a lot of records. I'm in the data type mismatch of your join fields camp, but also, how much memory does your server have and what...

The word that struck me would have been Data Repository, but Data Source is probably better. I always trend towards polysyllaby. 😀

Personally, I'd suggest dropping some coin on Microsoft's...

Huh. SQL Server on bare metal. It'd need a file system, a network I/O system, memory management, task switching, user/security management, update management. Maybe a GUI to...

Automation is a good thing. As pointed out, it reduces error as long as the inputs remain consistent to the design.

Here's the thing: any code that we write we...

Just don't let Donald Trump hear you say that! 😛

I could see Powershell being...

The thing that I find odd about the free Packt is that I get their email newsletter around 8am USA MST, and the books are only available another eight hours...

I like doing things through system tables:

SET NOCOUNT ON;

SELECT

'SELECT [SpecificationColumns]' + CHAR(13) + CHAR(10) +

'FROM PRODUCTIONCopy.dbo.' + name + CHAR(13) + CHAR(10) +

'EXCEPT SELECT [SpecificColumns]' + CHAR(13) + CHAR(10) +

'FROM...