Viewing 15 posts - 451 through 465 (of 4,477 total)
I wish MS would stop making such "improvements". They did the same thing with "Diagrams". There was an uproar about that and, very fortunately, the supposedly brought it...
July 8, 2019 at 9:47 pm
You can add the other disks by adding them first to the available storage. And then add them to the CSV on the cluster.
Sue
July 8, 2019 at 9:37 pm
It would take an Intent Exclusive (IX) lock but not an exclusive lock. An actual update/delete would take an Exclusive (X) lock. You can capture what happens with extended events...
July 3, 2019 at 6:18 pm
I'd probably not go down the route of looking at the costs and just look for Key lookups . But the following should help you get started on putting something...
July 3, 2019 at 6:14 pm
SQL Server is Microsoft's implementation of a Relational Database Management System - just like Oracle, Sybase, DB2, PostreSQL etc. A database is usually defined as a collection of data.
But that...
July 3, 2019 at 4:25 pm
Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out,...
July 2, 2019 at 10:09 pm
Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out, bcp out...
July 2, 2019 at 9:33 pm
If you changed to using multiserver administration, there is a fix for that error on 2012. Otherwise, you would want to check the job step properties and the package location...
July 1, 2019 at 6:02 pm
And for filestream, I've always read to leave filestream the same a data and log file drives. Here is one of the references:
Best Practices on FILESTREAM implementations
Sue
July 1, 2019 at 5:48 pm
The other browser was just opening the site in IE without logging into SSC. I don't think any of it has to do with private browsing. The only difference is...
June 27, 2019 at 7:07 pm
Interesting. I missed the newsletter today, have an msn account and nothing was in the junk email.
But yesterday was a bit more odd. I'd click on the time of the...
June 27, 2019 at 6:05 pm
As the article explains, how it's configured depends upon which of the three availability scenarios mentioned in the article were you configuring for - report data sources, report server databases,...
June 27, 2019 at 2:59 pm
What is the script you are using to check if the Windows account is terminated? That's the first question. And I have another. And I make that long on purpose...
June 26, 2019 at 9:17 pm
The error sounds like the Report Server is pointing to the read only replica of the reporting services databases. The Reporting services database can't be read only, writes do happen...
June 26, 2019 at 8:40 pm
No one can tell you ideal size for database files just by asking what they should be. You would want to do some capacity planning to determine things like that....
June 26, 2019 at 4:41 pm
Viewing 15 posts - 451 through 465 (of 4,477 total)