Viewing 15 posts - 5,986 through 6,000 (of 49,571 total)
Kinda need to see the batch file to say anything useful.
Bear in mind that if you use remote desktop, the batch file is executing on the server, whereas if you...
May 11, 2015 at 2:53 am
Keep in mind that you're not going to be moving the entire database to in-memory. That's not the goal. Move what makes sense, natively compile what needs to be that...
May 11, 2015 at 2:37 am
Probably because of security, the files would have been owned by the SQL Server Service account. Have someone who is local admin go in, take ownership of the files and...
May 11, 2015 at 2:31 am
Jeff Moden (5/10/2015)
Perhaps to rebuild a CI that needs it without rebuilding NCIs that don't?
ALTER INDEX ... REBUILD on the cluster would do that.
Heh... WHUT??? A rebuild error would...
May 10, 2015 at 4:24 pm
Cool, I thought it always rebuilt the NCs in a drop_existing on the cluster. Glad there's some extra common sense in there.
That said, I'm not sure why one would CREATE...
May 10, 2015 at 2:55 pm
Jeff Moden (5/10/2015)
The only recommendation for space savings is to DISABLE NCIs prior to a rebuild.
Which itself is wrong, because ALTER INDEX .. REBUILD on the clustered index doesn't...
May 10, 2015 at 2:08 pm
Ken Davis (5/9/2015)
May 10, 2015 at 2:05 pm
Jeff Moden (5/10/2015)
but it would appear the space savings are not true when a Clustered Index is involved.
Nor for a nonclustered index.
CREATE ... WITH DROP_EXISTING drops the old index...
May 10, 2015 at 2:01 pm
Eirikur Eiriksson (5/10/2015)
Ken Davis (5/9/2015)
May 10, 2015 at 1:54 pm
True and likely not to be as obvious, but it still needs doing.
May 8, 2015 at 4:00 pm
Lynn Pettis (5/8/2015)
I must be getting cynical. Too many people are losing the ability to think for themselves and solve problems needing everything handed to them on silver platters.
Not...
May 8, 2015 at 3:57 pm
And now you need to go and do some root-cause analysis. Corruption is, in the vast majority of cases, an IO subsystem problem. Make sure drivers and firmware are up...
May 8, 2015 at 11:11 am
\o/
Excellent. All too often corruption problems posted here are unfixable because of a lack of backups or corruption that's been ignored too long or similar.
May 8, 2015 at 11:02 am
Please post new questions in a new thread. Thank you.
May 8, 2015 at 10:48 am
In that case...
https://www.sqlskills.com/sql-server-training/ Nothing better.
No, there isn't a course on replication, but to be honest replication is not that difficult.
Alternately, negotiate with the boss for a Pluralsight[/url] subscription and ask...
May 8, 2015 at 9:06 am
Viewing 15 posts - 5,986 through 6,000 (of 49,571 total)