Login issue -Password did not match - Hi All, Need help...and logs does not help Error : ‘Login failed for user ‘sa’. Reason: Password did not match that for the login...
How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL....
Databases in AlwaysOn Availability Group show "Synchronized" but they're not - Hi, Has anyone ever encountered a situation with an AOAG where the databases in the AG state that they're synchronized but...
Always on with an SQL Cluster and 2 nodes - Hello all, I have searched everywhere and can't seem to find an example of setting up Always on where the primary...
proc not failing when primary key violation happens - I recently installed sql 2016 ent on a dev box then moved the proc over. It is no longer failing...
Algorithm to combine 2 integer into one value and then disintegrate back into two - Hi, I may not be the first one to ask this, but I'm looking to find a way to combine two...
Max size file in BCP process - Hi Experts, We are processing huge data file's on daily process form file to SQL server using BCP command. For Example : Daily...
Wrong estimate when inserting in multiple sessions - Consider the following: 1. Create table test with int column id 2. Session A: insert 5 records, don't commit 3. Session B: insert...
SQL Server stored procedures fast in SQL but slow when called by ASP.NET - Query inside the stored procedure giving result fast (twenty seven thousand records in 2 seconds) but when i called the...
Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...
sql trigger - if value equals a certain value then insert value in another table with same value - I am quite new at these SQL Triggers so I am not sure how to approach this concept. Here is the...
AlwaysOn High Availability and Statistics - Hi All I have a 4 node AlwaysOn environment running the latest service pack but not on the latest cumulative update...
finding duplicates users - Hi, I'm trying to get the 'leaver's date' of employees who have left our organisation. However, I came across an issue...
Query Store folder not visible in SQL Server 2016 - HI all, As SQL Server 2016 category is not created so I am posting this query in SQL Server 2014 window. I...
Automation of data migration from SQL Server 2012 to Access 2013 DB - Hello, I am currently copying data from few tables in SQL Server 2012 to an Access database Via ODBC Connection. This...
Running SSIS Package in scheduled job - Hi, I'm trying to run SSIS package stored on my local PC through SQL Server Agent job , and it always fails. When...
Index Seek is costing a lot in execution plan - I've got a query that's costing me a lot during index seek. I ran the query on Database Tuning Advisor but...
I need help with SQL queries - I need query in following format CustNo , YTDSales, PreviousYearSales, MTDSales I have query Declare @StartDate date = '01-01-2018', @EndDate date = '09-30-2018' Select ,sum(SalesAmt) YTDSales...
Inserting recrods fromt the same table with an incremental value on every insert - how can we add a +1 on every insert or an update ? I have table with 3 primary keys and...
Detecting Detached Databases - I've many databases on the server I've inherited. Some are detached and rather than manually check each db to see...