Viewing 15 posts - 31 through 45 (of 19,563 total)
That is a definite must-have feature enhancement. Longer days would be great on so many levels.
August 23, 2017 at 12:49 am
Surely that storage format has got to be very high density.
August 23, 2017 at 12:48 am
August 22, 2017 at 11:53 pm
August 22, 2017 at 11:42 pm
I am going to blame Jeff for reviving this old thread.
I sit here and wonder how it is that you don't have permission to create a temp table...
August 22, 2017 at 10:45 pm
I would recommend a procedural language and not tsql for a problem such as this. Using tsql to do this would be like trying to use a sledgehammer to screw...
August 22, 2017 at 10:38 pm
Are you sure the index is not created?
How are you determining the index is not created? It sounds like you went and created another index on the same...
August 22, 2017 at 6:29 pm
I prefer to copy the backup to the "test" or "dev" server to perform the restore. These days that is really more about preference than anything else.
August 22, 2017 at 6:23 pm
Unfortunately this sort of thing happens all too frequently with the maintenance plans. Deleting the plan and recreating it usually fixes this kind of error.
A better option would...
August 22, 2017 at 11:46 am
August 22, 2017 at 11:33 am
The enterprise features in use are not stored. You would need to basically audit the environment to determine if any of these features are in use:
Data...
August 22, 2017 at 11:22 am
This is a really fun find. I had never considered switching a non-partitioned table. There are some interesting uses for switch with non-partitioned tables.
August 22, 2017 at 11:09 am
Viewing 15 posts - 31 through 45 (of 19,563 total)