Another way of doing it is to create a small special purpose, single table database that you write the "export' data to as a real table.  Then do a compressed...

p.s. And, the files will be smaller because INTs will actually only take 4 bytes and dates will only take a maximum of 8 and could be as little as...

With that thought in mind, I have to ask, why are you messing around with the likes of "CSV" files and PowerShell, etc?  It's a simple thing to BCP a...

You might be just under the 2k limit. For the most part, this shouldn't be anything you notice, although if someone posted to the 2002nd oldest thread, you just...

It does, indeed and the import, as well.  And, just to be sure, this is a pure...

Awesome.  I'm impressed.

I'm not sure what that means.  I just want to know the total number of rows that the entire...

See the article at the first link in my signature line below.  If you were to provide a little readily consumable data as laid out in that article (which is...

Ok... despite the fact that I love my Alien-ware that I previously described, I'm finding that ALL laptop keyboards suck.  I have had one yet where frequently used keys don't...

p.s.  As another side bar and just in case it becomes a requirement, remember that anything that the DBAs or others with sufficient privs can affect will NOT stand up...

Thank you Jeff and Grant for your input!

Yes my conceptual model doc will layout keys, uniqueness, relationships, and attribute rules and constraints.  Eventually.

I think one question I had is.......

On the subject of BULK INSERT...

As with anything else, "It Depends" but, no, you don't actually have to disable all sorts of constraints to bulk load data into a table...

I think that the cloud has some fantastic capabilities and opportunities.  Despite some of my posts, my big concern isn't so much about the cloud, it's about the "shiny new...

• This reply was modified 4 years, 1 months ago by Steve Jones - SSC Editor.

Thank you. It looks like the Modern_Spanish_CI_AS stored spanish mainly. What we want is still a database mostly stored English, but just for sometimes if users like to display...

No the database does not exist.  I have a conceptual design doc where i have defined several entities based on the UI designs i have seen.  I will be...