Welcome to WindowsClient.net | Sign in | Join

Zuker On Foundations

The realm of .NET (WPF, WCF and all around)

Browse by Tags

All Tags » Database (RSS)
SQL Reporting Services - Query Report Server
It took me quite a while to find a proper example of how to communicate with SQL Reporting Services in order to execute a specific report, I though I might share it. We have Report Server 2008 installed over SQL Server 2005. I needed to extract data of...
Posted: Jan 11 2009, 05:11 PM by Amir Zuker | with no comments
Filed under:
SQL 2008 - Filestream vs. Blob
Read the full details here . In essence: Filestream will save the files on the filesystem giving you streaming capabities with the use of public filesytem API along with preferred performance over normal BLOB. From the post - Rule of thumb: Data >...
Posted: Nov 18 2008, 03:58 PM by Amir Zuker | with no comments
Filed under: ,
T-SQL - Create Unique Constraint
Searched it for a while, thought it might be worth sharing. Following is the T-SQL script to alter a table to apply a UNIQUE constraint on a certain column: ALTER TABLE [TableName] WITH NOCHECK ADD CONSTRAINT UniqueConstraintName UNIQUE ( [ColumnName...
Posted: Sep 10 2008, 07:44 AM by Amir Zuker | with 1 comment(s)
Filed under:
SQL 2005 - Save File into Image/VarBinary columns
Via this post . I created a column in a certain table to contain various files with "VarBinary(MAX)" as its data type. I wanted to test stuff, so I needed data in the tables. But Oh My, Now What? Should I really write C# Project to insert a...
Posted: Sep 03 2008, 03:43 PM by Amir Zuker | with 8 comment(s)
Filed under:
Forum Model T-SQL Select
I decided to place it here in case I would need such a thing in the future :) The select statement selects forum-like data model which supports paging as well. (Where comments will be below the main entry and so on) DECLARE @Level int DECLARE @CurrentID...
Posted: May 19 2008, 09:08 AM by Amir Zuker
Filed under:
Page view counter