Eric Z Beard

Clearwater, FL

Age: 40

CTO at Loop, LLC

ericzbeard at yahoo dot com

top accounts reputation activity favorites subscriptions

Why do we need entity objects?

sql database orm entities asked Aug 20 '08 at 19:37

stackoverflow.com

97 votes

What's the difference between a temp table and table variable in SQL Server?

sql-server asked Aug 26 '08 at 12:27

stackoverflow.com

48 votes

Is there a standard for storing normalized phone numbers in a database?

database asked Sep 3 '08 at 15:22

stackoverflow.com

25 votes

Why does Sql Server keep executing after raiserror when xact_abort is on?

sql sql-server tsql asked Sep 16 '08 at 20:04

stackoverflow.com

19 votes

How do you deal with transport-level errors in SqlConnection?

c# .net sql database sql-server-2000 asked Aug 19 '08 at 17:36

stackoverflow.com

18 votes

How is OpenID implemented?

openid dotnetopenauth asked Sep 23 '08 at 20:33

stackoverflow.com

16 votes

Why are relational set-based queries better than cursors?

sql language-agnostic query cursors asked Aug 23 '08 at 12:04

stackoverflow.com

15 votes

Query times out from web app but runs fine from management studio

sql sql-server asked Aug 13 '08 at 15:49

stackoverflow.com

13 votes

How can I connect to Sql Server from a Mac with PHP PDO?

php sql-server pdo asked Nov 14 '12 at 0:30

stackoverflow.com

12 votes

Is it worth the trouble to use tinyint instead of int for SqlServer lookup tables?

sql sql-server database-design asked Nov 19 '08 at 20:06

stackoverflow.com

Top Answers

196

What is the worst gotcha in C# or .NET?

stackoverflow.com

What are the pros and cons to keeping SQL in Stored Procs versus Code

stackoverflow.com

How do I check if a SQL Server text column is empty?

stackoverflow.com

List of standard lengths for database fields

stackoverflow.com

LINQ-to-SQL vs stored procedures?

stackoverflow.com

Why does the ASP.Net Web Forms model “suck”?

stackoverflow.com

Dynamic Sorting within SQL Stored Procedures

stackoverflow.com

Disadvantages of Test Driven Development?

stackoverflow.com

Functions vs Stored Procedures

stackoverflow.com

SQL Server Regular expressions in T-SQL

stackoverflow.com

Are foreign keys really necessary in a database design?

stackoverflow.com

C# numeric constants

stackoverflow.com

What do “branch”, “tag” and “trunk” mean in Subversion repositories?

stackoverflow.com

.NET Configuration (app.config/web.config/settings.settings)

stackoverflow.com

Why is my asp.net application throwing ThreadAbortException?

stackoverflow.com

What are some viable alternatives to BizTalk Server?

stackoverflow.com

Good strategy for leaving an audit trail/change history for DB applications?

stackoverflow.com

Advantages and disadvantages of GUID / UUID database keys

stackoverflow.com

Strangest language feature

stackoverflow.com

Effectively Converting dates between UTC and Local (ie. PST) time in SQL 2005

stackoverflow.com

Wait until file is unlocked in .NET

stackoverflow.com

Is it possible to send a collection of ID's as a ADO.NET SQL parameter?

stackoverflow.com

Is a GUID unique 100% of the time?

stackoverflow.com

How do you stop interim solutions from lasting forever?

stackoverflow.com

SQL Server, nvarchar(MAX) or ntext, image or varbinary?

stackoverflow.com

How can I print a binary value as hex in TSQL?

stackoverflow.com

Best way to see what files are Locked in Subversion

stackoverflow.com

Is this a good way to model address information in a relational database?

stackoverflow.com

Query times out from web app but runs fine from management studio

stackoverflow.com

SQL Server Fast Forward Cursors

stackoverflow.com