Viewing 15 posts - 8,341 through 8,355 (of 9,725 total)
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
Neeta,
You still having this problem?
April 23, 2009 at 4:34 am
sriram979 (4/14/2009)
After getting all the error rows just keep an aggregate transformation task.
< blink > I didn't even think of that one. Thanks! I'll give it a try.
April 23, 2009 at 4:32 am
Check whichever port your endpoint uses. If it's the default (5022), check that. But there is usually 2 ports involved (ISTR) in the creation of endpoints, so make sure they...
April 23, 2009 at 4:14 am
Danb7183 (4/22/2009)The db_datawriter & db_reader gives the 'users' that are external to the domain all the rights that I believe they currently have (i.e. right to connect, add, delete, modify...
April 23, 2009 at 4:12 am
Glad I could help. @=)
April 21, 2009 at 11:13 am
Just went back to my old "Upgrading DBA skills to SQL 2005" book.
Before establishing a mirroring session, you must configure the communication mechanism through which mirroring will occur. This involves...
April 21, 2009 at 11:09 am
Viewing 15 posts - 8,341 through 8,355 (of 9,725 total)