Viewing 15 posts - 3,256 through 3,270 (of 9,643 total)
The easiest way is to use SSMS. Right-click on the table, select Script Table AS -> CREATE TO -> New QUery window. Then change the table name in...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:29 pm
Okay this is like duplicate post #7 for this problem. I also provided an answer here. Which I would not have wasted my time with had there been...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:23 pm
Hopefully this is the last duplicate I find of this post. I posted an answer here. On the bright side my post count is climbing.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:18 pm
Duplicate post. Please post answers here. Hopefully I won't find another one.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:17 pm
Okay, there are a few things.
1. It would help if we had full table definitions. For example, are they separate indexes on each of the columns you list...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:15 pm
Duplicate post. Please post answers here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:01 pm
Duplicate post. Please post answers here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:00 pm
Duplicate post. Please post answers here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 12:00 pm
I usually don't jump in on threads that have already had several answers, but I do have a couple of comments.
Your clustered index is probably not the best candidate/design for...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2010 at 11:55 am
emblabac (2/22/2010)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 2:45 pm
HowardW (2/22/2010)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 1:56 pm
Did you read the article I linked to? Setting TrustWorthy on has effects as well, so be sure that's what you really want to do.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 8:45 am
I think you want sp_changeobjectowner
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 7:36 am
I'm not sure, but I would guess that you are missing it because you are filtering based on an application, user, or database. In a simple test I am...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 7:33 am
Is the data coming from one database? If so, then the best solution, in my opinion, is to bring all the data in one dataset and use the grouping...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 22, 2010 at 7:25 am
Viewing 15 posts - 3,256 through 3,270 (of 9,643 total)