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

learn more… | top users | synonyms

-1
votes
1answer
30 views

How to Retrieve data within nested select statement?

My requirement is, there are two tables one is Stock table another one is packaging table. The normalization is 1:M that means 1 stock id can pack into many packages. In the packaging table there are ...
2
votes
1answer
22 views

Understanding & Resolving Deadlock in SQL server 2008R2

I am trying hard to figure out what may be going wrong for below shown deadlock graph: I am receiving alerts for deadlocks similar to above for almost every 10 minutes , its just the query changes, ...
1
vote
2answers
17 views

Troubleshooting high disk read - buffer cache query

I have a table tbl_Table1 that is about 5 GB in size and has millions of rows. It has these columns: ID, ContractID, Person, Address1, Address2, and many more. One clustered index on the PK, ID. I ...
1
vote
1answer
215 views

Slow SQL Server authentication, but fast SAN, fast querying?

I am asking you after days of research but I think I don't have required skills to understand what is happening. I have a slow authentication on a SQL Server 2008R2, which leads to a timeout for the ...
4
votes
3answers
3k views

Linked servers login failure: Impersonate works, Username/password fails

I'm trying to set up a linked server between 2 instances of Sql Server 2008 R2. The login works perfectly when I select the impersonate option. However when I try to use the remote user/password ...
1
vote
0answers
20 views

sp_send_dbmail causes session to hang

We had an issue in production (2008R2 SP3) yesterday, where a developer was running a piece of code in SSMS that was executing sp_send_dbmail inside a transaction, and including an attachment from a ...
0
votes
1answer
13 views

Difference between “Table-Incremental” and “Table-Update” for “Population Type” when scheduling Full Text Index Population

I want to schedule a Full Text Index's population to keep it more up to date rather than leaving it to Automatic and not knowing the next population time as the users are complaining about the data ...
-2
votes
0answers
24 views

TCP Provider: The semaphore timeout period has expired [on hold]

In Sql Server2008 R2 and Windows Server 2008R2, when I start Replication I have this error: TCP Provider: The semaphore timeout period has expired Please help me to solve it... Thanks!
2
votes
1answer
25 views

Trigger Logic (from SQL 6.5 )

I have a database that was originally implemented in SQL 6.5 and has been migrated to SQL2000, SQL2005 and now SQL2008R2 (Compatibility Mode = 10). Through the migration many new tables, functions, ...
0
votes
1answer
113 views

how to select top ID from join operation and staging tables

I have this inner join from staging and operations table jobsCode I want to select the top surrogate key ID and get the Start_Date from this join my problem is my Query rerunning 2 records original ...
4
votes
1answer
66 views

Prevent Inserts without Column List

We have a database running on SQL 2008 R2, in 2000 Compatibility mode. Is there a way to configure the database so that implicit insert statements (i.e. those without a column list) are invalid? I ...
5
votes
1answer
2k 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 ...
0
votes
4answers
402 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 ...
1
vote
1answer
508 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 ...
0
votes
3answers
1k views

Merge Replication identity field issues

One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
0
votes
0answers
36 views

sys.sp_reset_connection. Why theres a lot of them ?

Theres a lot of questions here on DBA EXCHANGE. But none of them can help me. I have 2 problems: 1) Using sp_whoisactive, I found lots of sys.sp_reset_connection;1( I know they are ...
5
votes
1answer
3k views

How do I transfer logins from 2008R2 to 2014 with passwords?

I've tried Tasks>Generate Scripts... and set 'Script Logins' in the Advanced Scripting Options, but I get this in the output: /* For security reasons the login is created disabled and with a random ...
1
vote
0answers
37 views

SQL Server 2008R2 to SQL Server 2012 Install

I'm trying to upgrade one of my SQL servers from 2008R2 to 2012 and I'm getting an error popup within a couple of seconds from starting the setup The Error is TITLE: SQL Server Setup failure. ...
1
vote
0answers
26 views

Compatibility Level

I have a Database from SQL Server 2008 R2 which I recently updated to SQL Server 2012, since I migrated the SQL Database from 2008R2 to 2012, our application connected to it became slower. What I'm ...
1
vote
0answers
28 views

SQL 2008 R2 Agent stopping sp_who2 running and can't view database or Agent properties

We're experiencing an unusual issue with SQL 2008 R2 SP2 (10.50.4297) where the SQL Agent had stopped but would not restart (this has been fine for months). After investigating the issue we had to ...
3
votes
1answer
115 views

Transaction log backup file larger than expected?

I've recently taken over a SQL Server database that didn't have any transaction log backup routine running for at least 2 years. The first log backup was very large (3.8 gb on a 1.14 gb database) as ...
3
votes
1answer
224 views

Exporting SSRS report to Excel

We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (.xls), however when the report is saved as ...
-2
votes
0answers
32 views

sharepoint DBA. [closed]

What exactly makes a 'Sharepoint DBA' different from a normal SQL DBA. What are the differences in competency and responsibility? What are the differences is daily database support?
0
votes
1answer
123 views

Rerunning query in the same connection takes significantly longer

I am having a weird issue when a running a query that joins some semi-large tables (one table is about 2 million rows and the other about 21 million) together. What happens is the query does not run ...
10
votes
2answers
436 views

Help with PIVOT query

I have a table with below structure : CREATE TABLE [dbo].[AUDIT_SCHEMA_VERSION]( [SCHEMA_VER_MAJOR] [int] NOT NULL, [SCHEMA_VER_MINOR] [int] NOT NULL, [SCHEMA_VER_SUB] [int] NOT NULL, ...
1
vote
1answer
112 views

Selecting rows from same name table from multiple databases in single result set

For some reason, I have a table Table_1 in n databases (same name and schema structure) instead of one single databases. The columns are like this: | Column_1 | Column_2 | I can select data from ...
2
votes
4answers
1k 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 ...
5
votes
1answer
135 views

Sudden poor SELECT performance on a large table with existing indexes

My company uses a software suite in which the only thing I can truly modify is the database. We've always had performance issues (mostly hardware problems that we hope to resolve soon), but lately ...
1
vote
0answers
28 views

Database Engine Services status failed

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 ...
0
votes
1answer
308 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 ...
5
votes
1answer
41 views

Moving TDE database to a new database but having problems with the cert

This is my first time working with TDE so hopefully I haven't done anything horribly wrong. I'm trying to move my TDE database from one server to another. I have created a master key on the master ...
1
vote
1answer
1k views

Error creating scalar function “Invalid Object Name dbo.fnMyFunctionName'”

I am using SQL Server 2008 R2. I tried creating a new scalar function. The function gets created and I see it in the list of scalar functions. When I try to modify function, function name is ...
5
votes
0answers
63 views

SQL Server - Best practices on debugging extremely complex stored procedures [closed]

I recently inherited a MESS of a search. It's around 10,000 lines of code in the procs/functions alone. This search is aptly named the "Standard Search." It's a proc that calls about 6 other procs, ...
0
votes
0answers
113 views

Report Server Subscription Configuration ISSUE

I Have Created A Subscription in our Development Server With below Steps. 1)Opened Report Configuration Manager and Configure Email Settings. 2) Opened Report Manager and configured a Report Data ...
0
votes
2answers
153 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 ...
2
votes
1answer
25 views

SELECTs in Database Change Log and Source Control

We are overhauling the way that we store our database in source control and keep a change log of it. I was reading the following article: http://thedailywtf.com/articles/Database-Changes-Done-Right, ...
3
votes
4answers
32k views

List all permissions for a given role?

I've searched around all over and haven't found a conclusive answer to this question. I need a script that can give ALL permissions for an associated role. Any thoughts, or is it even possible? ...
0
votes
0answers
22 views

SQL Server 2008 R2 Error Msg 15063 and Msg 15410

I just execute a Schema Script from my SQL Server 2012 Database to SQL Server 2008 R2. I'm using same SQLAdmin account for this two Server. But when I execute the Schema Script I receive an error ...
0
votes
0answers
32 views

The module <''> depends on the missing object <''>

I'm executing a Schema Script from a new server, and I get an error saying The module <''> depends on the missing object <''>. My question is, does it affect my database? or what is the effect ...
0
votes
1answer
27 views

Best way to remap database login to new database user and keep previous database user

Here's what my environment looks like: Active Directory (mydomain.local) - Groups - group01 - Members - aduser01 SQL Instance - Logins - mydomain\group01 - ...
4
votes
1answer
1k views

Import Data replaces NULL with 0

I am using sql server 2008 r2 express. I am getting some problems when i use import data feature to import data from one database to another. I am using SSMS to do it. While using the wizard i choose ...
-1
votes
0answers
10 views

TO SSIS PAckage when it found a special characters in the column

I am trying to create SSIS package to fail when it founds a special character. otherthan SCRIPT TASK what transformation we can use? Please help me out. -Ram
2
votes
2answers
54 views

How to DENY access to EXEC for a role

I have a read-only database user that I do not want to be able to run the EXEC command. I ran the following command: DENY EXECUTE to db_USERROLE_deny Which completed successfully, however when I ...
8
votes
3answers
1k views

SQL server service won’t start after disabling TLS 1.0 and SSL 3.0

Because of security reasons, we disabled TLS 1.0 and older protocols on our windows, and enabled just TLS 1.1 and TLS 1.2 under the following registry path: ...
0
votes
2answers
132 views

SQL Server 2012 Very Slow to Consume Memory

I have a bit of a conundrum. I recently upgraded a ~20gb database from Window Server 2008 R2 || SQL Server 2008 R2 to Window Server 2012 || SQL Server 2012. The previous server had 32gb of memory, ...
1
vote
1answer
49 views

How to Get one Single statement of two table value in SQL

I wanted to retrieve two table values in one single statement such as, (Example Bank statements..) Table 1: Invoice SELECT ClientNo, InvoiceDate, InvoiceNo, TotalDue FROM Invoice_TBL WHERE ...
3
votes
0answers
24 views

SQL Server 2008 R2 Partitioning - same FileGroup, 1 File, 2 partition_numbers - HELP

It's my first go at partitioning in SQL Server, I learned from the Brent Ozar guide which is fantastic :) A few times I have ran into a weird scenario; when I run: SELECT * FROM ph.FileGroupDetail ...
-3
votes
0answers
43 views

SQL Server 2008 R2

I'm trying to run SQL Server Agent but the following error occurs The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error log for ...
1
vote
1answer
28 views

How does the table scan in an UPDATE WHERE predicated on an unindexed column work?

I was looking into a deadlock caused by two concurrent UPDATE statements: UPDATE [table] SET [column] = 0 WHERE [unindexed_column] = @id My understanding is that because the column the WHERE is ...
1
vote
1answer
14 views

Limit of Generating Script for Schema Only from SQL Server 2012 to SQL Server 2008R2

Is there a limit on this method? I've tried a 35GB Database and it works, but my question is how about if my Database is like 100-150GB? Will I encounter some error? Or it will work smoothly but a ...