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

learn more… | top users | synonyms (2)

3
votes
1answer
62 views

Why is SAN Replication is Causing Random Database Corruption?

Having a strange issue with a disaster recovery technology we're trying to implement. The environment in both datacenters is the same having VMWare and Dell Equallogic SANs, which are the same ...
1
vote
2answers
30 views

Read GPS Coordinates into LineString from Table

I found this beautiful piece of code which takes a linestring and I can get the points from it: DECLARE @GeographyToConvert geography SET @GeographyToConvert = ...
-1
votes
1answer
31 views

combine multiple rows into single row when its id is same [closed]

i tried this query select subject_id,Register_No, Stud_Id, Std_Id, Roll_No, Chachani_1,Gruhpath_1,Practical_1,Tondi_1,Lekhi_1,Total_1,null Chachani_2,null Gruhpath_2, null Practical_2,null ...
1
vote
1answer
49 views

Why is FORCE JOIN option slowing down query and forcing execution plan to sort prior to joining tables?

I'm linking Orders data with the Results data for those orders. Here's the SQL query for joining and selecting the ; with orders as ( select o.*, otr.*, oo.* from Order o inner join ...
1
vote
1answer
38 views

How to migrate SSAS and SSRS from SQL Server 2008R2 to SQL Server 2012?

We are upgrading our SQL Server 2008R2 to 2012 and separate the SQL Server engine from SSAS and SSRS. We want put on Server 1 the engine and on Server 2 SSAS and SSRS. I did the side-by-side ...
8
votes
3answers
284 views

Who created a procedure? (SQL Server 2008 R2 )

Is there a way to list who created certain procure in SQL Server 2008? In this SO link there are some answers but from 6yrs ago. I know it's a best pratice to write your name and date, and then ...
3
votes
2answers
212 views

List all databases of a certain user ( SQL Server 2008 R2 )

I'm really looking for this answer for some time. I bet there is a post here but, I really can't find ( even on google ). I think it's a simple task. I want to list all databases for a specific ...
1
vote
2answers
49 views

Compatibility level 100 on SQL Server 2008 R2 [duplicate]

I'm upgrading my databases to compatibility level 100 on SQL Server 2008 R2. My next step is to check if my stored procedures, functions, views, triggers are still working properly. Running each of ...
1
vote
0answers
47 views

SQL Server Profiler

I had run a SQL trace on SQL server 2008 r2 and had originally saved it to the table format. This table now resides in the database and I was wondering could I export the contents of the table to a ...
0
votes
0answers
14 views

Could not load file or Assembliy “SecureBlackBox.dll”

Task- To Send csv files to Secure FTP. Problem: Script Task using Third Party DLL for Secure FTP mainly "Eldos" is not able to load dll ,when deployed on integration server. Resolution Usually i ...
-1
votes
2answers
40 views

SQL Server can not save Autogrowth changes [closed]

When I have change Enable Autogrowth checkbox (set to true) and save it (Ok) And when I go back to the Change Autogrowth for ..... I see that the changes have not been saved. SQL Server 2008R2 (I go ...
2
votes
0answers
35 views

Connection Pools and TempDB Internal Objects

I am thinking I know the basics of the problem here, but I want to make sure I know the details before trying to explain it to others. We recently upgraded our third party application software to a ...
3
votes
0answers
62 views

SQL Server replication - error when creating a subscription - The article '(null)' does not exist

When trying to add a subscription to an existing publication use [Product] exec sp_addsubscription @publication = N'Product', @subscriber = N'REPLON1', @destination_db = ...
0
votes
0answers
16 views

Migrating from SQL Server 2005 (Win 2003R2) to SQL Server 2008R2 (Win 2008R2) new Server [duplicate]

I am pretty new to the DBA field and i have been assigned to migrate all of my Production database from SQL server 2005( server A) to 2008R2 (Server B) and Decommission all of those database from 2005 ...
3
votes
1answer
78 views

sql server - NoSync subscriptions will need to be dropped and recreated

I am having this error message from the sql server replication monitor: Error messages: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to ...
2
votes
1answer
50 views

Ways to Reduce Database Size and possibly improve performace. Untouched enviroment.

I am new to an environment. The Databases are virtually untouched by a seasoned DBA. I am looking for ways to reduce DB size and possibly improve performance. Unfortunately, I only have WEb edition ...
0
votes
0answers
12 views

Is it possible to move more than one database object into a schema using the `ALTER SCHEMA` statement in SQL Server 2008 R2? [duplicate]

I have a TSQL Statement like this: ALTER SCHEMA FindUsedAndUnused TRANSFER dbo.UsedUnusedNotSure_the_counts; And when I try to run it with multiple TABLEs or VIEWs I receive an error; Is there ...
1
vote
1answer
35 views

SQL Server restore database file access error

I am trying to restore a database from a file on a remote machine. The script I am using is as follows: RESTORE FILELISTONLY FROM disk = '\\server\path\to\file.dmp' RESTORE DATABASE MyDB FROM ...
1
vote
1answer
32 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager, sqlserver.exe is ...
0
votes
1answer
13 views

Permissions To Update Legacy DTS Packages

I am trying to grant access to allow users to view and update existing legacy DTS packages. The problem is that they cannot see the needed nodes under Management to begin working on them. I've tried ...
12
votes
2answers
377 views

Why is table variable forcing an index scan while temp table uses seek and bookmark lookup?

I am trying to understand why using a table variable is preventing the optimizer from using an index seek and then bookmark lookup versus an index scan. Populating the table: CREATE TABLE dbo.Test ...
3
votes
0answers
40 views

DBCC CheckDB run into early hardware failure

Our production database server (SQL 2008 R2 Enterprise on Windows Server 2008 R2 DC) run into a strange error during its nightly DBCC CheckDB (Prod_DB) since late June. The same job had been running ...
1
vote
0answers
27 views

Should I restore without the log file?

I need to restore a SQL Server database with/without the log file. This is for a reporting system and when I restore the log file it is sometimes 8x larger then the data file. I am restoring this once ...
0
votes
1answer
29 views

How to merge consecutive record pairs over a table?

I have a table where I need to merge consecutive record pairs (when ordered by id, data and from). Note that for pairs being merged, the first row's prevfrom is NULL and the second row's nextto is ...
2
votes
1answer
29 views

Hosting SQL Server and SSIS/SSRS in same VM

I have SSIS / SSRS and large number of databases currently being hosted on the same prod server (SQL1, SQL Server 2008R2). Since SQL1 already has SSRS/SSIS installed, would it be a good option to ...
1
vote
3answers
110 views

SQL Server Max memory limit

I have my SQL Server 2008 R2 installed running on 32GB ram. I need to decrease the limit SQL Server uses to 28 GB and I have set the same to 28GB but it is still taking more. I have seen posts saying ...
2
votes
1answer
34 views

How to copy non clustered indexes in transactional replication

I create transactional replication ,but forget to include non clustered indexes and now my subscriber have only clustered indexes (primary key) and I want to transfer all nonclustered indexes to ...
0
votes
0answers
18 views

Should setting up SQL Server transactional replication require schema locks on published articles?

I'm attempting to setup transactional replication in a production environment. When adding columns to an article (calling sp_articlecolumn stored procedure), it appears to want to lock the published ...
1
vote
1answer
34 views

Follow up to: SQL Server 2008 R2: Problems after computer name change

The Original question can be found here: SQL Server 2008 R2: Problems after computer name change I need to know if there is a way to modify the script found in the original question to allow for ...
0
votes
0answers
14 views

Transactions Log fails to shrink / release vfl [duplicate]

The past two nights, our nightly index job has caused our log drive to fill up. We complete log file backups every 15 minutes, and the log file still grew to 250GB. This is a SQL Server 2008R2 SP3 ...
1
vote
1answer
46 views

microsoft sql server schema [closed]

From blog.sqlauthority.com: Protecting ISV database access: in custom ISV (Independent Software Vendor) applications, the database schemas are usually complex, and in the case of applications such ...
0
votes
1answer
48 views

How to FETCH from a cursor into a table variable?

I have a cursor defined as: DECLARE idCursor CURSOR FOR SELECT DISTINCT [id], [data] FROM #tempTable And I have a variable defined as: DECLARE @currentId TABLE ( ...
0
votes
0answers
32 views

SQL Server DR scenario

I have a SQL server A and B which is production databases. The DR of production 'A' is production db 'B' and DR of production db 'B' is production db 'A'. DR feature that is used is log shipping. All ...
3
votes
1answer
52 views

SQL Server 2008 R2 Mirroring issues

I have this very frustrating problem that I've been trying to figure out for almost a week now. I have two SQL Server 2008 R2 STD w/SP3 box running on Windows 2012 R2 with two instances each, Server1 ...
0
votes
0answers
11 views

Monitoring external Oracle db, creating changes locally to SQL Server

I have a local mirror database of an external database that our vendor provides us read access to. Occasionally they add columns and/or table to their database. The addition of columns used to play ...
7
votes
3answers
263 views

SQL Server compatibility with New TLS Standards

The major browsers are moving beyond SSL3.0 and TLS1.0 . The PCI Security Council has declared an end-of-life date for these protocols to be considered sufficiently strong encryption. We need to ...
1
vote
1answer
44 views

Why RECOMPILE doesn't fix parameter sniffing, but local variables does?

SQL Server 2008 R2 A developer was asking me about why his procedure wasn't running, but the query was ok. When I run the query, it was fast.But running the procedure, it was executing forever. ...
2
votes
3answers
89 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. ...
0
votes
1answer
40 views

SQL Server 2008 Triggers and Merge Replication

I am trying to have a trigger fire when the Merge agent inserts or deletes data into / from a table. It is supposed to insert data into a report table for use with SSRS. I DO NOT have the "NOT FOR ...
-6
votes
2answers
60 views

bring the output into single column from a table as vertical order [closed]

Name Age Type City Tom 20 life null tim null motor UK john 55 null USA I need Output as Tom 20 life Tim motor UK John 55 USA
0
votes
0answers
65 views

optimizing paging in a stored procedure

I have the following SQL command which is built inside a stored procedure according to input parameters: SELECT DISTINCT * FROM ( SELECT DISTINCT TOP @displayLength * FROM ( ...
6
votes
3answers
150 views

How do I merge similar records with different validity dates?

The table I am working on has three components: An ID column (primary key in another table) Some data columns Date valid from/to columns. Values: ID Data From To 1 a ...
3
votes
2answers
47 views

Trace to find “error messages”( SQL Server 2008 R2 )

I'm using this config, trying to find error when a certain host executes a task ( it runs inside a software ): The user says that the software is running, but it's not updating what it needs to ...
2
votes
0answers
28 views

SQL Server 2008 Replication “between retries” or “worker thread no available”

All our existing servers are in SQL 2008 and I am in the process of upgrading to SQL 2014 and as well moving SAN to different SAN storage. As part of it I have to upgrade my distributor. We got ...
2
votes
1answer
36 views

Select columns dynamically from sql server table

Lets say I have a table that actually store record which looks like Create Table dbo.Info ( SN int primary key identity(1,1), FirstName nvarchar(50) not null, LastName nvarchar(50) not null, ...
1
vote
0answers
48 views

How to resolve Error 7311 returned by a job running against a linked server?

I have a job and a linked server. The job was working fine for a while, but recently I started getting this error message and I couldn't find a soloution for this. Executed as user: ... Cannot ...
3
votes
3answers
153 views

Restore a large number of transaction logs

I'm using SQL Server 2008 R2, and I need to restore 36 .trn logs to a database. I have restored the first 4 using the restore transaction log functionality in SSMS (right-click database > tasks > ...
1
vote
0answers
13 views

restore multiple .trn logs in SQL 2008 R2 [duplicate]

I am using SQL server 2008 R2 and need to restore 36 .trn logs to a database. I have restored the first 4 using the restore transaction log functionality in SSMS (right click database > tasks > ...
2
votes
1answer
24 views

Are there security vunerabilites/implications with SQL Mail, currently using SQL Server 2008 R2

I am an accidental DBA and responsible for series of data load jobs. I would like to use SQL Mail for altering me to job failures. SQL Mail is not currently turned on are there security concerns in ...
6
votes
2answers
131 views

FOR XML could not serialize the data because it contains character (0x0000)

I have a big query (if necessary I will post it here) and I'm getting this error: Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'NoName' because it contains ...