Join Two CSV Files with a Common Column
In this example we will join two CSV files with a common column using SQL Server.
2017-01-23
5,680 reads
Files
Downloading multiple files from internet with SSIS and C#
This is a tutorial to download multiple files from internet using the SSIS Script Task.
2016-12-08
6,385 reads
Adaptative Files Autogrow
Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases
2016-01-07 (first published: 2015-06-08)
1,069 reads
UP_COMPACTA_COPIA
I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.
2011-10-17 (first published: 2011-09-30)
427 reads
RE: Build query by using function
Try this: SELECT SerialNumber, PassFail, CASE WHEN [PassFail] = 1 THE 'Pass' ELSE 'Fail' END AS Expr1 FROM TestLog (Note, this does not include any test for a NULL or any other number..., you may want to look up CASE in BOL and see if you want to include more...)
2004-12-06
Cannot import Paradox file from the Server ???
keep getting on Error messages on my package: (running on Windows Server 2000 SP4 & MS-SQL 2000 SP3)Context:Error calling open rowset on the provider... Error Source: Microsoft OLE DB Provider for ODBC Drivers funny... but it works fine from my Workstation (XP pro SP-1)any suggestion guys ?? thx for the attention
2004-11-28
29 reads
RE: SQL Server 2000 - backupfile space allocation problem in msdb
Hi,as soon as you get the database to online, you couls use the undocumented proceduressp_delete_backuphistoryorsp_delete_backup_and_restore_historyto truncate your backup history...regards karl
2004-09-09
RE: Torn Page Error - Error: 823, Severity: 24, State: 2
Hi Dave,You do have an interesting issue. I would certainly be concerned over the integrity of your data. The first thing is to preserve as much of your data as possible, I would recommend BCPing all your data out to text files and store these in a safe place.Next you should have a look at the […]
2004-07-20
RE: SMTP Configuration - Need Help
Find out from your system or mail administrators the name (or IP address) of your SMTP server. If you're going to use SQLMail, read through this Knowledge Base article, as it presents a reasonable coverage of how to setup SQLMail: http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556 If you're going to use SMTP without using SQLMail and you want to mail […]
2003-08-24
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers