This Tag is for SQL Server 2008 R2, major build version 10.50.xxxx

learn more… | top users | synonyms (2)

0
votes
1answer
337 views

The SQL Server Network Interface library could not deregister the Service Principal Name

After windows patching (windows 2008 R2 , SQL Server 2012 Sp2). I could not start SQL Server Service . I get error 1067 and this from the error log* The SQL Server Network Interface library could not ...
1
vote
1answer
22 views

Migrating from PostgreSQL to SQL Server

I have been tasked to migrate a database from PostgreSQL 9 to SQL Server 2008 R2, and I have found some issues I need to address. I have quite limited experiences with PostgreSQL I'm afraid. Most ...
0
votes
0answers
12 views

SQL Express SA user has disabled [duplicate]

Hi we have an issue where our SQL Express has randomly disabled the SA account can I am able to connect to SQL as the local admin but it does not have sufficient access to re enable the SA account. ...
-1
votes
1answer
33 views

Upgrade Database from SQL Server 2008 to SQL Server 2008 R2 [on hold]

I've upgrade my database from SQL Server 2008 to 2008 R2 (v10.50.1600.1) on a remote server. Version of my local SQL Server is 10.50.1600.1. When attempting to restore database from remote server to ...
4
votes
1answer
55 views

Page Life Expectancy Wildly Fluctuating

For months now, the PLE on one of our servers has hovered around the 2 million seconds. If varied slightly from day to day but was pretty stable there. This last weekend, we added 12 GB of virtual ...
4
votes
0answers
43 views

How can we improve this PIVOT operation? ( SQL Server 2008 R2 )

We have this query, that runs in 1:10. We need to improve this. This is just a test query, but we will implement this upgrade on our real query. select top 100 * from ( select codCliente ...
2
votes
3answers
100 views

How can I reduce the Initial Size of a LOG file?

I've inherited a SQL Server 2008r2 database; the Data file was created with an initial size of 1,000 mb, but the Transaction Log has an initial size of 28,016 mb. No backups were being performed. ...
1
vote
2answers
514 views

Error when restoring SQL Server 2008 R2 backup on 2012

I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the ...
6
votes
3answers
184 views

Find data size of table for several identical databases on a instance

I have several identical databases with the same schema/table structure within a instance. I need to find the size of one table that they all have. For example, I have 30 databases on a instance and ...
0
votes
2answers
971 views

SQL Server Configuration Manager returns remote procedure call failed

I open the SQL Server Configuration Manager and it returns remote procedure call failed. This is Windows 7 Ultimate version, SQL Server 2008 R2 Express version with advanced services. Previously I ...
1
vote
1answer
104 views

Print, transaction and cursor performance in Transact-sql

I'm having some performance issues when I run a script. I was reading about the problem with print and its performance, but I cannot figure out how to reduce the impact. The algorithm is O(n^2). The ...
0
votes
1answer
64 views

Is there a way to run this query in all databases ? ( SQL Server 2008 R2 )

How can I use this query for each database? I can easily use sp_msforeachdb but it breaks the results for every database. So I tried to insert the results in a temp table, but it's giving me syntax ...
0
votes
0answers
28 views

Fullbackup + Differential/Copy-only

We have a PROD full backups copied over to support envs daily and we restore to support environments to triage some issues, as the DB is growing big we would want to run the full backup copy only on ...
0
votes
2answers
2k views

How to set the timeoffset in a Datetimeoffset column without changing the date part

Is there any way to set the timeoffset of a datetimeoffset column directly without having to use SWITCHOFFSET which changes the date as well? In the post below, we can see the SWITCHOFFSET will ...
4
votes
1answer
16 views

Problem when add administrator for Analysis Server ( SQL 2008 R2 )

I'm trying to add a user as an administrator in Analysis Server, doing this: 1 - Connect - Analysis Server - Right click on the Instance - Properties - Security - ADD : This number was already ...
3
votes
0answers
46 views

Permissions on a database object when it does not have any permissions associated to it

I want to find out the permissions of a specific object in the database. I have found many scripts on the internet, and developed my own too. Something like this: select dp.NAME AS principal_name ...
2
votes
1answer
12k views

How to find which tables and views a user has access to?

We have a SQL Server 2008 database and have restricted all tables and views away from a specific user ID. Over the years we have granted back tables and views one at a time based on user need. We ...
3
votes
1answer
48 views

How to wait for SQL Server replication reinitialization via TSQL

We use transaction and push replication. Every night after the data import 2 replication targets are initialized with the following commands. USE [dbImport] -- Execute at the Publisher to ...
0
votes
1answer
20 views

Restore / Create a database with a data file (MDF) from backup the same but with two data files (MDF and NDF)

I must restore/create a db (in a new instance) in one file(mdf) from a backup of the same but with two files of data (mdf and ndf) How can I do it? This is what I try... but it did not work ...
2
votes
1answer
32 views

How to create test environment for lost transactions

I have a problem that I hope you can help me to solve. I'm using SQL Server 2008 R2. I need to create a test environment in which I'll be able to artificially 'create' lost transactions. Due to ...
2
votes
2answers
179 views

Replication error after server name change

I have changed the computer name of the server where SQL Server 2008 R2 is installed. Old name was WIN-OUJEKRMGXXX New server name is KASURDYYY When I try to configure replication, the following ...
1
vote
1answer
15 views

dtsinstall.exe does not deploy packages

I created SSIS project solution in VS2008. I created 5 packages and deployed them to SSIS Storage succesfully. I executed 4 packages successfully. I leave SQL server few days alone (holiday!). I ...
2
votes
1answer
60 views

Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?

I have SQL Server 2008 R2 (named instance) on a Windows Server 2012 R2: Enabled remote access to SQL Server Enabled shared memory & TCP/IP protocols & named pipes for the SQL Server ...
-2
votes
0answers
19 views

Upgrade from SQL Server Express Edition to SQL Server 2008 R2 [on hold]

Can I upgrade from SQL Server Express to SQL Server 2008 R2? If there is away can you please provide the steps for me.
1
vote
1answer
46 views

Aggregation by positive and negative values

I have a table called "PROD_COST" with 5 columns: +----+----------+------+-----------+-------------+ | ID | Duration | Cost | COST_NEXT | COST_CHANGE | ...
6
votes
1answer
505 views

Time as a measure

Is it possible to have times as measures in a cube? We're trying to view employee start times by day, aggregating as an average over time. Even with a No Aggregation measure type I'm getting an error ...
0
votes
1answer
394 views

Configuring Reporting Services - ExecutionLogDaysKept

Is it possible to set Reporting Services options when Reporting Services is not installed on a server? Is this how a SQL Server instance used by SharePoint works? I'm a new DBA (very junior...), and ...
1
vote
2answers
57 views

Defragmenting Indexes Bloats Log Files

I'm having difficulty "defragging" indexes as a minimally logged operation. Before defragmentation, the database recovery model is switched from FULL to BULK LOGGED. Depending on the fragmentation ...
3
votes
1answer
194 views

Gigantic gaps in IDENTITY column

This question is about strange behavior in SQL Server 2008 R2 SP3 Standard Edition x64. I have read many questions about IDENTITY increments in SQL Server and strange gaps between them. But basically ...
0
votes
1answer
40 views

Error converting data type nvarchar to float. Oracle Linked Server

Upon executing the following query select value, cast(value as float) float_value from OPENQUERY([ORACLESERVER], 'select 3/5 as value from table') I am getting the following error: Msg 8114, ...
1
vote
1answer
410 views

SQL Server 2008 R2, error creating file for FileStream

I'm trying to create a file to add to a filestream file group and I get the error: Msg 5120, Level 16, State 106, Line 1 Unable to open the physical file "d:\data\filestreamstore.mdf". Operating ...
1
vote
0answers
31 views

SQL server on VMWare restart loses five days of data

I am just now in the midst of a strange issue. A client moved their SQL database server from Hyper-V to VMWare on Saturday. Yesterday they called me complaining about performance. In the brief time ...
5
votes
1answer
183 views

Log shipping with a monthly archival process

We will be implementing log shipping in our production environment in the next weeks. We perform a monthly "cleanup" of the database, whereby we set the database to the SIMPLE recovery model, copy ...
3
votes
1answer
279 views

Login failure error log when querying Central Management Server group

I am querying a group under a Central Management Server, which results in the following being logged to the SQL Server Error Log. Error: 18456, Severity: 14, State: 38. Login failed for user ...
6
votes
3answers
4k views

SQL Server not starting at Windows startup but starts manually

My SQL Server instance's (SQL Server 2008 R2 Express) service has Startup Type = Automatic. The past couple of times I've restarted my computer the service has failed to start on its own, but it ...
1
vote
1answer
621 views

SQL Server connection failed for domain user from Mac OS machine

I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server. In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
1
vote
1answer
41 views

Query to remove duplicate calculated values

I have a client running SQL Server 2008 R2 SP1, and I can't seem to write a query that has distinct calculated values. I could change the schema to store the value being calculated, but I was curious ...
8
votes
3answers
160 views

zero-or-one to zero-or-one

How do I model zero-or-one to zero-or-one relationship in Sql Server the most natural way? There is a 'Hazard' table that lists hazards on a site. There is a 'Task' table for work that needs to be ...
2
votes
2answers
384 views

Maintaining SQL Server 2008 R2 on Windows 10

I have to run SQL Server 2008 R2 on Windows 10 but it is not supported and so I am not getting any updates. Installing a later version of SQL Server is not an option. I can find all the service packs ...
2
votes
1answer
92 views

how to get the information about sleeping processes that are causing blocking?

I have a procedure that allows me to see what is currently running in my sql server. This procedure does not use sys.sysprocess because it has been deprecated. However, I am struggling to find ...
7
votes
1answer
93 views

Clustered Index Help, where did i go wrong?

I was asked to review a very busy table and identify any areas of improvement. I have very limited power to change the table just the indexes. Table information 240 columns ~5 million rows Read ...
2
votes
4answers
2k views

SQL Server Page Life Expectancy sharp drop

I'm trying to put my hands on the reason this SQL Server slows down sporadically. There are no patterns detected so far. It's a SQL Server 2008 R2 running on a Windows Server 2008R2 VM on top of ...
6
votes
2answers
488 views

What does Page Life Expectancy say about the instance?

I have installed monitoring software on a few SQL Server instances in the environment. I am trying to find bottlenecks and fix some performance issues. I want to find out if some servers need more ...
7
votes
0answers
271 views

How to properly troubleshoot Merge Replication False Conflicts

We have SQL Server 2008 R2 Merge Replication setup. Lately I started getting conflicts for some tables, and when I check the conflict viewer, I can see that the winner & the loser column values ...
1
vote
3answers
39 views

Show data and disk use breakdown by table

I have a SQL Server 2008 R2 database being used by several deployed programs. Question: Is there an easy way to display how much space each table consumes, for all of the tables in the database, and ...
1
vote
4answers
494 views

Reading CSV files located on LINUX server and updating the tables in SQL Server Database

I was wondering how do we ingest CSV files located on a Red Hat LINUX server into SQL Server Database Table. I know we can write a Stored Procedure/Bulk Insert to read the files that are located on ...
2
votes
0answers
67 views

SQL Server 2008 R2 - Two Files Stuck In Restoring Status

Background: SQL Server 2008 R2 mirrored and clustered. We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
0
votes
1answer
115 views

SSIS unpivot returns different results when run via a SQL agent job

I hope someone can help me. I have an SSIS package which grabs data from an excel (.xls) file, unpivots it from a rubbish format into a 'proper' format, transfers it to a SQL server 2008 R2 db, and ...
0
votes
0answers
12 views

SQL Server 2008 R2 FREETEXTTABLE with FORMSOF(inflectional, string)

Can anyone confirm that using FORMSOF(inflectional, ...) is redundant when querying FREETEXTTABLE in SQL Server 2008 R2? Using FreeTextTable without formsof... gives me the same result list but with ...
-4
votes
0answers
16 views

what is the difference between Data Migration and Data Archiving [migrated]

what the difference between Data Migration and Data Archiving.o we have a sharepoint application for document archiving and its database size is nearly 1 TB.So i have plan to reduce the size of ...