Welsh Corgi (6/8/2016)

---

I am getting a Primary Key Violation when Loading a Table.

I queried the source table and there is only one record with value of the primary key.

This does...

There's no difference ETL wise.

having SPARSE columns lets SQL optimize for mostly null values, and that's under the hood, albeit potentially a bit slower.

I think of sparse columns the same...

I found this interesting, so i duplicated your issue.

I created a couple of server triggers, backed up master and restored it as a new name [masterbackup]

even though i've connecting via...

also, check your schema changes history. if not too much time has occurred, the definition might still be in the default trace.

Sure, its part of a scripti share here that checks for all invalid objects. It triesto recompile procs, functions and views.

sp_InvalidObects.txt

yes, but it's TWO tables that are affected. you want to truncate both parameters and events. i think it might require a DELETE, as i think there is a foreign...

tiny tables.

small tables will not benefit from reindexing. only your large tables.

offhand, i think it's 1000 rows or less don't get any fragmentation benefit/results from reindexing, but we could look...

i've done something similar.

i use sys.views and not information schemas; there's a LOT of information missing in those compatiblity views, so i avoid them like the plague.

select

'exec...

i've had to address the same problem.

McAfee usually installs on an instance of SQL Express which has a hard internal limit of ten gig on the database;

available disk space will...

TexasJohn (6/7/2016)

---

For Access I went back to my original setup.

exec sp_addlinkedserver @server=N'AccessSchedule'

,@srvproduct=N''

,@provider=N'Schedule'

,@datasrc=N'LocalServer'

exec sp_addlinkedsrvlogin AccessSchedule,False,NULL,Admin,NULL

Where Schedule is the name of a DSN file on the SQL server

Now when I run

exec...

jerking my chain or is that new in 2016?

i tried 2008/2012/2014 and below with no luck.

;WITH MyCTE([path])

AS

(

SELECT 'c:\Programmefiles\Dicument\file1.txt' UNION ALL

SELECT 'c:\Programmefiles\Dicument\Subdocument\file1.txt' UNION ALL

SELECT 'c:\Programmefiles\Dicument\Image\file1.txt' UNION...

since you've set up teh DSN and the linked server, do you get a list of tables from this command that you could then query?

exec sp_tables_ex [AccessSchedule]

you get results that...

is the datatype of the source CHAR/NCHAR and not varchar/nvarchar?

exporting char values maintains their defined length.

you'd probably want...

how does whitespace wreck the import?

importing a csv is fairly straight forward;

you could bulk insert directly to a staging table, and trim the data before it inserts into the permanent...

DennisPost (6/6/2016)

---

Hi Lowell,

Thanks for taking the time to read and reply.

That approach won't work for us as the server is set to UTC and we need to be able to...