There are very few ways to scale out MSSQL, and by that I mean writes. SSB is one option to handle multi-master write mirroring, where you can't get away...

I don't think there is anything built-in to SQL Server that does this, so you'll need to write some code to do it.

I've been playing around with this CLR UDF and it...

...Hopefully the "Plan Guides" feature in Yukon is the answer to all of our prayers...

Sorry typo

CONVERT(DECIMAL(10,4), LEFT(@test, @@MAX_PRECISION))

Would this work for you? 

CONVERT(DECIMAL(10,4),LEFT(@test), @@MAX_PRECISION))

Where @test-2 is the numeric value (varchar)

I have the same problem frequently, did you ever figure this one out?

We are currently just restarting the SQL Server service, but this is a bad practice.

I ran the example given (added bigger table to give reads but almost exact) and I could not reproduce the behavior. 

.Net SqlClient Data Provider

RPC:Completed

exec dbo.myProc @myparam = 'ALL'

358 reads

SQL Query Analyzer

SQL:BatchCompleted

exec...

The Index Tuning Wizard does an "OK" job of this, however I would recommend monitoring your SQL Server and looking at the batches with the highest number of "reads" and...

I've played around with this a bit in ADO and I've found a couple things:

1. Use command objects to explicitly bind each parameter for your stored procedure (for EVERYTHING).  This has two...

There are many ways to retrieve data in ADO.NET, and there are performance trade-offs with each.  Also the data provider, object properties, and opening/closing method come into play.  In other words,...

I'm having this same issue, (more than 2 years later I realize) but did you figure this out?  Can you tell me how to analyze the value of setopts?

No one commented on whether or not they considered datatypes keywords and therefore used uppercase.

For example:

DECLARE @FirstName varchar(50)

vs.

DECLARE @FirstName VARCHAR(50)

It's worth noting however, that using UDFs limit your application's ability to scale. If you will never have more than a couple hundred rows in your tables, it's probably...

You never asked if there were any tools that helped in creating bulk-load schemas;  In which case, use Altova Mapforce/XMLSpy in conjunction with the SQLXML documentation.

Trial version is available at

OK, I don't know if this will help, as it uses an annotated XDR-schema.  I'm just going to reiterate an example from Professional SQL Server 2000 XML, Wrox 2001 (ISBN:1861005466). ...