Viewing 15 posts - 1 through 15 (of 14,952 total)
Since SSIS packages are just XML files, you can also generate an XML definition for the source from the metadata of the destination table, and either dynamically or with just...
May 14, 2018 at 4:12 pm
That is weird.
I tried a few things like having the ON condition include both tables, and it still worked.
Always updated from the header table, not the detail table, so I...
July 28, 2016 at 6:42 am
Reading of individual files is again done using xp_cmdShell.
After that the file is parsed into independend fields.
This involves splitting the...
July 20, 2016 at 7:41 am
There is no way to block SA from seeing the code.
Even if you keep it outside the database, a trace (extended events) or certain queries (DMVs) will show what is...
July 20, 2016 at 7:31 am
When query behavior gets that weird, the first thing I suggest is DBCC CHECKDB and make sure you don't have something going wrong with the storage.
July 19, 2016 at 10:31 am
How are you doing the CSV imports? OpenRowset? Linked servers? BCP?
For most of those, you need to have the file definition already in-place.
If you're pulling data in...
July 19, 2016 at 8:27 am
Good to know.
July 18, 2016 at 8:55 am
I don't think you can do that during an automatic failover.
I'm pretty sure I wouldn't want to try. Why risk an error that could delay or interrupt the failover...
July 18, 2016 at 8:53 am
If I understand you correctly, you have procs that create persisted (not temp) tables, and then do things with those tables. Sometimes you don't need the proc to create...
July 15, 2016 at 7:04 am
July 14, 2016 at 12:52 pm
sys.dm_os_waiting_tasks is defined at https://msdn.microsoft.com/en-us/library/ms188743.aspx
July 14, 2016 at 10:38 am
I dug into this one time, and I think the only solution I came up with was to convert the XML to VARCHAR(MAX) and do string manipulation on it. ...
July 14, 2016 at 7:39 am
You could always set up another VM, install from the same ISO onto it, and see if the same thing happens again. That would be time-consuming, but it would...
July 13, 2016 at 7:39 am
Eirikur Eiriksson (7/12/2016)
NVARCHAR won't hold RTF files, just the text. I would expect VARBINARY instead of IMAGE, for RTF files.
This is wrong, NVARCHAR and VARCHAR will hold RTF...
July 13, 2016 at 7:38 am
The example I run into most often is search engine results. What matters most is speed and relevancy, in most cases, not consistency and "completeness" (whatever that would mean...
July 13, 2016 at 7:26 am