Viewing 8 posts - 16 through 23 (of 23 total)
sp_spaceused returns 2 resultsets
Type the following to see the schema "EXEC sp_helptext sp_spaceused".
There might be a some DMVs out there that give you the information that you require.
November 17, 2014 at 10:12 am
Have you considered going for multiple RAID 5 partitions and essentially "striping" your database across them?
For example you could have 4x RAID5 partitions (6 disks each). That way you only...
November 17, 2014 at 9:38 am
Ah...then this means that the upgrade is attempting to modify your replicated tables by either changing the Primary Key or trying to drop and\or recreate them. In which case unfortunately...
November 17, 2014 at 9:11 am
Hi, your question is not very clear here? If you are upgrading the application that hits the Subscriber database and you don't want data to replicate during that time (for...
November 17, 2014 at 8:22 am
As asked in a previous post did you check for Single Use Plans causing Plan Cache Bloat? I have found that setting "Optimise for Ad-Hoc WorkLoads" makes a big difference...
November 17, 2014 at 5:43 am
As stated here you need to first devise your query in form of a JOIN. Something like below. Note that this is just an example to give you a start....
November 17, 2014 at 5:29 am
Hi,
What some of the other guys here have mentioned are very valid as it could be so many issues. Here's a few extra things to check.
Is your server a VM?...
November 17, 2014 at 4:41 am
Viewing 8 posts - 16 through 23 (of 23 total)