jurgenasselman.blogspot.com
Jurgen's Blog: May 2011
http://jurgenasselman.blogspot.com/2011_05_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Monday, 9 May 2011. Stand out from the crowd with Microsoft technology. Subscribe to: Posts (Atom). A Developer's Blog. Koen's blog Certified SQL Server Developer. Snowball - The Blog. Jurgen Asselman. Picture Window template. Powered by Blogger.
jurgenasselman.blogspot.com
Jurgen's Blog: SQL Server Denali - LAG and LEAD
http://jurgenasselman.blogspot.com/2011/09/sql-server-denali-lag-and-lead.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Thursday, 15 September 2011. SQL Server Denali - LAG and LEAD. This is a short post on 2 new T-SQL features called LAG and LEAD, they are kind like Bonny and Clyde, they are mentioned in the same phrase. LAG and LEAD accesses the data from respectively the previous and the next row in a table without using self joins. OVER ( [ partition by clause ] ).
jurgenasselman.blogspot.com
Jurgen's Blog: January 2009
http://jurgenasselman.blogspot.com/2009_01_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Wednesday, 21 January 2009. Length of LOB data to be replicated exceeds configured maximum 65536. This week I came across the following error :. Length of LOB data to be replicated exceeds configured maximum 65536. When we where uploading pictures to store in a column of data type "Image" into our SQL server 2005 database. Or via the Management Studio.
jurgenasselman.blogspot.com
Jurgen's Blog: February 2009
http://jurgenasselman.blogspot.com/2009_02_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Monday, 23 February 2009. Adding toolbox items crashes VS2008. The toolbox in an open. Visual Studio 2008 environment. I had some strange behavior when selecting ". In fact there was no behavior at all . my development. Rather annoying if you try to add some new items don't you think? The problem is caused by the. Uninstall the Power Commands 2008 Addons.
jurgenasselman.blogspot.com
Jurgen's Blog: What about my indexes?
http://jurgenasselman.blogspot.com/2012/03/what-about-my-indexes.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Monday, 19 March 2012. What about my indexes? No need to say that indexes on tables are important, as they directly affect the performance of your queries and data applications. First, a script is shown below, which will give you a result set, showing the indexes and their usage statistics:. Avg fragmentation in percent. Avg fragment size in pages.
jurgenasselman.blogspot.com
Jurgen's Blog: July 2011
http://jurgenasselman.blogspot.com/2011_07_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Tuesday, 19 July 2011. New Date and Time functions in "Denali" CTP3. I've been playing around with the CTP3 of Denali and stumbled upon some new functions. The new functions are :. DATEFROMPARTS(@year, @month, @day). Returns a DATE value. DATETIMEFROMPARTS(@year, @month, @day, @hour, @minute, @seconds, @milliseconds). Returns a DATETIME value.
jurgenasselman.blogspot.com
Jurgen's Blog: April 2011
http://jurgenasselman.blogspot.com/2011_04_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Thursday, 21 April 2011. Execute a stored procedure on SQLServer Startup. For a project we needed to run some T-SQL scripts when the SQL Express Database Engines on the client machines started (we need to have data available offline). To get the job done, SQL Server has the possibility to execute a stored procedure at it's startup. To turn it off again:.
jurgenasselman.blogspot.com
Jurgen's Blog: March 2012
http://jurgenasselman.blogspot.com/2012_03_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Monday, 19 March 2012. What about my indexes? No need to say that indexes on tables are important, as they directly affect the performance of your queries and data applications. First, a script is shown below, which will give you a result set, showing the indexes and their usage statistics:. Avg fragmentation in percent. Avg fragment size in pages.
jurgenasselman.blogspot.com
Jurgen's Blog: November 2011
http://jurgenasselman.blogspot.com/2011_11_01_archive.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Friday, 4 November 2011. A view on storing file data in SQL Server. Storing file data (BLOBs) ( eg. Word, excel .) in SQL server always has been some kind of dark magic to a lot of people. Before SQL Server 2008 we could store the BLOB data in VARBINARY(MAX) datatypes. In which you also had to convert the BLOB data into the binary format yourself .
jurgenasselman.blogspot.com
Jurgen's Blog: Computed colums and DateTime queries
http://jurgenasselman.blogspot.com/2013/04/computed-colums-and-datetime-queries.html
SQL Server and .NET Consultant. MCTS SQL Server 2008 - Implementation and Maintenance / Database Development. MCITP SQL Server 2008 - Database Developer. Tuesday, 23 April 2013. Computed colums and DateTime queries. Computed columns are there for already a long time, but still, I feel it's worth refreshing one's memory once in a while, so consider this is as a reason for this post. Expressions can be a:. Combination of the above connected by operators. Computed columns are virtual columns that are not ph...