Viewing 15 posts - 1,771 through 1,785 (of 49,571 total)
Igor Micev - Wednesday, February 15, 2017 1:30 AMYou can rename an instance name, why not?
No, you can't. You can change...
February 15, 2017 at 2:47 am
February 14, 2017 at 4:05 pm
SQL 2016 SP1 added table compression (along with In-memory OLTP, columnstore indexes and a whole pile of other things) to Standard Edition, so that's an option. Row compression is often...
February 14, 2017 at 3:49 pm
Index definitions for the involved tables?
February 14, 2017 at 7:11 am
February 14, 2017 at 7:10 am
Can you post table definitions and index definitions of the involved tables, as well as the actual execution plan please?
February 14, 2017 at 5:53 am
Rechana Rajan - Tuesday, February 14, 2017 5:35 AMBut if the DB grew very large, wont the file\filegroup backup help?
Maybe, depends...
February 14, 2017 at 5:51 am
February 14, 2017 at 5:11 am
By "More Granular" i hope you meant about filegroup backup\restore.
Backing Up Specific Files or Filegroups
BACKUP DATABASE { database_name | @database_name_var }
<file_or_filegroup> [...
February 14, 2017 at 4:55 am
Extra files aren't a matter of size. Why do you want to split the data file?
February 14, 2017 at 4:44 am
Unless the table is empty, adding a column and creating a unique index at the same time will fail, as the newly added column is not unique.
February 14, 2017 at 2:31 am
February 14, 2017 at 2:29 am
The Microsoft licensing documentation is reasonably clear about how cores are licensed, I suggest you read it carefully.
February 14, 2017 at 2:27 am
February 14, 2017 at 2:25 am
Viewing 15 posts - 1,771 through 1,785 (of 49,571 total)