Viewing 15 posts - 1 through 15 (of 134 total)
if you really want to use a sql agent job to do this you could have two identical jobs that run every 10 seconds. Job one you run statement as...
June 6, 2010 at 11:21 pm
there are some good online courses and many free webinars at http://www.pragmaticworks.com/services/training/Default.aspx
June 6, 2010 at 11:13 pm
There is not any other way but to give sysadm
June 6, 2010 at 11:01 pm
have you tried to remove all the sql tools and reinstall?
Sounds though like a 32bit 64 bit issue with WMI. I am assuming you have restarted the server --> if...
April 11, 2010 at 1:13 am
have a job created that populates a user table so the user can access the data.
April 11, 2010 at 1:05 am
SQL server can handle this but typically you will have far better performance if you store the images to a file system instead of in the database. Oracle also can...
April 11, 2010 at 1:00 am
The amount of page splits would depend on the fill factor and the type of data being written.
April 11, 2010 at 12:47 am
also typically active\active clusters do not provide any real benefit unless you have a lot of resources avaliable for it. It would be a better idea to go Active\active\Passive in...
April 8, 2010 at 8:09 pm
fill factor 80 seems a little low - I would review the fill factor you are most likely cauing more page splits than needed
April 8, 2010 at 8:04 pm
if you do it you would want one set of disk per instance. each server would only need the binaries installed once
April 7, 2010 at 5:00 pm
it is fine but I would still keep the SSAS and DB file on different sets of disk and make sure to set the memory correctly for each so they...
April 7, 2010 at 1:04 am
have you tried running profiler or trace against the cubes to get what you need?
April 7, 2010 at 12:49 am
if you have enough resources and enterprise edition you should be able to do the operation online and only rebuild if you need to. I would start with looking at...
April 7, 2010 at 12:47 am
Viewing 15 posts - 1 through 15 (of 134 total)