This tag is for SQL Server 2008, major build version 10.00.xxxx.

learn more… | top users | synonyms (1)

5
votes
2answers
92 views

Finding the query causing the missing index DMVs

How can I find the query causing the missing index DMVs suggesting to create a particular index? Thank you.
2
votes
0answers
36 views

SQL Server transaction log reported full when it isn't [duplicate]

The transaction log for database 'WebDB' is full. No, it isn't. Its 90% free. The transaction log backups run normally. My hardware guy tells me the hardware is running perfectly, with plenty of ...
0
votes
1answer
58 views

How to get average according to last update time?

There is table - Item below, how can I get the average Value according to its 15 minute value from last record time? I am using SQL Server 2008. Table -- Item Table 15min_AVG
0
votes
0answers
17 views

Missing index recommendation for an already existing index [duplicate]

SQL Server missing index DMVs suggest to create an index which already exists. The existing one and the suggested one exactly overlap each other; they are single (same) column index with no included ...
2
votes
1answer
77 views

Help Changing Collate of ALL databases

I have approximately 80 Databases with various collations. I would like to modify the collation of all 80 databases. I have the following code: USE [COLLATE_ADM] GO SET ANSI_NULLS ON GO SET ...
1
vote
1answer
33 views

Clear missing index DMVs

How can I clear missing index DMVs such as dm_db_missing_index_group_stats, dm_db_missing_index_groups and dm_db_missing_index_details? I don't have an option to restart the server or taking it ...
2
votes
1answer
72 views

Listing expired SQL logins

For audit purposes, we need to list all SQL logins with their creation and expiration dates. Is there a way to script this for all of my SQL Servers, rather than performing the task manually through ...
2
votes
1answer
254 views

How to remove identity specification for multiple tables

I am having total 109 table in Database and now i am migrating to Amazon server with identity insert and now i want to remove auto increment column specification for all tables. How set auto increment ...
0
votes
1answer
46 views

Cannot connect from computer to server database

I'm trying to connect from my computer to a server which has a SQL Server 2008 instance installed. My computer and the server are in the same domain and the name of the server is "SERVER". The ...
1
vote
0answers
46 views

Why database replication fails when database mirroring is broken?

I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008. Here is current environment: (don't ask me why it was done this way or to change it) Server A: SQL ...
4
votes
0answers
164 views

What is the cause of this problem with CONVERT()?

Consider the following two statements: PRINT CONVERT(NUMERIC(38, 0), 0x0100000001, 0); PRINT CONVERT(NUMERIC(38, 0), 0x0100010001, 0); Both statements return -1; isn't that incorrect since the ...
1
vote
1answer
80 views

Best way to document Dwh views [closed]

I works in a company that provide Dwh views as an API for external Customers (We use MS-SQL 2008 & 2012). every once in a while we release new views and updates the existing views. We have ...
5
votes
2answers
140 views

Keeping iterator in consistent state

I was reading this post to understand how things are done in Sql Server: http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/ If I understand it correctly, data is being sent ...
0
votes
0answers
68 views

Upgrade from 2008 RTM to 2008 R2 RTM failed due to perf-ReportServer-rsctr.dll is being used by another process

I was upgrading SQL Server 2008 RTM on Windows Server 2008 R2 SP1 to SQL Server 2008 R2 RTM. I got this error: The process cannot access the file ...
0
votes
2answers
105 views

How can i know the relationship in the database in sql server 2008? [closed]

I want to know how can I determine relationships between data which is not determined by the primary key in the design. For example, I have three tables in the database like this :- table 1: fields ...
0
votes
1answer
138 views

Run CDC Cleanup job at specified time

I have enabled cdc and using it , it works fine now the problem is that we have many tables in a database and also we have many databases so how to configure cdc cleanup job to run again and again ...
7
votes
2answers
403 views

Simple DELETE, but complicated execution plan

When I run this delete: DELETE FROM ETLHeaders WHERE ETLHeaderID < 32465870 ...it deletes 39,157 rows. It should be simple because it is deleting on ETLHeaderID which is the clustered index and ...
-5
votes
2answers
467 views

Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2 [closed]

MS on this link http://msdn.microsoft.com/en-us/library/ms182776.aspx mentioned that we should use rowversion data type over Timestamps. Now inside my sql server 2008 R2 I want to create a column with ...
0
votes
0answers
23 views

Cannot add “rowversion” data type in sql server 2008 r2 management studio, or even to modify existing column data type [duplicate]

I want to create a column with Rowversion data type, but inside my SQL Server 2008 R2 Management Studio, I cannot find such a data type: Also when I tried altering existing column named timestamp ...
2
votes
0answers
36 views

Can I convert SQL Server 2008 full db to SQL Server 2005?

Recently I converted my SQL Server 2005 database to SQL Server 2008. Now I can't attach that db to SQL Server 2005. I do not have any backup of that db file as well. I have tried to generate scripts ...
1
vote
3answers
229 views

SQL Query in suspended state causing high CPU usage

Environment detail: SQL Server 2008 R2. I have applications running on JBoss that access the DB using JDBC driver. Issue: My online DB server was experiencing high CPU usage. Using the following ...
0
votes
0answers
43 views

SQL Transaction Logs Overwrite

Server Detail: SQL Server 2008 R2 Production Set Up: In a production environment, I have a DBMR job scheduled to take transaction log backups for all the databases present in a DB server. This job ...
4
votes
1answer
49 views

How do I determine the spid of the session that is making a query on a linked server?

I have a session running on a SQL Server instance that is blocking other sessions (holding on to a lock without releasing it). Querying sys.sysprocesses yielded the hostname of a different SQL Server ...
1
vote
1answer
175 views

Standard data types for email address, telephone number , first name, rixh text editor, etc

I want to build a database for our system using Sql Server 2008 R2. but i need to know what are the best data types for storing these info:- Email address Telephone number with extension, such as ...
-1
votes
1answer
213 views

How to know which columns value is different between two rows

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress Code Address 1 1 123 Main 1 2 123 Main 2 1 ...
2
votes
1answer
130 views

Identify unattached File Size in SQL Server

From a similar post on this forum, I have modified the below code as per comments and able to get the orphaned files in the drives. The code is : EXEC sp_configure 'show advanced options', 1; ...
0
votes
0answers
89 views

LCK_M_SCH_M Blocking

I have 2 stored procedures (one vendor, one third party) that are constantly (monthly) stepping on each other. They both (for some reason) acquire a schema lock when all they are doing is updating ...
0
votes
0answers
26 views

Unable to patch,uninstall or repair Reporting Sevices

I appear to have a corrupt installation of Reporting Sevices (2008) that I cannot repair or uninstall. Trying to repair this feature I get an error Message that says "The SQL Server feature ...
0
votes
0answers
40 views

SQL Server 2014 upgrade

I currently have websites running on SQL Server 2008 R2 - this is the version I also have installed on my own machine. I'm looking at moving my websites to a different provider, however they only run ...
0
votes
1answer
72 views

Select Query takes more than a minute to retrieve data

I have a table that has 99 columns, all of them are not needed but they were there when we started. There is a Primary Key (Objectuid) which is a GUI and has the Clustered Index on the PK. The Table ...
0
votes
1answer
120 views

Stop agent job after executing for a certain number of hours

I have a scheduled job which runs nightly. I want it to stop itself at 07:00AM in the morning whether or not it is completed. I have seen some duplicates in the site but they don't exactly address the ...
1
vote
1answer
343 views

Installation failed in installing SQL Server 2008 SP3 on windows 8.1

Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL ...
1
vote
2answers
36 views

Upgrade BI server to 2014 and stay on 2008r2 with the database engine server

We would be happy to upgrade our SQL Server environments to 2014, but we have a tight budget for next year. Our BI server (SQL Server 2008 Standard Edition, that is used only for BI purposes) is ...
0
votes
2answers
58 views

Log Sequence Numbers in Full BackUp and Log Backup

My full back-up starts daily at 02:00 AM. It takes about 3 hours. I also take T-Log back-ups every 15 minutes (at 15,30,45 and 00 hours). I can verify the LSN sequences of T-log backups when I ...
1
vote
2answers
76 views

Convert date and time

I have a column with about 100 records in datetime (for example 2004-08-09 12:20:41:000) and I would like to convert all records or update same time just date only with format mm-dd-yyyy. Thank you. ...
1
vote
1answer
42 views

SQL Server configuring both UCP and MDW on a single server

I'm trying to configure both UCP and MDW on a sql server. I have already setup UCP and it created [sysutility_mdw] database. Now when i try to setup MDW it is trying to use sysutility_mdw database ...
2
votes
1answer
567 views

How to allow to execute stored procedures but not writes?

I would like to set up a "reading" user on my SQL Server 2012 instance. I would like to allow him the right to execute any stored procedure, or function, or direct SQL statement, which retrieves data ...
0
votes
0answers
93 views

How to merge exported SQL Data into restored DB updating only changed rows?

We've just moved two databases from Microsoft SQL Server 2008 instance to another using BACKUP DATABASE on the original system and then RESTORE DATABASE on the new one. Everything went fine but then I ...
0
votes
1answer
158 views

OS Paging too high in sql server

For one of my servers with below configuration: Total RAM: 32 GB CPU: 8 Max Server Mem: 22.5 GB Min Server:: 4 GB Edition: Enterprise Edition with 2k8R2 installed on SP3 ...
0
votes
2answers
81 views

Setting for default column type

Is there a setting in SQLServer 2008 and newer for default data type of date-time columns, i.e. datetime or datetime2? Actually more like something that would tell SQLServer to use datetime2 instead ...
2
votes
3answers
1k views

Cascade primary key update to all referencing foreign keys

Is it possible to update a primary key column value with cascading the update among all the foreign keys referencing it ? # EDIT 1: When I run followinq query select * from sys.foreign_keys where ...
0
votes
1answer
35 views

Unable to install

Unable to install SQL Server 2008 in windows 8.1 64 bits it asks for .Net Framework 2.0 but I have already installed .Net Framework 4.5 with the OS.
-2
votes
1answer
150 views

i have make a database program in visual basic 2010.how i can set the 2 programs to see each other on 2 pc? [closed]

i have make a database program in visual basic 2010.now the programm works fine but i want to install that program in another computer but how i can see the database from the other computer? for ...
2
votes
3answers
308 views

Is it possible to have 2 backup plans for a single database?

Is it possible to have two backup plans ? allow sysadmins to have their own SQL Server 2008 set of backups for a database allow DBAs to have their own separate backup plan We have had issues with ...
0
votes
1answer
42 views

How to Select all child elements of a given Node in SqlHierarchyId?

I have a Node as /1/2/, Here I want to select all child Nodes of '/1/2/' Ex /1/2/1/ , /1/2/2/1/.../
0
votes
0answers
25 views

Count responses based on tale structure given below

Table:Answer_Master id_answer answer id_question 1 Yes 1 2 No 1 3 Yes ...
0
votes
2answers
31 views

Report individual changes to data

I need to produce a daily extract on the individual changes to a dataset. So, there are 14 tables containing product and customer information and the extract must only show records from each table ...
0
votes
1answer
27 views

I couldn't see Conflict tables in replication monitor SQL Server 2008 R2 in Merge Replication

I work with merge replication in SQL Server 2008 R2. In the replication monitor I can't see conflict table, I must to see conflict tables in "MSmerge_conflicts_info", please help me. How to see ...
0
votes
0answers
112 views

Import and export Excel data into a SQL server database

I have SQL Server 2008 64 bit Developer’s Edition installed on my machine, and Microsoft Office 2013 Professional 64bit. I have been trying to import and export some Excel data from an Excel sheet ...
2
votes
1answer
222 views

What means Command column in sp_who2 and text column in sys.dm_exec_sql_text?

I have a script that shows commands being fired in SQL Server 2008 database as follows: --shows who is active and executed commands declare @SPID int=null, @Status varchar(max) = null, @LOGIN ...