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

learn more… | top users | synonyms

1
vote
0answers
23 views

Quorum disk conundrum

I'm working on a problem for one of my company's clients where they are having a problem with their 2-node active-active cluster and which has been failing over lately but not bringing resources back ...
4
votes
1answer
79 views

Query Plans Change Performance Worse in SQL Server 2014

We recently upgraded our server from SQL Server 2008R2 to SQL Server 2014. We have a query that ran fine in 2008R2 but now in 2014 runs incredibly much slower and has a bad execution plan. I've done ...
4
votes
1answer
80 views

SQL Server 2008 R2 Lockup for 10 minutes

Last Saturday night, our site went down for about 10 minutes. Analysis of the logs showed the following errors on the principal SQL Server (in a mirrored pair), during the outage and not outside the ...
2
votes
1answer
39 views

SQL Server tempdb rogue temporary tables

I've got some rogue temporary tables being generated which is starting to cause disk space issues. The database creating these tables is fairly large and I'm unsure what stored procedure/function etc ...
1
vote
1answer
28 views

Problem passing rows results to columns names

I have a table with following data: ID IDALUMNO ALUMNO IDTIPOEVALUACION TIPOEVALUACION NOTA 1 682 ALVITEZ MIRANDA, KAREN LIZET 1 PR1 ...
0
votes
1answer
23 views

Analysis Services not allowing other/remote connections other than localhost

Analysis services not allowing any connections except localhost. Authentication box is disabled and only allow windows authentication. How can I connect to different remote analysis servers using ...
0
votes
1answer
29 views

Login timeout expired

I am using a program that is connected to SQL Server. The program has started giving 'login timeout expired' errors. If I login to SSMS and query the database the program connects and it fails again ...
0
votes
1answer
38 views

SQL Server 2008 R2 Express Connection

I installed SQL Server 2008 R2 Express Edition. I opened the command prompt and typed sqlcmd -S server1\SQLExpress -U SqlUserAccount -P SqlPassword to connect to SQL Server. However, it ...
0
votes
0answers
40 views

How to find cause of SQL-Server Full-Text Index Auto-Population Error?

I have recently added a few full text indices to a database and AUTO populating is not working as I would have expected. Sample Table Definition CREATE TABLE [wrk].[WorkOrder] ( [id] ...
2
votes
1answer
76 views

Why do database servers have different time_source values

I have two SQL 2008 R2 Enterprise SP1 servers that have different values for sys.dm_os_sys_info.time_source. The time_source column of sys.dm_os_sys_info indicates the API that SQL Server is using to ...
6
votes
1answer
101 views

Disk I/O and PAGEIOLATCH_XX

We have been having CPU issues with one of our servers lately and while we have been looking into this we have also noticed queries running slowly with waits of PAGEIOLATCH_XX. In particular, a ...
2
votes
1answer
126 views

Arithmetic overflow error varchar to numeric

I'm getting an arithmetic overflow error and I can't seem to find out the case. I've recently had to adjust some stored procedures, to allow for dates in the future to be put in. The following part ...
1
vote
2answers
49 views

High SOS_SCHEDULER_YIELD and Signal Waits

I have run Paul Randals wait script and can see SOS_SCHEDULER_YIELD is at 60% with an average signal wait of 10ms. I have also run a script to find out the what percentage of my waits are signal ...
0
votes
1answer
18 views

database with same schema and same AWS instance type, but different performance

Hi I am getting a new set of production servers ready. I generated a DB script from SSMS using the schema from Server A to deploy to a new AWS instance of the same type as Server A. After populating ...
0
votes
1answer
37 views

How to modify the precision of a datetimeoffset column?

In a sql-server database with data I have several columns with type datetimeoffset(7). Now I would like to change the precision part of the type to datetimeoffset(0). Is this possible without ...
0
votes
0answers
40 views

Is it Parameter Sniffing when

I believe we had parameter sniffing. One time the follow code will run in a second or two, then running the same parameters will take 9 minutes. I've added OPTION (OPTIMIZE FOR UNKNOWN) and created ...
1
vote
0answers
47 views

Data compression within Internal Tables in SQL server 2008R2

We are doing downgrade from enterprise to standard for couple of servers which are not using any enterprise features: For one of our TFS(Team foundation server) database TFS_resx, when we ran ...
1
vote
0answers
35 views

SQLServerAgent Error: 32

A job that "will Recycle SQL Server Agent Error Logs once every week on Sunday at 12:00:00 AM." has been failing this weekend on SQL Server 2008 R2 SP2 Enterprise. This job executes a system stored ...
-1
votes
1answer
31 views

Unable to start the services of SQL server after Downgrading from Enterprise to Standard

We are performing the downgrade activity from SQL server 2008 R2 Enterprise to Standard. After the uninstall and re-install the standard version, (once the saved system databases were copied to the ...
1
vote
1answer
88 views

Can't remove active node from SQL Server 2008 R2 Clustered Instance

I am trying to remove the active and only node from a SQL Server 2008 R2 failover cluster. Everything checks out and then I get this error Final result: Failed: see details ...
1
vote
1answer
76 views

Powershell function to drop table(s) from SQL Server database [closed]

### List of tables that require full sanitizing $requiredTables = 'table1','table2','table3' foreach ($table in $requiredTables){ function Delete-FromTable{ $SqlConnection = New-Object ...
1
vote
1answer
33 views

SQL Server statistics

I have run the Database Tuning Advisor and it has suggested that some statistics are created. Whilst this is great and I understand the purpose of statistics, when I have reviewed them it has created ...
0
votes
1answer
37 views

Inefficient queries on partitioned tables

Consider a scenario in SQL Server that includes a partitioned table with over 500 partitions. The number of partitioning column values in a temp table are less than 10. We join the temp table to the ...
0
votes
4answers
222 views

How can I take backup of particular tables in SQL Server 2008 using T-SQL Script

I want to take a backup of particular tables available in my database in .bak file And all these should be done using T-SQL script
1
vote
0answers
60 views

How to speed up for huge tables in SQL select query?

I have the following huge tables. Table_1 with 500000 (0.5m) rows Table_8 with 20000000 (20m) rows Table_13 with 4000000 (4m) rows Table_6 with 500000 (0.5m) rows Table_15 with 200000 (0.2m) rows ...
1
vote
0answers
60 views

Parameter Sniffing Question [closed]

My question is: If we employ a plan guide, why would we still experience the effects of parameter sniffing (ie: Where the query returns results at different speeds, 1s, 1s, 1s, 15m, 2s, 2s, etc..) ...
3
votes
0answers
53 views

Torn page SQL Server 2008 R2 RTM

DBCC results for 'bad_db'. Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -6794535623816839168 (type Unknown), page (26876:998677113). Test ...
0
votes
1answer
61 views

System.OutOfMemoryException SQL Server 2012 and 2008R2

I have a 64-bit and 64gb memory for both SQL Server 2012 and 2008R2, when I generate a report w/c has 900K rows, it finished the query smoothly and no problem, but when I'm going to copy the result ...
0
votes
2answers
92 views

Using Like with variables?

I have an odd situation where I have a column called (TransmittalNumber) with datatype of VarChar (75) in a table named (Transmittal Sheet). I want to query this table to find the transmittal numbers ...
2
votes
1answer
67 views

Understanding & Resolving Deadlock in SQL Server 2008 R2

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, it's just the query changes, ...
1
vote
2answers
27 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 ...
2
votes
0answers
61 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
32 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
1answer
34 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, ...
-1
votes
1answer
51 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 ...
4
votes
1answer
70 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 ...
0
votes
0answers
50 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 ...
1
vote
0answers
61 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
1answer
143 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 ...
1
vote
0answers
51 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 ...
5
votes
1answer
173 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
45 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 ...
5
votes
0answers
75 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, ...
5
votes
1answer
52 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 ...
0
votes
0answers
38 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
1answer
36 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 - ...
0
votes
0answers
48 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 ...
1
vote
1answer
58 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 ...
1
vote
1answer
29 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 ...
2
votes
2answers
62 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 ...