SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.

T-SQL SELECT..INTO

SELECT INTO FILESTREAM

INSERT

INTO Identities

Using Sparse Columns with SELECT ... INTO

Version control for SQL data

During the exploitation of a large database the user wants to control data so it can be maintained for different versions. I cannot find any version control software that will control data. All software packages will control versions up to the level of coding. Who can help me find the correct software?

Datetime conversion in T-SQL

I need to compare two dates in the stored procedure: one is datetime that gets value from the system by getDate() function and another is from the database.Both values have format "MMM DD YYYY HH:MM", but the system datetime gives current HH:MM, when the database values have 00:00. I don't care about time, I just […]

RE: Moving the MSSQL folder

Put your 2 cents worth in http://www.mssqlsurvey.com/TakeSurvey.asp?SurveyID=105

RE: Question of the Day for 05 Feb 2004

I agree that this question was poorly written, but I will hold off on screaming for my points until I hear a response from the question's author.  I also have to agree with another poster that this at least it got me to write my first post, so it may have a positive effect...whether the […]