Browse by Tags
All Tags »
Sql Server (
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...
Have you ever wondered how many rows your SQL Server database tables contains? A few times now I've wanted to grab a list of table names with the row count for each table. In a post about a few undocumented Stored Procedures I came across this neat script. EXEC sp_MSforeachtable 'SELECT ''?'', Count(*) as NumberOfRows FROM ?' It uses an undocumented stored procedure that iterates over all user tables in the database. The only issue I had with it, was that the output was...
Not really screwed, but I wasted some quality time that could have been better spent with the kids.
Here's what went down:...
Kimberly Tripp announced that she has started to collect what she believes are the best white papers available for Sql Server. There are white papers for MSSQL 2000 & 2005.