Viewing 15 posts - 8,311 through 8,325 (of 9,701 total)
I think the only way to do this is to use Profiler or run a trace against your system. But this will only give you a snapshot in time. It...
May 18, 2009 at 4:40 am
Hate to say it, but I believe the backup chain was broken when the Recovery Mode was reset. This is probably why you can't continue with the log restores.
My advice...
May 18, 2009 at 4:37 am
This sounds suspiciously like a homework or test question. We don't answer those on this site. It shouldn't be too hard for you to find the answer. Look up MDX...
May 18, 2009 at 4:35 am
rudy komacsar (5/15/2009)
Here are a couple of backup options ...- LiteSpeed
- Striping - http://www.sqlservercentral.com/Forums/Topic704434-357-1.aspx
Not quite what I'm talking about, Rudy. @=)
Though the striping could be used as part of the...
May 15, 2009 at 7:58 am
I don't have specific links, but check out Backup in Books Online or Google "Backing up SQL Server", "Backup VLDB SQL Server", things like that.
The problem is, because everyone's...
May 15, 2009 at 7:18 am
Your backup strategy may need to be revisited at this point too. If you're still using the "small DB backup" strategy, it's probably taking a ton of maintenance time.
Regardless, if...
May 15, 2009 at 5:53 am
Roust_m (4/29/2009)
Too much manual work. ... I really can't use these options.
Well if everything we suggest is too much work, then I'm afraid we can't help you.
Sorry.
April 30, 2009 at 4:04 am
You're welcome. And thanks for the luck.
Let me know whether or not this does what you're wanting.
April 29, 2009 at 12:04 pm
Bad joins between the Dimension tables and the Fact tables. Depends on whether you're getting too many records or not enough records.
Check your table relationships.
April 29, 2009 at 11:27 am
Right click Cubes, go to New Cube and, in the Wizard, choose "Build the cube without using a data source". Then you can generate a schema and do something...
April 29, 2009 at 11:24 am
Aha. Just found out there are still columns in my pre-aggregated tables that can be grouped and measured on.
Nevermind. @=)
April 29, 2009 at 11:21 am
I'm new to this myself, but I'll take a stab at the answer.
I don't think there is a real criteria. I think it depends on how you want your numbers...
April 29, 2009 at 11:20 am
Cursor is your best option here, then. Use the below code to get your list of database names. Use the FETCH statement against this list. Plus, add a variable that...
April 29, 2009 at 4:35 am
murthykalyani (4/23/2009)
Can't you create / extend file on new drive if you have?
You don't need multiple filegroups to put files on different drives. Just multiple files themselves. They can all...
April 23, 2009 at 5:10 am
Jason T (4/7/2009)
So now I have a new question - is it bad design to build a database primarily on the PRIMARY file group?
Depends on the database. We...
April 23, 2009 at 4:38 am
Viewing 15 posts - 8,311 through 8,325 (of 9,701 total)