Browse by Tags
All Tags »
SQL Server (
RSS)
Just found this on Dan''s Blog , the SQL Server 2008 CTP is available for download. If you're interested in the latest version of SQL Server, then follow any of the links below. The download can be found here If you want to know what's...
In my current project, we calculate the status of tasks that a user needs to do and store the status in a table. This happens on a daily basis. Once every week, we calculate which items are overdue and inform the user by email to take appropriate action...
I was confronted with a slow performing stored procedure in SQL server this week. The procedure was to retrieve one row from a table. But before that row could be retrieved, an update procedure was called to make sure all rows in that table had the correct...
I was looking for a quick way to calculate the last day of the month in T-SQL and bumped into an article written by Gregory A. Larsen on DatabaseJournal.com . The article describes a number of T-SQL methods to calculate different date and time values...
At my current assignment, we have a number of applications that log extensively into a SQL server 2000 database table. These applications log thousands of rows per day, so you can imagine that this table contains huge numbers of rows after only a few...
A few weeks ago, Microsoft have released a newer version of Sql Server Express , the trimmed down version of Sql Server 2005. For example, the database size is limited to 4 Gb. But for applications you want to develop for home use, this is usually not...
The Microsoft E-Learning website is a great source for labs, clinics and other training material. It contains links to other sections of the website. With the introduction of Visual Studio 2005 and SQL Server 2005 later this year, hopefully in November...
Last night, I was anxious to try some stuff with the new VS 2005 Beta I installed recently. First step was to try and create a small database for my sample project. When I opened SQL Server Management Studio, I couldn't connect to my database server....
In my efforts to build a simple, straight-forward, data warehouse for my client, I rely on Data Transformation Services to move data from various databases to my aggregated data warehouse. I already posted about a problem I had with moving text columns...
I recently had to build a couple of DTS jobs to copy data from a customer database into a datawarehouse. Everything seemed to work fine, untill I was asked to create a DTS job that called each of the DTS jobs I had created. From that moment on, one job...
At the moment, I'm working on a conversion between 2 databases. I was looking for a way of avoiding the tedious job of creating command objects for each of the tables I needed to insert data into. In most projects I worked on over the last couple of years...
Normally I leave blogging about SQL-Server to the real SQL_Server experts. But I had to this time. I read an article on unit testing TSQL functions and stored procedures on MSDN . The article mentions a framework which helps you perform this task. In...