Re-index your database(milkcarton.com)

submitted by daruku(240) 3 years, 3 months ago

FTA: "As our production database gets more and more data in it, we noticed that things were slowing down. I ran SQL Profiler trying to figure out if we needed to ad more indexes, better arrange the data, or anything we could do to improve the performance. After about an hour of running queries, creating indexes, profiling, and looking at execution plans; I had gotten barely anything for performance gains." read more...

add a comment |category: Tips & Tricks |Views: 405

tags: Tips SQL another

Live Framework Triggers(orand.blogspot.com)

submitted by daruku(240) 3 years, 4 months ago

"The Live Framework has the ability to add triggers to resources. There is some documentation on triggers here and here (pgs. 14-15), but after reading it I was left with more questions than answers. So I took a deep dive exploring the nooks and crannies of triggers and this blog post is the result." read more...

2 comments |category: Live Framework |Views: 136

tags: LiveFramework another

How to get remote debugging to work successfully(milkcarton.com)

submitted by daruku(240) 3 years, 4 months ago

FTA:"After much time, trial and error, I was finally able to get Visual Studio's remote debugging features to work. In my travels around the Internet, no one seems to have compiled all the steps to make the process work successfully and seemlessly into one page, this is my attempt." read more...

3 comments |category: Visual Studio |Views: 284

tags: RemoteDebugging VisualStudio Debugging HowTo another