Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008r2-express]

Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.

223 questions
0
votes
1 answer

A good summary/explanation of Sql Server Express 2008 versions available for download?

Can someone tell me whether this link that I used to install Sql Server Express 2008 is version R2 or not? I installed from here: http://www.microsoft.com/download/en/details.aspx?id=22973 The reason that I ask is that I am trying to setup an…
BruceHill
  • 6,954
  • 8
  • 62
  • 114
0
votes
2 answers

Efficient Database Table Structure

Consider Microsoft SQL Server 2008 I need to create a table which can be created two different ways as follows. Structure Columnwise StudentId number, Name Varchar, Age number, Subject varchar eg.(1,'Dharmesh',23,'Science') …
Dharmesh
  • 943
  • 4
  • 15
  • 26
0
votes
1 answer

Send a user's text input to a database to update

Pretty new here. But before I ask my question, I'm not looking for "teh codez". I just want to know how one would go about doing this. I have some regular HTML textboxes in a web page, and I want to know how I would go about taking that input…
Johnny Doe
  • 193
  • 2
  • 3
  • 16
0
votes
3 answers

Max number of tables (objects) in SQL Server editions (compact, express)

What are the maximum number of tables that you can have in: SQL CE4 SQL 2008 R2 Express Numbers here http://msdn.microsoft.com/en-us/library/ms143432.aspx I guess is for SQL Server 2008, but are they valid for Express and what about SQL CE4? The…
Daniel
  • 8,133
  • 5
  • 36
  • 51
0
votes
2 answers

SQL Server 2008 R2 Express DataReader performance

I have a database that contains 250,000 records. I am using a DataReader to loop the records and export to a file. Just looping the records with a DataReader and no WHERE conditions is taking approx 22 minutes. I am only selecting two columns (the…
econner
  • 707
  • 2
  • 8
  • 14
0
votes
1 answer

Can I use the Report Builder with SQL Server 2008 R2 Express?

I am using SQL Server 2008 R2 Express for the development environment whereas I have SQL Server Enterprise Edition on the server. I want now to generate reports using Report Builder with SQL Server Express then deploy it to the server. So can I use…
user1093651
  • 1,991
  • 3
  • 20
  • 30
0
votes
1 answer

Migration from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developers Edition

I've done some reading on the installation but it's not clear to me whether I will be UPGRADED to the SQL Server Developers edition or whether the install will create another instance. I want to get rid of SQL Server Express. Will the install give…
Susan
  • 1,822
  • 8
  • 47
  • 69
0
votes
2 answers

Delete Takes a Long Time

I've got a table which has about 5.5 million records. I need to delete some records from it based on date. My query looks like this: DELETE FROM Table WHERE [Date] between '2011-10-31 04:30:23' and '2011-11-01 04:30:42' It's about 9000 rows, but…
viki
  • 27
  • 6
0
votes
2 answers

How can I write T-SQL to bring data for tooltips back with original dataset?

I am writing a SP in T-SQL to bring back 'first pass yield' metrics from test data stored in database tables on SQL Server 2008 R2. I have the SP written to return the basic data for graphing in the application, but I would like to add tooltips to…
DaveN59
  • 3,638
  • 8
  • 39
  • 51
0
votes
1 answer

I cannot install SQL Server 2008 R2 express X64 management tools

I am trying to install the SQL Server 2008 R2 express X64 but it doesnot install the MANAGEMENT TOOLS because it finds the VS 2008 and it wants the SP1. I have not install any VS edition. How can I overcome this problem? I have windows 7…
ekekakos
  • 53
  • 1
  • 7
0
votes
1 answer

Office network SQLEXPRESS - Connecting Winform issue

I've created a Winform that connects to SQL Server Express x64 using Trusted Connection string. On the development machine (Which SQL Server is running on as well) the Winform works 100%, the resulting connection string is: Persist Security…
John Cogan
  • 51
  • 1
  • 8
0
votes
1 answer

Configuring SQL Server Security for .NET Applications Without Profiler

How can I do this: http://support.microsoft.com/kb/815154 with SQL Server 2008 R2 Express because it seems to only apply to the higher versions of SQL. I know there are third-party profilers, but is there a way to do it without a profiler, and if I…
Daniel Lopez
  • 1,728
  • 3
  • 24
  • 40
0
votes
5 answers

How to boost performance of Microsoft SQL Server 2008 R2 Express edition

I use the above server at home and the real/full edition at work. I have the same database at home and office (small one). My home computer is i7/4GB/single 2.5" SATA2 HD. My office computer is i3/8GB/1GB Single 3.5" SATA2 HD. The office server runs…
elarrow
  • 687
  • 3
  • 11
  • 19
0
votes
2 answers

Trying SQL table update matching on string field

Could really use some help with an update query...(SQL Serer 2008 R2 Express) I have two tables, tblJP and tblMaster. I only have a string field that matches between the two tables. tblJP AND tblMaster I need to update tblJP.LangString with…
htm11h
  • 1,739
  • 8
  • 47
  • 104
0
votes
0 answers

Connecting a SQL Server Express 2008 R2 database to Visual Studio 2017 without upgrading it

I am looking for a way to get a form application that I currently have designed in Visual Studio 2017 to run on Windows XP. To do this (and as far as my limited knowledge allows me to understand), the program must use the .NET Framework 4 and a SQL…
Aarón BD
  • 3
  • 2
1 2 3
…
14 15