Tag Info

New answers tagged

1

Check out DML - Data Manipulation Language. This includes CRUD operations (Create (i.e. INSERT - not to be confused with the CREATE TABLE statement below), Read (i.e. SELECT), Update, Delete) on Tables. It's what people associate most classically with SQL. Compare this with DDL - Data Definition Language. DDL involves the CREATE TABLE and ALTER TABLE ...


0

First of all, use one alter statement to do all of adding two columns and the compound index. ALTER TABLE table1 ADD col1 INT, ADD col2 CHAR(2), ADD INDEX (col1, col5);. More about ALTER Archiving old records is a good idea. If it is very rarely needed, then some slowness is affordable (I think). Depending on your engine that you use, dumping the data and ...


0

The simple answer is don't use Entity Framework for this sort of thing. You need to write a SQL migration script, test it, and then deploy it onto your production system. And yes - changing a table with 3M rows will take more time and resources than migrating a table with 3 rows. There are a few techniques for achieving this. First, judging by the error ...


1

I found interesting this link: http://thomaslarock.com/2011/12/7-mistakes-you-cant-afford-to-make-when-upgrading-to-sql-2012/ In my case I upgraded from sql 2000 to 2014 (with a 2008 bridge) detaching and moving files, but considerations are still good. My db whas about 1.3 terabytes. I run DBCC CHECKDB WITH DATA_PURITY; But this is critical just ...



Top 50 recent answers are included