training and education for professional developers

Tagged with: SQL Server

5 records found

date active views answers votes

Appropriate datatype for Latitude and Longitude in SQL Server

I need to store Latitude and Longitude data in SQL Server. The data comes from Google in the following format: xxx.xxxxxx. I was thinking of using DECIMAL(9,6). Is this accurate enough for ...

Jul 14, 2011 by Craig Johnston 128 Community Rank

96.4 Last: Aug 26, 2011 by Tarriq Ferrose Khan 80 Community Rank

95.9

SQL Server Latitude Longitude GeoLocation

Views	841
Answers	1
Votes	0

Answer
Code
Follow	0

Question about C# and SQL Server certification

I have a question for the community: I am primarily working with C# and MS SQL Server and would like to know which professional certifications are going to be the most valuable to me. Thanks. ...

Sep 16, 2010 by Anuj Aggarwal 50 Community Rank

50

C# SQL Server Certification

Views	609
Answers	0
Votes	0

Answer
Code
Follow	0

Attaching SQL Server in Design Pattern Framework

I attached both the ASPNETDB.mdf and Action.mdf to my local SQLServer instance and modified the Web.config for Host.WCF.ActionServer and App.Config for DataObjects\App.Config but I get this error when I click ...

Aug 05, 2010 by Sunit Joshi 50 Community Rank

50 Last: Aug 05, 2010 by Dan McMillan 610 Community Rank

99.9

Design Pattern Framework SQL Server

Views	1.3K
Answers	1
Votes	0

Answer
Code
Follow	0

Sql Server Timeout expired

Greetings, How I can change the Sql Server timeout to keep me out the following error System.Data.SqlClient.SqlException was unhandled by user code Class=11 ErrorCode=-2146232060

Apr 28, 2010 by Rafael Huapaya 50 Community Rank

50 Last: Apr 28, 2010 by Redha Reghioua 330 Community Rank

99.8

SQL Server TimeOut

Views	1.3K
Answers	1
Votes	0

Answer
Code
Follow	0

Dynamic LINQ solution?

In our app we have a situation where the users can select from numerous criteria and get back a subset of a large number of documents. Also, supported are pagination and sort order. Criteria may incl

Feb 24, 2010 by Craig Johnston 128 Community Rank

96.4 Last: Feb 26, 2010 by Aaron Burton 254 Community Rank

99.4

LINQ to SQL LINQ to Entities SQL Server

Views	2.3K
Answers	1
Votes	2

Answer
Code
Follow	0

15
30
50
Per Page