Viewing 15 posts - 106 through 120 (of 130 total)
ah.... Insert. (Hits self with palm to head) Thank you guys. I'm going to give that a try. Thats super helpful.
June 7, 2011 at 7:40 am
Also I hate to ask a stupid question but if a database is using the full recovery model isnt it then transactional?
If it isn't then what determines if a database...
May 20, 2011 at 1:44 pm
MysteryJimbo (5/18/2011)
May 18, 2011 at 9:25 am
MysteryJimbo (5/18/2011)
So long as the table contains a primary it doesnt matter.
A snapshot is only required to initialise a subscriber. After this you will only need to generate small...
May 18, 2011 at 8:13 am
Suresh B. (5/17/2011)
No logins are replicated. You have to create them yourself.
Few...
May 18, 2011 at 6:41 am
Stefan,
I am going to give this a go keeping in mind all the points you brought up. If you have some time can you look at the code I...
April 21, 2011 at 9:12 am
Stefan Krzywicki (4/7/2011)
Stefan Krzywicki (4/6/2011)
If you primarily query by document_no, then you might want to partition by...
April 13, 2011 at 10:00 am
Stefan Krzywicki (4/7/2011)[hr
I really think the best way for you to improve performance on this table is to learn more about indexes and primary keys and improve the ones you...
April 13, 2011 at 9:37 am
Stefan Krzywicki (4/6/2011)
It depends on how you're...
April 7, 2011 at 12:00 pm
Jeff Moden (4/7/2011)
kwoznica (4/1/2011)
Jeff,
First, no, it would not need to be a part of the front end. It could be setup to default to whatever the current date...
April 7, 2011 at 11:46 am
Jeff,
What would be the best way to do that though?
We already have millions of records. Also would it need to be part of the front end application?
April 1, 2011 at 12:07 pm
Thanks to both of your for the feedback. I'll give that document a read through today. I think I'll be able to use the document no_ column I described. Its...
April 1, 2011 at 6:19 am
Andy,
Great article and I am looking forward to the rest of the series. I am just starting to learn SSIS as my company is looking for faster ways to...
March 30, 2011 at 7:00 am
Lowell (3/29/2011)
also exec sp_help [tablename] provides a lot of nice information, when you need one specific table's info.
nivek-224024 (3/29/2011)
March 29, 2011 at 9:56 am
Viewing 15 posts - 106 through 120 (of 130 total)