CREATE PROCEDURE… WITH NO_RECOMPILE???

Hi all,

Here is an interesting case I encountered recently.

I have a procedure that takes >45 sec to complete.
The users would very much like to have it execute much faster.
It has > 11,000 lines of code and originally, it went something like this: (more…)

Javier Loria

Javier es Mentor de SolidQ basado en Costa Rica. Él comenzó su carrera profesional en 1992, como un desarrollador de software e ingeniero de sistema. Su carrera evolucionó rápidamente hacia la formación, especialmente en el mundo XML y OLAP, con clientes de formación en diferentes lugares en América Latina. Es un arquitecto de software y ayuda a nuestros clientes en América Latina a implementar arquitecturas de Business Intelligence. Javier se convirtió en SQL Server MVP en 2001 y es un MCT, MCSE, MCSD, y MCAD. Javier fue uno de los autores de los cursos de entrenamiento Microsoft de Microsoft SQL Server 2005. Es el coautor de varios libros, incluyendo MOC2782: Diseño de bases de datos de Microsoft ® SQL Server ™ 2005, el kit de formación MCTS 70-431: implementación y mantenimiento de SQL Server 2005 y Microsoft SQL Server 2005 Database Essentials Step by Step.
Everything is not what it seems

Everything is not what it seems

Javier Loria

Javier es Mentor de SolidQ basado en Costa Rica. Él comenzó su carrera profesional en 1992, como un desarrollador de software e ingeniero de sistema. Su carrera evolucionó rápidamente hacia la formación, especialmente en el mundo XML y OLAP, con clientes de formación en diferentes lugares en América Latina. Es un arquitecto de software y ayuda a nuestros clientes en América Latina a implementar arquitecturas de Business Intelligence. Javier se convirtió en SQL Server MVP en 2001 y es un MCT, MCSE, MCSD, y MCAD. Javier fue uno de los autores de los cursos de entrenamiento Microsoft de Microsoft SQL Server 2005. Es el coautor de varios libros, incluyendo MOC2782: Diseño de bases de datos de Microsoft ® SQL Server ™ 2005, el kit de formación MCTS 70-431: implementación y mantenimiento de SQL Server 2005 y Microsoft SQL Server 2005 Database Essentials Step by Step.

CircularString Myth

In search for some knowledge about CircularString I stumble on the following content:

“A CIRCULARSTRING line is a sequence of an odd number of at least three points, which are connected to form a curved arc. For example, consider the following Transact-SQL:

(more…)

Latest posts by Ken Spencer (see all)

Visual Studio: Lightswitch

Latest posts by Ken Spencer (see all)

Check out this post from my good friend Andrew Brust on the new Lightswitch release from Microsoft.

Lightswitch can generate Siliverlight applications quickly. It runs in Visual Studio and allows the developer to really generate the application quickly and get it up and running.

I saw a demo of this technology several years ago and even then it was unreal.

(more…)

Latest posts by Ken Spencer (see all)

.Net: Serializing a class too and from SQL Server

Latest posts by Ken Spencer (see all)

Recently we had to save a class as xml in SQL Server and then restore it. Turns out the default type was UTF-8 and the SQL Server xml type uses UTF-16, so it did not work.

Then i found this:http://support.microsoft.com/kb/317169

(more…)

Latest posts by Ken Spencer (see all)

Silverlight: Case Studies

Latest posts by Ken Spencer (see all)

Check out these new case studies on large Sl implementations:

NBC USA
NRK, Norway
France Televisions

They give good insight to managers on why Silverlight matters but also provide good examples of what you can do with Silverlight. for instance, check out the NBC one and look at Figure 2.
Fore more great ideas go to the Silverlight showcase site: http://www.silverlight.net/showcase/

Latest posts by Ken Spencer (see all)

IIS 7 and SL 4 2103 error

IIS 7 and SL 4 2103 error

Latest posts by Ken Spencer (see all)

I have a new build of win 7 64x on my laptop that’s about a week old. I have a pretty complex Sl 4 app that runs fine if using the vs host in 2010. If i flip the setting in the web project to use the IIS Web Server and run it, I get this:

Line: 56 Error: Unhandled Error in Silverlight Application
Code: 2103    Category: InitializeError
Message: Invalid or malformed application: Check manifest

(more…)

Latest posts by Ken Spencer (see all)

Silverlight 4: ChildWindow

Latest posts by Ken Spencer (see all)

One of my favorite features of SL 4 is the childwindow. You can add a window to your project just like in WPF and then add all the xaml to it. Then define it in your code. For instance, the following code references a childwindow called ItemMaintenance. Its creates a new instance of it, then wires up a closed event, then shows the window. (more…)

Latest posts by Ken Spencer (see all)

Silverlight 4: Datagrid

Latest posts by Ken Spencer (see all)

Today i am building features using the new Datagrid for SL 4. Pretty cool.
I wanted to be able to set the column widths and headers magically in code. So i added names to the column headers like so:

(more…)

Latest posts by Ken Spencer (see all)

VS2010 Silverlight:Bug with XAML Files and code behind

Latest posts by Ken Spencer (see all)

I have a bug that has been recurring with some frequency during the RC cycle of VS 2010 and its still there in the RTM.Lets say I have a SL usercontrol with several fields on it. All of a sudden the usercontrol gets in a state where the code behind cannot see the fields in the XAML. If you try and specify the fields in code, intellisense does not work and typing the field name generates an error.

(more…)