Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
8
votes
2 answers

How to Link an SQL Server 2008 Server to an SQLite Server?

I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this? I have searched far and wide, but found no solution for this problem. The closest attempt I have found is…
user48962
  • 181
  • 1
  • 3
7
votes
2 answers

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot of research into this process but am getting stuck…
Christopher Bruce
  • 339
  • 2
  • 4
  • 14
7
votes
5 answers

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work with our configuration, but it won't. The reason is…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
7
votes
5 answers

Why is CPU use so asymmetric on our 8-cpu SQL Server box?

I've noticed that the CPU usage on our 8-CPU database server, running SQL Server 2008, is not balanced at all. Here are the 1 day averages for a random day a while back, which is typical and consistently asymmetric: 9, 15, 10, 21, 18, 21, 14,…
Jeff Atwood
  • 13,104
  • 20
  • 75
  • 92
7
votes
3 answers

MS SQL 2008 all on RAM?

Anyone with experience of using SQL 2008, but all in RAM? Trying to make certain things faster, and might pursue this, thanks
Tim
  • 229
  • 3
  • 8
7
votes
2 answers

SQL Server: dbo vs db_owner role member?

I'm assinging user to a new database. What is the difference of user being a default dbo user compared to assinging login as a db_owner role member?
nickel
  • 75
  • 1
  • 1
  • 4
7
votes
1 answer

sys.dm_exec_query_stats interaction with recompilation

We use sys.dm_exec_query_stats to track down slow queries and queries that are IO offenders. This works great, we get a lot of very insightful stats. It is clear this is not as accurate as running a profiler trace, as you have no idea when SQL…
Sam Saffron
  • 1,979
  • 3
  • 18
  • 27
7
votes
4 answers

Ghost Cleanup

my understanding of the ghost cleanup process is that every five seconds it will look to removed ghosted records in an index. and so it will not overload the system, it will only "clean" roughly ten pages at a time. so, that means it only cleans…
SQLRockstar
  • 713
  • 6
  • 10
7
votes
4 answers

Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers?

I have a Linked Server which was made using SQL Server Management Studio 2008. If the linked server destination changes, I will have to change the properties of it to direct to the right place. But I cannot - there is no edit option! Am i missing…
user48642
  • 289
  • 2
  • 4
  • 10
7
votes
3 answers

how do I configure IIS to post logs to sql server?

how do I configure IIS to post logs to sql server? How want to save ANY log to my site. the site has a lot of views and the data can be big in a very small time. In addition, I want to show analytics of the use, in real time, and for all the…
stacker
  • 841
  • 3
  • 10
  • 15
7
votes
3 answers

Can’t connect to SQL Server 2008 - looks like Shared Memory issue

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the error occurred, I had Shared Memory enabled and…
user38556
6
votes
1 answer

Does SQL server log shipping require a 2nd SQL license

Possible Duplicate: Can you help me with my software licensing question? I'm currently working on a high availability solution for SQL Server 2008. I have 2 servers with 1 license of standard edition SQL Server. Can you implement log shipping…
RyanW
  • 528
  • 3
  • 9
  • 19
6
votes
1 answer

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data transfer tools of SQL Server but I'm unsure of what…
Black Dynamite
  • 523
  • 2
  • 5
  • 16
6
votes
4 answers

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (SQLNCLI10.1). I downloaded a native client…
user49352
  • 123
  • 2
  • 4
  • 12
6
votes
1 answer

On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?

I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
CatDadCode
  • 265
  • 3
  • 10
1 2 3
…
99 100