guyS's WebLog - All Comments

re: Using Embedded Resource in your application

rulame? — Wed, 04 Nov 2009 19:05:14 GMT

have to agree u r dumb 4 writing like this

save the abbreviations for your cell phone

re: NVARCHAR versus VARCHAR

Dave — Tue, 03 Nov 2009 03:12:18 GMT

What about conversion issues since ADO.NET uses Unicode and indexing etc. searching for varchar with an nvarchar parameter? Does that blow the indexing?

» VARCHAR VS NVARCHAR Sean's Blog

» VARCHAR VS NVARCHAR Sean's Blog — Fri, 23 Oct 2009 14:16:13 GMT

Pingback from » VARCHAR VS NVARCHAR Sean's Blog

re: Add HTML Intellisense to your custom web control using XSD generator...

No_limits92 — Thu, 22 Oct 2009 21:48:28 GMT

Trends have to be decided upon at appropriately long timescales. ,

re: NVARCHAR versus VARCHAR

Badri — Mon, 14 Sep 2009 18:49:44 GMT

I totally agree, If you don't need it shouldn't be using NVarchar as size of data increases, transmission time increses. Good Article

re: Get SqlException friendly messages using its Error Number

Gary — Thu, 20 Aug 2009 19:43:41 GMT

select *

from master.dbo.sysmessages

where msglangid = 1033 -- English

order by error

re: Get SqlException friendly messages using its Error Number

GerardMX — Thu, 13 Aug 2009 11:59:19 GMT

Ganesh. You can find all the error codes in the sysmessage table in the master DB in SQL Server for all languages, 1033 for english.

re: NVARCHAR versus VARCHAR

Gary Howlett — Mon, 20 Jul 2009 13:11:41 GMT

Space may not be a problem these days, however I typically see the bigger the database the longer it may take to perform IO intensive queries.

Of course 1/2 the field size dosent mean 2x the query speed however what about when transmitting the data? espically over slower network.

Also why not use a user defined datatype, so if you do need to change the type the task is a little easier.

re: Get SqlException friendly messages using its Error Number

Marwan — Thu, 09 Jul 2009 09:50:10 GMT

Realy Nice Job Thanks

re: Using Embedded Resource in your application

Chris — Wed, 08 Jul 2009 18:48:03 GMT

Maybe he posted the the blog from his phone. If so, you gotta hand it to him typing out all that code through the phone.