Geeks With Blogs
DevJef's Mumbo-Jumbo «There's a bit of SQL in all of us» September 2011 Entries
Quick performance test in SQL Server
In order to test Performance in SQL Server, normally you would take a look at how may I/O or how many cycles a statement takes to complete. To make it less complex, you can take a look at how long a statements takes, just by looking at the execution-time. In most cases, network latency, SQL Server hardware and workstation performance are also included in this result (time to create result set, and time needed to send across the internet or internal network). And if a statement takes les then a second ......

Posted On Wednesday, September 28, 2011 2:33 PM

Deploying Report Builder 3.0 reports on 2005 Report Server
How fun is it to use new software? As a developer you always want to use the latest software, and in many cases it’s backwards compatible. This (unfortunately) isn’t the case with Report Builder 3.0 and SQL Server 2005 Reporting Services. This is a “by design” issue, but it’s such an annoying “feature”. If you try to deploy a Report built in RB 3.0, you will get the error: "The report definition is not valid. Details: The report definition has an invalid target namespace ' ......

Posted On Monday, September 26, 2011 3:06 PM

Time-outs and locks on objects
How often does it happen: you write an application that uses a SQL Database as source, and when you want to fetch data you get a time-out. Damn! But when you need to get a time-out (for example, if you want to test an exception), you don’t get one. In SQL Server you can create your own time-outs if you want. One of the simplest ways to generate a time-out, is to lock an object, and running a query against the object in another session. You can lock an object with a simple query: SELECT * FROM Company ......

Posted On Saturday, September 24, 2011 3:36 PM

Parameters in Report URL
A colleague asked me if it’s possible to set the parameters of a Report in the URL, so that he could send it to an end-user. I didn’t know the answer, and after some research I came to the conclusion that it’s possible. Just like your used to, you pass parameters into the Report by modifying the URL. An example of a normal Report URL looks like this: http://<ServerName>/R... In order to use parameters in the URL, you need to use the Service URL. The Service URL has the possibility to add ......

Posted On Friday, September 23, 2011 3:05 PM

Last update on object?
How many times do you wonder about when an object was last updated? You can find out by using the default sysobjects in SQL Server: USE Adventureworks DECLARE @DBID INT = DB_ID('Adventureworks') SELECT AS TableName, ddius.* FROM sys.dm_db_index_usage_stats ddius JOIN sys.objects o ON o.object_id = ddius.object_id WHERE database_id = @DBID ORDER BY ddius.last_user_update DESC This will give you the last_user_update, which is based on indexes. The Insert, Delete or Update are stored in the sys ......

Posted On Wednesday, September 21, 2011 8:56 PM

Preflight Checklist

This blog will be used as a collection of scripts, experiences and adventures in my weird travels around Development-Land:

  • Blog? Check!
  • Scripts? Check!
  • Stuff to blog about? Check!

Preflight check completed!

Posted On Wednesday, September 21, 2011 4:41 PM

Copyright © DevJef | Powered by: