Viewing 15 posts - 7,261 through 7,275 (of 9,715 total)
GilaMonster (10/8/2010)
It may not finish immediately, depending on the amount of dirty pages and the requested checkpoint duration, but it should start straight away.Got a demo or reference?
Only personal experience....
October 8, 2010 at 7:01 am
Okay. I've tested the DDL trigger and it does not work against SSAS databases. Unfortunately.
I have it straight from the horse's mouth that when reprocessing occurs, there is data file...
October 8, 2010 at 6:52 am
Be aware that just typing in CHECKPOINT and executing it does not mean that it will execute immediately. SQL Server will run it immediately only if it's convenient to the...
October 8, 2010 at 5:23 am
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
October 8, 2010 at 5:17 am
Jeff Moden (10/8/2010)
WayneS (10/7/2010)
Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspxTime to get the crystal ball out again.
Apparently it's my turn to feel snippy. I...
October 8, 2010 at 5:16 am
Stefan Krzywicki (10/7/2010)
October 7, 2010 at 12:41 pm
That's good information, Stephan. I didn't even see that there. Thanks.
October 7, 2010 at 12:34 pm
Stefan Krzywicki (10/7/2010)
Brandie Tarvin (10/7/2010)
October 7, 2010 at 12:10 pm
Kit G (10/7/2010)
Brandie Tarvin (10/7/2010)
jcrawf02 (10/7/2010)
October 7, 2010 at 11:59 am
Stephan Douglas (10/7/2010)
If the SSAS database is no longer visible in management studio.
Check the file system for the db files, see if somehow they got deleted.
Stephan, I found out this...
October 7, 2010 at 11:54 am
jcrawf02 (10/7/2010)
October 7, 2010 at 11:48 am
liewsb (10/7/2010)
Hi Gail and Brandie,Thanks for your helps so far.
AS I just take other this DB job, I really need you all helps to slove this urgent issue now...
Stop. Take...
October 7, 2010 at 11:45 am
But if you're going to rename and alter, you might as well just drop and create. It's cleaner.
October 7, 2010 at 9:40 am
Nakul Vachhrajani (10/6/2010)
Use sys.sql_modules instead.
Thanks, Nakul. I didn't even know this table existed.
October 7, 2010 at 6:08 am
Viewing 15 posts - 7,261 through 7,275 (of 9,715 total)