sql-server-2008-r2's questions - Chinese 1answer

3.581 sql-server-2008-r2 questions.

SQL Server 2008r2 I'm trying to drop a certificate I've created but i get the following error The certificate cannot be dropped because one or more entities are either signed or encrypted using ...

A slow Stored Procedure is extremely faster (going from 2 secs to 8 millisecs) with QUERYTRACEON 4136 and ARITHABORT ON, on the local SQL Server 2008 I use to develop. The "fixed" SP, on another SQL ...

I am connecting to SQL Server (2008 R2) over open Internet and properly encrypting the connection is essential. I have COMODO certificate with two intermediate certificates between root CA and server ...

I often have to create or update e-mail distribution lists in SSMS, where the requestor will ask "please add Anne Hathaway, Albert Einstein, and Ash Ketchum to the DL. Get their email from Outlook." ...

@@Version Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) If I try to insert data into a geography datatype in a temp table I get a CONVERT_IMPLICIT, converting a Geography datatype to a ...

Running SQL Server 2008R2 STD 64bit edition on Windows 2008 R2 64 bit edition. The Windows server is a Hyper-V VM with its memory set as follows When I run the following query; SELECT [...

Upon a request that I received, I have queried out the all the database roles under a particular login. To make sure that the result is correct, I opened up that particular login and went over to ...

It's fairly straight forward to fix up a single orphaned SQL user to a login using: EXEC sp_change_users_login 'Auto_Fix', 'user' I could script this, but is there an existing stored procedure ...

I'm trying to improve the performance of the following query: UPDATE [#TempTable] SET Received = r.Number FROM [#TempTable] INNER JOIN (SELECT AgentID, ...

I have some code that uses Entity Framework to call a stored procedure in SQL Server. If I run SQL Profiler and filter by the database it is calling, I can see that the profiler correctly shows the ...

I want to migrate my database server to a new server. Right now I have a database server with Windows Server 2008 and now I am migrating to a new, separate server with Windows Server 2012. There are ...

I am attempting to insert data into a linked server using openquery. I have attempted the below syntax, but get an error of Cannot get the column information from OLE DB provider "MSDASQL" for ...

I know it sounds crazy. However its just a thought given by DBA,s and management to check on. We are going to use LS to do migration of around 10 TB Db from 2008R2 to SQl 2014. This DB is 24*7 in ...

Is there any concern in referencing a unique index from a foreign key table? Using SQL Server 2008 R2

CREATE TABLE T1 (Asset_Id int, Trailer_Id int, AssignStart datetime, AssignEnd DATETIME) ; INSERT INTO T1 (Asset_Id, Trailer_Id, AssignStart, AssignEnd) VALUES (37124, 32607, '2018-04-19 ...

I have been using on my SQL Server 2008R2 server Ola Hallengren solutions for almost two years. Last night backups failed, both System databases and user databases with error below. Example of ...

I've the below format table and the return values from my table. id x val 1 1 8.18 2 3 8.35 3 5 8.51 4 7 8.52 5 10 8.54 6 15 8.57 7 1 8.35 8 3 8.60 9 5 8.70 10 ...

I am trying to optimize a query which looks similar to this: select top(1) t1.Table1ID, t1.Column1, t1.... .... t2.Table2ID, t2.... .... c.FirstName, c.LastName, ...

I will be working on a project shortly that would involve moving the replicated databases off of old to the new SQL Server instance. I haven't done this in the past so I don't have much knowledge ...

I think useless is a heavy word for this. We have a database with 500GB, and most of it's information is only there if we MAYBE need to use them. it's a big database with credit card information and ...

I need to create a couple of snapshot tables that will export a large amount of data. While running a few tests, I need to create the table, import data, inspect the results, update the export query ...

I've been seeing some SMTP errors in my database mail logs. So I have a set up a test SQL Agent job that runs every ten minutes (it's only action is to SELECT NULL). It is set to send email ...

I have an SSIS package deployed to both my DEV and QA environment, both QA and DEV are under the same server and SQL Instance. The package has only three objects in the dataflow: an MDX query, a ...

I made everything I can in some procedures and queries to tune some processes. So I'm using tuning advisor to see if I missed something, and to my surprise, there's a lot of statistics to be created ( ...

I have an application that was compiled with a hard-coded connection string (using the server's IP address '192.168.40.201' and not the servername) to an MSSQL Server. A backup of the database has ...

I am attempting to set up and oracle publisher on a sql server 2008R2 server, but I am getting the following error. "Unable to run SQL*PLUS. Make certain that a current version of the Oracle client ...

When accessing SQL Server with SSMS versions (2012/2014 and 2016), opening the databases list from the object explorer is really slow. If I try it using SSMS 2008 R2 on the same instance the result is ...

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 ...

Due to security concerns we have to disable old TLS, SSL protocols and only enable TLS 1.2 in our servers. After I installed TLS 1.2 update 10.50.6542.0 for SQL server 2008 R2 SP3 from official ...

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...

In my database i have a column named index_description_column in the table products, and i've a record with "2205607 GRAMPO FIX. ROLDANA 7/8" (1X9)" data. When i do the following query it brings de ...

To set the scene, I maintain 4 local SQL Server 2008 R2 instances. At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure. I am currently using SSMS ...

I'm looking into providing DB level change tracking within my system. I need to be able to track changes at an entity level, rather than just individual tables. Right now, we have triggers on each of ...

I have two SQL Agent jobs which are scheduled to run at different intervals. The first job runs a full backup once a day. The second job runs transaction log backups every fifteen minutes. As the ...

I have setup an Extended Events session in SQL 2008 R2 to track the deprecation_final_support and deprecation_announcement events. I noticed some "deprecation_announcement" events in my log with "...

This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups (...

We have an old workstation running Windows 2000 that must connect to MSSQL14 running on Windows server 2012 R2. When i try to create an ODBC using: sa TCP/IP (ex. 123.456.789.012) not dynamic port ...

Due to lack of my knowledge in service broker i am finding hard time in troubleshooting Service broker in one of the databases. Initially the Service broker somehow got disabled on this database ...

I am using the DMV views to get a list of index recommendations and then I am reviewing each of them to make sure they make sense and don't overlap etc. Some examples are Index ON X ( Y ) and Table ...

When I run a report on SSRS reporting services to fetch 600000 row.. I get a error "Exception of type System.OutOfMemoryException was thrown". I read so many blog's for solving this issue but still I ...

Error : TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to ...

Interesting find today, I have a file group that is used for indexing. It has one file that has a .ldf extension, which as you know for SQL Server, is the extension for the transaction log files. My ...

I'm trying to run a BULK INSERT but I'm getting an access denied error. So far I've tried the following: I can open the file from my machine I'm logged into the SQL Server (tried v2008 R2 & ...

I'm trying to tweak the "Server Activity" Data Collection set as outlined in this blog post (I wrote the post, btw. Sorry--it's kinda long). It is working in SQL 2008 R2 and also in SQL 2014. However,...

I'm using sqlcmd (SQL Server 2008 R2) to execute a simple query to output data to a .csv file. In the SQL file, I have the following code: USE [OSCAR_UK] SELECT DISTINCT ISNULL(LTRIM(RTRIM(il.[...

SQL Server 2008 R2 is showing log_reuse_wait_desc as REPLICATION. I do have Replication Publications and they are failing also. I would like to get the database back working and deal with the ...

I've received a database that was previously on SQL Server 2008R2 but was just put on a SQL Server 2014 instance. There were no maintenance tasks run of any kind run on the database since 2014 (e.g. ...

I'm trying to exclude the Minimum and Maximum value from Between Condition but not able to exclude. For Example: select * from temp where a between '2' and '6' But 2 and 6 is available in my ...

Create Table Script create table temp ( id int identity(1,1), a decimal(6,2), b decimal(6,2), c decimal(6,2), d decimal(6,2), e decimal(6,2), f decimal(6,2), g ...

Which one is the best option to get the identity value I just generated via an insert? What is the impact of these statements in terms of performance? SCOPE_IDENTITY() Aggregate function MAX() ...

Related tags

Hot questions

Language

Popular Tags