Viewing 15 posts - 256 through 270 (of 961 total)
If you follow the principal of least privileges the user shouldnt be able to create objects under the master database anyway.
January 19, 2013 at 6:47 am
January 19, 2013 at 6:10 am
Have you checked the port number .The rport manager URl can be found in the reportig services configuation manager . If you look there will be a port number assigned...
January 19, 2013 at 6:04 am
I am pretty sure you dont get an option to backup the log file in file and file group backup.
Could you confirm the exact steps you performed.
What your trying to...
January 19, 2013 at 5:54 am
Use replication and have the reports connect to the subscriber for a read only copy of the data.
January 19, 2013 at 5:50 am
Could you try this and let me know what happens
Create a SQL account and grant it permsisions on the database.
Modify the connection string in the datasoruce for the report...
January 19, 2013 at 5:04 am
Am not sure if I am understanding the question right, there is autoincrement set to 1 MB for the database files. The files are located on indvigual disk drives. Wouldnt...
January 18, 2013 at 6:12 am
if the issue is only for the single product make sure the data is present in the underlying database and the cubes have been processed.
January 17, 2013 at 2:51 am
There are a lot of best practices that need to be followed before you get into SQL port configuration. I usually reserve this for databases that have customer sensitive...
January 15, 2013 at 6:57 am
This has already been answered here
January 15, 2013 at 6:52 am
create two dim one for start and one for end using the dimtime table map this table to dim x , then map these to the fact table.
January 15, 2013 at 6:33 am
you need help , id start with the indexes since thats a quick win , maxdop for highly transactional db is bad for dw is good, vlf count is too...
January 15, 2013 at 6:29 am
add a new column int identity and add the key on it , or create a checksum value for each roe
January 15, 2013 at 6:20 am
To start off make sure the indexes and stats are up to date.
There seems to be parrallelism , do u have proper indexes defined?
There also seems to be Page IO...
January 15, 2013 at 5:42 am
yes , please look at the below link for details.
January 15, 2013 at 5:31 am
Viewing 15 posts - 256 through 270 (of 961 total)