Chad Boyd - All Comments

re: Fragmentation Station - Stop #1 - Storage basics and Access Methods

Nielsjoergen Hvidberg — Tue, 13 Oct 2009 06:47:36 GMT

Hi Chad, what happened to the images in your great article :-)

Setting up your server | Becomming a SQL Master

Setting up your server | Becomming a SQL Master — Tue, 22 Sep 2009 10:02:53 GMT

Pingback from Setting up your server | Becomming a SQL Master

re: SSD and SQL - SQLIO performance

rowlandg — Fri, 18 Sep 2009 14:17:05 GMT

This is a great little article using the basic tests to show the differences between traditional storage and SSDs.

Thank you for this article -- well done!

re: SSD and SQL - Fragmentation Impact

rowlandg — Fri, 18 Sep 2009 14:15:15 GMT

Great job exploring this issue Chad! I have wondered about the SSD performance particularly in the SAN environment. You're the first person I've seen that used the empirical approach to finding the truth.

Like everyone else, I would have bet on the SSDs in all situations. Apparently this is not the case!

Thanks for a great article!

Katmai (Sql 2008) – MERGE – More than UPSERT (more advanced uses) – Chad Boyd | Rickey Whitworths Blog

Mon, 14 Sep 2009 10:48:18 GMT

Pingback from Katmai (Sql 2008) – MERGE – More than UPSERT (more advanced uses) – Chad Boyd | Rickey Whitworths Blog

Nullability settings with select…into and variables

Chad Boyd — Thu, 10 Sep 2009 19:41:08 GMT

Traditionally there has been a single option for pulling data from one result set into a new table using

re: Fragmentation Station - Stop #4 - How to avoid it

rowlandg — Fri, 26 Jun 2009 09:30:32 GMT

Concise and well-reasoned. Well done Chad!

re: Katmai (Sql 2008) - The List of New Features

salvationishere — Sun, 14 Jun 2009 10:02:55 GMT

Hi Chad,

I am trying to run a SQL stored proc from Visual Studio 2008 which takes a table-valued UDT parameter as an input. I added this parameter in Visual Studio 2008 but when I run this program it gets an "ArgumentException - Specified type isn't registered on target server."

So I googled this problem and think I need to create a new class in Visual Studio 2008 matching the properties of this table type from SQL Server 2008. But I can't find any examples on the internet involving *table* UDT's. And I tried all of the scalar UDT examples, but I wasn't sure how to modify these to make it table-based.

I also read I may need to create an assembly, although I don't know if this is required only for importing a type into SQL Server 2008 or if it can also be used to import a type into Visual Studio. BTW, I do not see any types listed from the Server Explorer in VS 2008, although I do see the database and its SP's. I tried refreshing the database, but the types were still not showing.

What I need to do is simple. I have a table UDT like so:

CREATE TYPE [dbo].[parseInputFile] AS TABLE(

[NumCols] [int] IDENTITY(1,1) NOT NULL,

[strRow] [varchar](500) NOT NULL,

PRIMARY KEY CLUSTERED

And the code snippet from my C# code is:

public static int AppendData(string[] myStringArray)

{

SqlConnection conn = new SqlConnection(connString);

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "dbo.uspAppendTableFromInput";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Connection = conn;

SqlParameter param = cmd.Parameters.Add("@InputFileParam", SqlDbType.Udt);

param.UdtTypeName = "AdventureWorks.dbo.parseInputFile";

param.Value = myStringArray;

conn.Open();

RowsAffected = cmd.ExecuteNonQuery();

RowsAffected show zero rows affected after running this. What am I missing? Can u point me to a website demonstrating a simple example of this. Or else give me a tip? I have also tried 'param.UdtTypeName="parseInputFile";' for the above snippet, but this returned the same error. BTW, "myStringArray" is essentially a table. It is a series of strings. e.g. myStringArray[0] = "Hello|Bob|How|Do", myStringArray[1] = "I|Am|Fine|And", etc.

Thanks

Transactional Replication Conversations | Coded Style

Transactional Replication Conversations | Coded Style — Sat, 30 May 2009 14:23:43 GMT

Pingback from Transactional Replication Conversations | Coded Style

Transactional Replication Conversations | Coded Style

Transactional Replication Conversations | Coded Style — Sat, 30 May 2009 14:23:02 GMT

Pingback from Transactional Replication Conversations | Coded Style

Transactional Replication Conversations | Coded Style

Transactional Replication Conversations | Coded Style — Sat, 30 May 2009 14:22:21 GMT

Pingback from Transactional Replication Conversations | Coded Style

Transactional Replication Conversations

Troubleshooting Microsoft SQL Server — Mon, 25 May 2009 14:17:23 GMT

Transactional Replication Conversations When troubleshooting Transactional Replication performance break

Undelete files pictures partitions

Undelete files pictures partitions — Mon, 11 May 2009 20:27:17 GMT

File recovery focuses on getting any deleted lost or damaged files and partitions back in working order. You can do this in most cases with file recovery software but if that doesn't work data recovery companies can do it.

Websites tagged "vba" on Postsaver

Websites tagged "vba" on Postsaver — Sat, 11 Apr 2009 02:17:10 GMT

Pingback from Websites tagged "vba" on Postsaver

Data recovery service experts

Data recovery service experts — Wed, 08 Apr 2009 20:06:50 GMT

Recovery starts with knowing which solution you need to reclaim the lost data. File recovery is the most common one but advanced users often rely a a partition product if the circumstance allows it. Service is for a failing hard drive.