sql-server's questions - English 1answer

22.720 sql-server questions.

In SQL Server Extended Events, event = perfobject_logicaldisk, what is the actual unit of time for average_disk_seconds_per_read and average_disk_seconds_per_write? All of the documentation I've ...

Hi I'm storing some data with this SP from a xls file. This files are separated by " \t " , but recently I've been receiving files without escape sequencers. So I need to find a new way to split my ...

I have a question about how I can model my stock database in order to get the best performance possible. In SQL Server or in the Oracle, each update executed generates a little lock. I'd like to ...

I have a need for a recursive query to find daisy chained related data. I have the following query CREATE TABLE #source (Parent varchar(10), Child varchar(10), Date datetime) INSERT INTO #source (...

I am currently working on the following table in SQL Server Table: order_status_logs log_id INT NOT NULL IDENTITY(1,1) order_id INT NOT NULL status_id INT NOT NULL log_date ...

We have a goofy process (don't we all?) that daisy chains (or cascades) on a table that needs flattening out for our data warehouse. The field "alt_key" is an identifier field. It ends up being the ...

I am trying to update columns with counts based on values in another field. I have tried a couple of different things but am not getting the results I expected. First, I have created an update query ...

I was reading an article at www.codemag.com/article/1208111 and saw cases in the WHERE clauses where columns were compared with Column1 <<<>> Column2 And Column1 <<<= ...

On our SQL Server, we have a database for each of our web apps. For reports, we use Reporting Services and all report data (including report parameters) come from stored procedures. The stored ...

Recently I came across a question like , Can a SQL Database table contain index size greater than actual data size ? I have gone through few articles and studied bit on this and few experts ...

Before I restore a database, I need to save the contents of a table called dbo.ref_systemSettings if it exists. So I created a script that calls a procedure that will save the contents of this table ...

I want to create a maintenance database that i can clean up master and msdb, i am trying to collect all the table info from master and msdb that are not Microsoft tables, bearing in mind that some ...

I have the below query results to attach and email: ----------------------------------------- EXEC [msdb]..sp_send_dbmail @profile_name='SMTP', @recipients='xxxx@yyy.com', @subject='DB Mail', @body='...

Trying to install SQL Server on Ubuntu 18.04, I'm getting # sudo apt-get install -y mssql-server Reading package lists... Done Building dependency tree Reading state information... Done Some ...

Tried doing this but could not solve my error Go to SQL Server Configuration Manager Start->all program->SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager Explore ...

I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...

I have created an involved CTE, with no recursion, but with multiple selects being done as it processes the business logic of the requirement. Though, I have been advised that the logic needed for the ...

I have a query where using select * not only does far fewer reads, but also uses significantly less CPU time than using select c.Foo. This is the query: select top 1000 c.ID from ATable a join ...

Following error occurs on running sql job. Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied.). [SQLSTATE 42000] (Error 4861). The step failed. ...

I'm using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex). I need a regex expression that can reliably remove square ...

Kindly I have stored an Arabic language on my database , but it is showing as question mark, How can display clear text.

I am having trouble understanding what exactly to expect from the CleanupTime option in the Ola Hallengren Server Maintenance Solution. I'm finding some related questions, and elaborate answers, but ...

I am having some trouble while migrating data from SQL Server to MySQL--it seems some data does not want to place nice. I am recieving the error: Incorrect string value: '\xA0\xA0' for column '...

I am dealing with SQL that looks as follows create procedure as begin Notice the large gaps e.g. between as and begin. How can I remove these? I used SQL formatter but this is not working.

I have 2 columns, an int and a tiny int, and I want to update another column, a varchar one, with the value column1 + '-' + column2. Something like this pseudo code: UPDATE COLUMN3 varchar = CONCAT (...

I'm trying to use HammerDb 3.0 to get a baseline to compare my servers. I can create the Db, schema, data and items required no problem. I can execute the test and see that it's running. When the ...

I have a 170 GB table that is no longer referenced. I want to move that table to another server. I tried these options in staging: select into 8 GB table to another db - 1.47 min SSIS package - 6 ...

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[SelectSRQMST] ( @SRQNumber int=null ) AS begin transaction if @SRQNumber=0 select S.*,I....

I have run the below code: execute sp_configure 'external scripts enabled'; and it is giving me the output as: name minimum maximum config_value run_value external scripts ...

I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...

I'm trying to backup my availability group in SQL Server 2016 using DPM 2016, but after I add the cluster in DPM, availability group show nothing to back up. I've set every secondary node to be ...

Assuming a database using full recovery model, when a record is written in SQL Server (by INSERT / UPDATE etc) write ahead logging will ensure the change is written to the log file before modifying ...

I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...

Execution Plan as Query SELECT VP.Branch , VP.ROUTE AS Route , VP.SAPCustomerID , S.CustomerID , S.ProductID , S.Date -- Group by Customer , CustomerQuantity = SUM(...

I am trying to create a folder based on the servername\instance to backup up to, i want the folder to create as servername_instance. Could you please point out where i am going wrong as it creates as ...

I am very new to SQL Server. I am trying to split time in time out records that fall between night shifts from a employee shifts table but I am having a difficult time doing so. Night Shift runs from ...

I am writing a Table Value Function, calling the function takes 10x as long as directly running the code. I traced this to a call to a multi-line scalar function inside the TVF. The call to the ...

I have been creating an access database for my assignment. I am using SQL SERVER 2014 for the datasource for the access tables. Now the problem is that according to the assignment i need to make ...

In doing research for index maintenance, I found some significant differences between the page counts reported by sys.dm_db_index_physical_stats and sys.allocation_units in some of the clustered ...

I've configured a log shipping from a server, to the same server, only with a different instance. Primary server is configured this way: LSBACKUP_MyDatabase - every 25min Secondary server: ...

I'm having a tough time to connect to a local SQL Server instance within a C# app. I can connect to external databases on other servers, but I need to be able to use my own local database. The ...

I have a server which runs third party software (called Visualcut) to email Crystal Reports to our users. When I log onto the Visualcut Server, I can open the software and then preview a report. This ...

I have a query that calls a remote table through Linked Server. However, in the execution plan the Remote Query is 71% of total cost and the time taken to run is over 4mins. It returns all rows in the ...

I suddenly start to get the message while performing backup, I know i have taken backup of the certificate and stored it in my password manager which I still have access to. My question is that do we ...

When getting table properties from a SQL 2014 server (12.0.4449) using SSMS 2014 (12.0.4100) or 2016 (13.0.15600) on any database or table I get the following text for the "Index space" property on ...

An SSIS package keeps failing for no reason. There are only three lookup transform components in the package (besides the source and output component), two running in partial cache mode and the other ...

We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...

We have two MS SQL Servers (2012 Standard Edition on Windows 2012 Server) which are located in the same subnet. One is production server. Another is reserve server. Currently there is a ...

EDIT: We've found most of the options we needed to include the necessary CHARSET. Here is what we've included in the MySQL my.cnf: [client] default-character-set = utf8mb4 [mysql] default-...

I need to move my distributor server to a brand new server without resnapshotting it. The scenario I have is similar to the one defined in below link. http://www.sqlservercentral.com/Forums/...

Related tags

Hot questions

Language

Popular Tags