Viewing 15 posts - 32,806 through 32,820 (of 39,818 total)
I think you have things a little out of order.
I'm not sure you need to disconnect from the domain, but wouldn't you create all the partitions and copy the files,...
December 21, 2006 at 1:21 pm
You can set the default file to be the NDF in the database properties. Then you can move the tables that experience growth to the new file by recreating their...
December 21, 2006 at 12:45 pm
Very nice. Hope you had good boots for the outing.
We've got a blizzard in Denver today. Stuck in the house all day, horses locked up because of the 30+mph winds...
December 20, 2006 at 6:01 pm
Don't mind Bob. He's got brain freeze from standing outside the office door too long looking for the sun ![]()
December 20, 2006 at 4:43 pm
I'm not sure there's less infrastructure required, but it's an argument being made by salesforce.com, SAAS, and others since they do some help desk stuff for their software.
I do agree...
December 19, 2006 at 5:18 pm
Event Viewer also shows. Not sure of the entry, but you can filter on the service and check on the #.
December 19, 2006 at 8:38 am
Do you mean you created an SSIS package?
December 19, 2006 at 8:36 am
No difference. They are the same thing. Scheduling inside the plan adds a job to the server. With SP2 you'll be able to add multiple schedules.
December 19, 2006 at 8:32 am
I would agree with Colin. Answering these in an interview and getting the job lets you and the employer down. Especially if you cannot even find the answers in Books...
December 19, 2006 at 8:29 am
December 19, 2006 at 8:26 am
Third vote for app roles. Andy Warren has written about them and this is why he doesn't like Windows auth for anything other than login. Prefers to have them connect...
December 19, 2006 at 8:24 am
Brian,
Glad it's working, but can you tell us the ini file? Someone might run into this again and it would be nice if they saw your solution.
Thanks
December 19, 2006 at 8:22 am
No automatic way. I guess partitioned tables could work, but it's up to you.
One thing that might make sense is creating another database, duplicate the table and then copy the...
December 18, 2006 at 8:52 am
While it's a bad practice and could prevent you from selling the product in some cases, especially where Sarbanes Oxley is being taken seriously, you're right. Ultimately it's a management...
December 18, 2006 at 7:41 am
That seems like a bug if it's fragmentation related. I'd spend the $$ for a call to PSS and have them diagnose it. They're good and the money is refunded...
December 18, 2006 at 7:32 am
Viewing 15 posts - 32,806 through 32,820 (of 39,818 total)