Help finding Fullback up file upon which differential backup is based - New to SQL and SQL server and faced with making sure our company is properly backing up all our DBs. ...
Different behavior between "alter table drop column if exist" (new syntax) and the legacy one "if exists() alter table drop column " : is this a bug? - Hi I have notice something weird with the new syntax with a "drop if exist" It looks like the new syntax fire...
Join on next available non null value - Hi folks, I have costs that I need to convert into a different currency based on the currency at the time. ...
Update failing from CSV if data not in table - First post here guys so sorry if Im in the wrong place for this. Its been the bain of my...
ADDING FIELDS WITH A SELECT STATEMENT - Can someone kindly help me with the query below: SELECT 1 AS ID, '1 Field, COALESCE(SUM(Field1)/1000,'0.0') AS Field FROM Table WHERE Condition='Money' and SecondCondition...
Row-by-row insert with error handling -- Stored Procedures vs. SSIS - Hello, I have dynamic inserts and update statements that are created based on a select from sys.columns. My inserts and updates...
SQL 2016 SP2 - CU2 - Security Patch KB293807 - Maintenance Plans Issues - Over the weekend we installed SP2-CU2 and KB293807 on our SQL Server failover cluster. Now maintenance plans aren't work on...
SPN Registration hostname vs dns - Hello, Does anyone know if you need to register both the DNS address of a server and the hostname of the...
Best way to join onto same table to extract different data - I'm the original poster of this question https://www.sqlservercentral.com/Forums/1990728/Multiple-Joins and during the conversation I was told my existing code was bad because...
Multiple Joins - Hi guys, just a general question. I'm writing a query in order to create quite a large report. I have multiple...
Transactional Replication - Inserting Duplicate Keys - Hi All This seems like a strange one to me. We added a few new articles into a publication yesterday, and...
Will temp tables be dropped when Transaction commits? - Hi gurus! It is been a long time since I asked you for your input to clear my self doubt :) I...
Enforce Unique Constraint Across Two Tables - I have an interesting problem. An application allows users to "Tag" events with a label. Each user can put a...
INSERT EXEC statement cannot be nested - I have a requirement to get data from a deep chain of procs. However, there is already an "INSERT EXEC"...
Unicode Support and Conversion - I have SQL Server 2012 and all my inputs got changed to Unicode. I have a week to change my...
Procedure Result taking more time - Below stored procedure taking more time(1 minute 56 seconds) for completing the execution.First table PDF_MSDS only having more records compare...
Enable Logging of both failed and successful logins on Linux - Anyone seen how you do this? On a Windows Environment you can just do this via the Server Properties Window,...
Prevent duplicates in a table - I am entering 'salaries' information into a sql server table called 'salaries'. Fields are : id (pk,identity),c_id (int),month,year,salary. I use a stored procedure...
Non Clustered Index on Phone column - Dear All, I have a Lead table with below fields. LeadId int (Not a primary key) Telephone ... ...Table have 4 millions records Client always search the...
SSIS suddenly takes longer time to run - I am relatively new to SSIS. I have an ssis package which used to run in less than 9 minutes....
