Sunt doua coloane diferite aparent in acest caz.

When you have just become comfortable with the idea that you have to certify yourself on SQL Server 2005 - guess what - new certifications are coming. My advice - if you have the time - take the SQL Server 2005 certifications as SQL Server 2008 builds on SQL Server 2005. However, for a preview of the new certifications you can participate in a ...

Statisticile sunt folosite. Selectivitatea indexului nu este 1,2 - este 1,2 pentru coloana_x=1 insa poate fi 0.01 pentru coloana_x = 3. Selectivitate = The fraction of rows from the input set of the predicate that satisfy the predicate. http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

In a discussion with Remus Rusanu, he reminded me that if you use a SqlString to pass a varchar(max) to a client application, the whole value is copied into the memory (think big - a varchar(max) can have up to 2GB). The alternative is to use streaming and one method of doing that is to use SqlChars.  

Here you have http://sqlserver.ro/blogs/cristians_blog/archive/2008/01/08/vscmdshell-a-powershell-add-in-for-microsoft-visual-studio.aspx

LEAD Technologies Inc. V1.01

To answer a question on a previous blog post - YES, there is a PowerShell Add-In for Visual Studio - the VSCmdShell. It works with Visual Studio 2005 and Visual Studio 2008 (I tested with 2008 version) and you can also get the code for it from the project home on codeplex.com. More about it here: VS Command Shell - Home Bertan's ...

LEAD Technologies Inc. V1.01

LEAD Technologies Inc. V1.01

One of the perks of being MVP is that you can use lots of commercial applications for free. Two of them come from Shell Tools: PowerShell Analyzer and PowerShell Plus. If you are into PowerShell then I recommend you to at least download the free version of PowerShell Pluss and give it a try. You will be impressed. PowerShell ...