Viewing 15 posts - 5,986 through 6,000 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2015 at 2:08 pm
Ken Davis (5/9/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2015 at 2:01 pm
Eirikur Eiriksson (5/10/2015)
Ken Davis (5/9/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2015 at 1:54 pm
True and likely not to be as obvious, but it still needs doing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2015 at 11:02 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2015 at 9:06 am
Viewing 15 posts - 5,986 through 6,000 (of 49,552 total)