Viewing 15 posts - 6,736 through 6,750 (of 9,725 total)
Ah. Thanks for the clarification.
January 19, 2011 at 11:33 am
Is "id" perhaps a user created data type that doesn't exist on the new server?
EDIT: I ask because I've never seen unique(id) as proper column name before. It looks more...
January 19, 2011 at 11:13 am
SMS?
Not sure what you mean by that. Could you translate for those of us who aren't coders?
January 19, 2011 at 11:08 am
Reporting Services is a separate tool. I don't believe it comes with Express. You have to go download it with the Advanced Services.
See this reference: http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx Look for the Business...
January 19, 2011 at 11:06 am
GAH. My boss figured it out.
Had to go into Dimension Usage on the cube screen, right click in the "white space" and add new cube dimension.
But I don't know why...
January 19, 2011 at 9:14 am
The Missing Index feature of SQL Server is just recommendations by the server and is not necessarily something to follow. Sometimes, based on bad statistics and other stuff, it can...
January 19, 2011 at 7:40 am
subha.mcts2005 (1/19/2011)
I am asking why indexes are missing?
As the others have indicated, you need to give us more information. How did you find out indexes were missing? What process, error...
January 19, 2011 at 7:30 am
Daniel Bowlin (1/19/2011)
CirquedeSQLeil (1/18/2011)
Rumor
The administrators of Area 51 have decided that since everyone knows about them that they are going to hold an open house on April 1st in an...
January 19, 2011 at 7:11 am
Ditto to Lynn's comment.
I've found that if there's network connectivity disruption during a file move, that the connection on my side doesn't necessarily know that it's been broken. So the...
January 19, 2011 at 7:05 am
I'm not sure I understand the question. Did you actually create the indexes? If so, are you sure they actually created and didn't just error out?
January 19, 2011 at 7:02 am
I don't see them in SSMS either. I think this is probably the way it's supposed to be.
January 19, 2011 at 7:01 am
Does the .dll need to be registered?
January 19, 2011 at 6:53 am
What you want to do can be as easy (or as hard) as you want it to be. Look up SSIS tutorials on Google or Microsoft's websites. Books Online is...
January 19, 2011 at 6:52 am
I should add that this Date table is based off a Named Query pre-exists in the DSV, so it's not one I'm creating from scratch.
January 19, 2011 at 6:49 am
And I could do one on auto restores to another instance / server. If you wanted something that comes after the basic.
January 19, 2011 at 6:46 am
Viewing 15 posts - 6,736 through 6,750 (of 9,725 total)