I'm using SSMS 2014 to fetch data from Progress OpenEdge 10.2B via ODBC, and dealing with OpenEdge's overstuffing of its datatypes is a constant challenge. The only way I've found to see what size my fields need to be is to use the SQL Server Import and Export Wizard. When it detects the field le...

I have a bunch of tables replicated from my_publisher to my_subscriber via my_distributor. Some of these tables, not all of them, when updated on my_publisher, take a couple of hours to be updated on my_distributor. All these tables belong to the same publication. What could be a way to troubl...

Here's the trigger causing the problem: USE [SalesDb] GO /****** Object: Trigger [dbo].[trgAfterUpdate] Script Date: 7/16/2015 6:34:01 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[trgAfterUpdate] ON [SalesDb].[dbo].[Article] FOR UPDATE AS select a.id...

I'm unfortunately well aware from many questions asked previously that SQL Server Compact 4 can no longer be opened as an object in SQL Server 2014 Management Studio. However I can't find any definitive information on whether or not I can add Microsoft.SQLSERVER.CE.OLEDB.4.0 as a provider in SQL...

I am attempting to design a table via the right click menu on the table After I choose design I immediately get this error Object reference not set to an instance of an object (SQLEditors) I have ran the repair options 3 times now with no complaints from the repair tool under installat...

I am using SQL Server Migration Assistant (SSMA). I have a field that is a (signed) double in MySQL, and I want it to be a decimal(18,4) in SQL Server. I have changed the Type Mapping for Source Types double and double precision to decimal(18,4) in the TargetType column (and clicked apply) in t...

I have a number of tables with exactly 1000 partitions. Each table can be up to 200G with 100M rows and cannot be compressed. Data in partitions distributed quite equally. The SQL Server has 8 cores. There are a number of options to spread this information across files and file groups. singl...

I currently have websites running on SQL Server 2008 R2 - this is the version I also have installed on my own machine. I'm looking at moving my websites to a different provider, however they only run SQL Server 2014. As it's a managed service, I've had very little to do with the installation on ...

We have a nightly SSIS job which downloads data from a Vendor's Oracle system into our SQL Server 2014 system using Oracle's Wallet. On some tables, we've noticed that some VarChar columns have the last character truncated. This appears randomly in some rows, and happens without any errors being...