Search results for query: *

Hello all, We inherited an application that was rewritten from SmallTalk with a SQL Server in the backend that causes a lot deadlocks and runs slows at times for that reason. The database has many tables, all of which have an ObjectID INT key value. However, the value is not auto-generated...

We have an HAG configured with 3 servers running Microsoft SQL Server 2012 (SP4-OD) (KB4091266) - 11.0.7469.6 (X64) Feb 28 2018 17:47:20 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor). S1 normally functions as the...

Hello all, It's been a while. I am trying to export a table using the bcp utility. Below is the command I am running in SSMS: exec master..xp_cmdshell 'bcp "SELECT Col1 FROM MyTable" out E:\Projects\Reports\mytable.txt -c -T -SMyServer' which returns the following error which suggests that...

Hello. Don't ask me how I landed on SAS, but it's now on my plate so I am learning... In my data plan, I am trying need to add a column to an existing dataset. The way I found to do it is by adding a column in a code transform. However, I am struggling to create a variable then assign that...

All, A third-party vendor has submitted a script for execution to resolve an issue users are experiencing. Since this is serious business and the query is not in standard format, I want to make sure I understand its purpose correctly. The query is: delete GL20000 from GL00100, GL20000 where...

Hello all, I wrote a long post a few minutes earlier and posted it but now I cannot find it. This is a short version of it. Please forgive me if it turns out to be a duplicate. In short, I am not a SP guy but a SQL Server DBA/programmer. SQL Server is showing that the SP databases are pointing...

Hello dear members, I have a database with one of the tables being larger than the other tables by orders of magnitude. There is a group of 5 tables that form a subsystem within the data and we would like to store, backup and restore them separately, in hopes of reducing I/O times and speeding...

Hello all. I am trying to understand why CHECKSUM is yielding 1)a different result for the same input values based on whether they are coming from a view or from a table 2)the same value for different input values from the same function. Is the source of the input values factor into the...

Hello everyone. I have a MERGE statement that pulls ~50,000 rows of data from one table in a database to another table table containing >28,500,000 rows in another database, on the same server. However, the SSIS package scheduled to run through a job has been running for 3:00AM and it is almost...

Hello everyone. I have had to split a MERGE statement into two separate ones because I could not figure out why duplicates were added after the second execution. The source of the first MERGE, code commented in my statement, is providers with an NPI number; 2032 in total. The source of the...

Hi guys, I need to help a friend with a query and I must disclose that I have not have time to think about it myself since yesterday when he submitted it to me but I managed to create the table and put the data in it. So please only help if you have the time yourself... CREATE TABLE...

Good day. There is a trigger on a table in one database. The trigger inserts a row in a table in a separate database. However, the insert fails due to the trigger not being able to insert into the second database. As an admin I am able to execute the insert successfully. Users, members of a...

Hi guys, There is a SQL Server job that deletes log files older than X number of days. It executes a DOS command that loops through all files that match the criteria, prints the command and executes it (DELete). There are parts of the syntax that I don't understand such as the 2^>^&1...

Hi guys, We have a mission-critical database with a very large audit table; more than 200 million rows and growing as I type. This table is one of the bottlenecks of our system. Most user activity on the front-end is audited and a large number of checks are performed against the audit table...

Hi all. I have a situation where I have to restore a database to a different location. There are nightly backups, seven days a week, and log backups taken every thirty (30) minutes. On 10/3 the nightly backup failed and on 10/10 the last transaction log backup was taken. We did not realize this...

Hi guys, We are looking to buy a SQL Server monitoring tools. I know of Idera and RedGate Tool Belt. Are there any other tools out there worth considering that you know about? If you've used the two that I've mentioned please provide pros and cons, if you are so kind, of course. Thank you...

Hi guys, For the past couple of nights, around 10 PM, users of a Windows application have been getting the error in the subject line. I am researching the error but nothing of substance so far. Windows and SQL Server logs don't reveal anything. Thank you in advance for your help. MCP SQL...

Hello, I have a job that is supposed to send an email notification to an operator on failure. The job completes with SUCCESS, however even when it does not the email is not sent and there is the message when I look at the job history and click on the line item, without expanding it. Database...

Hello all. Someone might have asked this already but I can't find a related thread. My problem is a DB that is a little over 500Gb in size. It did not be to be in Full Recovery mode so I changed it to Single Recovery mode and reclaimed most of the space the log file was using. Now, I dropped...

Hello all. I have a situation where the powers that be are using Red Gate software to replicate a production database onto a report server. The Red Gate app backs up the live database creating the files in one location, then restores while moving the files from that location to the report...