sql-server's questions - English 1answer

23.385 sql-server questions.

I understand that both NO TRUNCATE and COPY ONLY options don't truncate the transaction log or affect the chain of backups. So what is the difference or use case for these?

Lets say there is a crash then we can use the full backup and a tail log backup - because if there was checkpoint then data would already be written to the database data file and flushed from the ...

The SQL 2016 Data Migration Assistant (Upgrade Advisor) is saying that I need to stop using old system table references. Namely, it wants me to stop using sysdatabases and sysprocesses. I have some ...

The SQL Server Browser needs the following privileges: Account Privileges: SQL Server Browser listens on a UDP port and accepts unauthenticated requests by using SQL Server Resolution Protocol (SSRP)...

I have 2 table in my database. Table #1 ------------------------------------------------------------------------- | name | family | phone | email | gender | phone2 | address | birthdate | -----------...

Please can I have a technical meaning of point in time recovery? Does it mean that given a backup file, we must be able to recover upto any point in time during the span of the time covered by the ...

What exactly is the memory that is allocated to the a memory component in SQL Server? I believed committed memory is the amount of physical memory that is being used, and reserved is the amount of ...

I am trying to troubleshoot the below deadlock situation Looking at the deadlock xml, both session are using read committed isolation level. Question is, in read committed isolation level, in this ...

I am reading this book from Microsoft - it says: "A log backup cannot be performed unless the database is in full recovery model and an initial full backup has been performed" Is this correct? I know ...

When a change is to be made, the data page is fetched from the database data file into the buffer and changes are made to the buffer page and are also written to the transaction log. Write ahead ...

We are not using SQL Enterprise Edition. And we have to do audit trail by ourselves. Throughout the process, we discover that the data we store (json string) is really few times the sizes our original ...

Assuming VLDB is split into multiple file groups, each having its own file and on a separate disk. Now let's say there is a disk crash bringing down one of the file groups - then will the other parts ...

I am trying to connect to an MS SQL Server database through DBeaver via an SSH tunnel but am getting the following error message when I "Test Connection...": I/O Error: Connection reset ...

I've successfully created a SQL Server AlwaysOn High Availability Group between two servers and everything seems to be working great internally. Each replica is on a separate physical location, behind ...

I am working on a report, one of the requirements is that I find the turnaround time between two dates (columns) - I have done that using a DATEPART function, however, the hours are exaggerated, I ...

I heard that you cannot have SSRS and SQL Server on the same server, I have not been able to find anything that says this or otherwise, is this a true fact?

I have a table with a "Description" field. Which contains the titles of a whole lot of phone models. **Table1** Id - Int (PK) Description - nvarchar(200) **Lookup Table** LookupId - Int (PK) ...

In a place where I work we have lots of subscriptions set for SSRS reports. Some reports have as many as 100 subscriptions set up. Our data warehouse is refreshed every night, with all the data ...

I have a SQL Server 2016 SP1 production server. It's been running without a restart for 330 days. Everything's been running fine. Until last week, one day, all of the sudden, every query on the server ...

I've centralized my farm's jobs in MSX, covering about 70 instances of SQL Server. Seemingly randomly, at least once a week, several instances will stop accepting instructions. Within the MSX window ...

I create a bacpac from azure and restore to my local on-prem server. However, it throws an error like “Please create a master key in the database or open the master key in the session before ...

I got a deadlock when having more than one sessions doing the following: start transaction insert data to table A delete data from table A commit at the same time They may delete the same records ...

Source is one service pack behind destination (2012). I know service packs can be issues here, but it looks like this is only for versions 2000 and 2005. When using sp_helptext sp_MSupd_PROC the ...

DBMS: SQL Server Upgrading from version 2008 to 2016. I have this part of the code that is being flagged by the Upgrade adviser as Breaking Change. Error: uses a constant expression which are ...

Whenever I have to drop a publication I follow the steps below, ending by a call to sp_droppublication when I get the error below two times. The publications seems to have been dropped successfully ...

We have a server 2008 R2 with SQL 2008 instance. The underlying hardware RAID is failing and we need to migrate the databases to a stable piece of hardware with the same hostname on the network ...

In the following queries the Student table has Clustered Index on StudentID column, and the Enrollment Table also has a Clustered Index on EnrollmentID as well as Non-Clustered index on (SessionID, ...

I need to know why the correct answer is D ? what is the diffrence between D and A. Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores ...

Trying to run a simple UPDATE query as follows: UPDATE [TILL].[dbo].[appParameters] SET [TILL].[dbo].[appParameters].[ParameterValue] = "1" WHERE [TILL].[dbo].[appParameters].[ParameterName] = "...

I have several problems with launching MS SQL Management Studio. I am aware that all of my problems have many answers on the web, but none that I have seen have worked and I'm losing hope. I'm trying ...

I am working in sql server 2016 with Filestream attribute column. I have a column with filestream attribute activated on it. when I insert a reacord in TSQL , the associated file is created in ...

I'm having a problem allocating payments to invoice lines. Data looks like this: Invoice lines table (sales): lineId, invoiceId, value 1, 1, 100 2, 1, -50 3, 1, 40 4, 2, 500 Payments table (...

An application server database we use contains many columns (300 +), a lot of these columns contain a default value defined by the application (e.g. 0 or ''). These tables need to be ported across to ...

I have a table (in left) and I am trying to get the all new entries and all deleted entries between two dates (ex: 201801 and 201804). With this code, I only get the values comparing the two dates, ...

An application intermittently fails with generic ODBC error. The client application is using ODBC to connect to SQL cluster. Enabling ODBC tracing shows this error: StorageOnlineOp 46ec-44a8 ...

I would like to access a MySQL database from within SQL Server. I created a system DSN, and it tests OK. I created a linked server in SQL Server: Provider = Microsoft OLE DB Provider for ODBC ...

my coworker and I had a debate and I am looking for Reddit to resolve it! We have PHP web apps running on IIS and are looking to setup the security to the database using one approach: -What would you ...

Is it possible to set the identity column of a table to start from a specific value? I'm converting an ETL stage from mysql to a sql server database where a staging database loads records with a ...

I need to implement a data type which should preserve the last zeros in the decimal points in SQL Server 2008 R2. Example of the data are 1.002 1.210 0.00100 0.1401 My clients get lab measurements ...

I have a table named _Test which has the following values stored in it. Primary Key : Id I also have designed a trigger on that table ALTER Trigger [dbo].[_Test_Data_Save] On [dbo].[_Test] For ...

I know there was a similar question before at SO as shown here However, that answer really does not address my question. So here is my scenario, and I will demo it with PowerShell. The following code ...

I am observing a situation in AdventureWorks database where the hash join operator is building hash table using a larger input (296 rows) and then probing with a much smaller input (3 rows). I'm not ...

If I use SET SHOWPLAN_ALL ON on SQL Server (13.0.4224.16), I can see EstimateIO, EstimateCPU and TotalSubtreeCost columns among others. If I add EstimateIO and EstimateCPU for lowest operator (0....

I did a routine Ubuntu system update for security patches today (2018-02-21)... mssql will no longer start or update, seeing failures in error log, systemctl and update output with 404 like: Err:13 ...

I have an SQL statement that is taking about 40 seconds to run and the only thing I see is an high hash match and sort. I have added indexs to the temp table but still taking an long time to complete. ...

I have a scalar function that traverses a simple parent-child hierarchy of customers to find the ancestor that's in charge of billing. Here's a simplified version of the schema. CREATE TABLE Customer ...

We have this one user who uses SSMS to connect to a 3 node 2 instance fail over cluster. He also uses SSIS, Excel, SharePoint, SSAS etc.. to connect to this database instance I'll call TEST. There are ...

I've created a replication subscription After refreshing there is no Local Subscription in a folder PS I've also checked in a Publisher in case of a mistake but there also was no subscription ...

Tempdb is growing and it's all version store data. When I run: select hostname,elapsed_time_seconds,session_id, transaction_id, is_snapshot, blocked, lastwaittype, cpu, physical_io, open_tran, cmd ...

I have done extensive research on querying LDAP Server but so far has not been able to work around. Therefore, asking experts help Background: I have a client whose LDAP Server is OnPremise (though ...

Related tags

Hot questions

Language

Popular Tags