Viewing 15 posts - 241 through 255 (of 468 total)
Good advice. Thanks all. Im gona start doing a few interveiw's, if for nothing else, for practice. If Something very tempting comes up in the interim then all the better!
Il...
October 29, 2009 at 7:58 am
Silverfox (10/29/2009)see if you can ask for additional responsibilities or opportunities to help the business, and that in turn will help you learn more.
I have tried this, but the organization...
October 29, 2009 at 6:45 am
I passed the 70-432 a few days ago.
I used the Microsoft press prep kit initially but found it far from adequate. For starters it was not edited well and not...
October 18, 2009 at 4:05 am
Jeff Moden (9/28/2009)
SQL Noob (9/28/2009)
and PrepLogic is having a sale. $10 for the 70-432 pdf download with 150 questions
Hmmm... I suppose it comes with the answers to those...
October 16, 2009 at 9:41 am
i needed the largest OrderId for each status, so in this case, the results would be:
(No column name)OrderStatus
2 A
5 B
8 C
10 D
October 16, 2009 at 7:50 am
serious apologies for posting this question. was making it much more complicated that it should be.
its
select max(OrderID),OrderStatus from #orderline
group by OrderStatus
I was trying joins and subqueries and a host of...
October 16, 2009 at 7:42 am
Michael Valentine Jones (10/13/2009)
October 13, 2009 at 11:02 am
Roy Ernest (9/29/2009)
September 29, 2009 at 2:08 pm
Adi Cohn-120898 (9/28/2009)
According to BOL ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/a28c684a-c4e9-4b24-a7ae-e248808b31e9.htm...
...
In short there is no magic number that according to it, you’ll always rebuild or reorganize the index.
Adi
Thanks for the link. i...
September 28, 2009 at 1:47 am
thanks folks! its educational to see all of the options i had in this case!
I love Florians solution, i would have never considered an idea like that.
I ended up using...
September 18, 2009 at 8:45 am
Cool. thanks for the answers. im just wondering as if such an issue occured, and you had to restore, chances are you dont have time to restore a 300gb database...
September 7, 2009 at 2:58 pm
Thanks for the info. I ended up going with the Inside sql server 2005: the storage engine, query tuning and optimization.
I know its sql 2005, but from reviews, it seems...
August 30, 2009 at 8:20 am
Thanks for the responses. that clears a lot of questions up.
August 28, 2009 at 4:51 am
please disregard my silly question. i had forgotten to update the job schedules. all is working fine now.
August 27, 2009 at 2:18 pm
madhukeshwark (8/22/2009)
As per my understanding, u have set the flat file connection manager configuration setting correctly. You need to specify the delimiter in the connection manager.
Pls...
August 22, 2009 at 4:58 am
Viewing 15 posts - 241 through 255 (of 468 total)