Browse by Tags
All Tags »
Performance (
RSS)
Since I'm typing this on my new Eee 1101HA I'm going to keep it short. (I hate these mini keyboards) Keeping an eye on our production Sql Server box is an integral part of my daily routine. I would not categorize myself as a DBA as I don't do much administrative work related to our databases. I'm dealing mainly with issues that are related to development and making sure our system runs efficiently. One of those tasks is to make sure that our database is properly indexed and maintaining...
Say you have a large Xml file that contains relatively tabular data that you want to import into SQL Server. There are several ways to go about this. Let’s look at a couple of options. Load the file into an XDocument. Extract elements from the DOM using Linq and then use ADO.Net to insert the data into the database. Load the data into a DataSet using ReadXml and save the data to the database Read through the data using an Xml reader and save each record to the database Options number 1 and 2 requires...
Scott Guthrie has just posted a post on how to increase the performance of Visual Studio. (The title of this post is actually his) He has posted several blog posts on how to improve the performance of Visual Studio here and here . .NET tip of the day also has a couple of posts on VS performance here and here . In his latest post he points out the importance of the speed of the hard drive. Despite spending most of my time in Visual Studio I've had my fair share optimizing databases. When monitoring...
I don't know exactly why, but for some time, the first time I display a code window within Visual Studio there's intense disk activity for about 10 seconds. From that point on opening other source files is a snap. It's late so I'm going to make this a short one. Locating the problem: 1) I fired up SysInternals fileMon. 2) set it to monitor only the C: drive 3) turned off some disk intensive applications ( Folding@Home , MSN Desktop search...) 4) Created a new project in Visual Studio Stared at the...