Viewing 15 posts - 3,691 through 3,705 (of 6,041 total)
It would be helpful if there were a way to alter an index such that it would still be maintained by DML operations but ignored by SQL queries. That way...
July 7, 2015 at 11:35 am
ZZartin (7/7/2015)
July 7, 2015 at 9:34 am
When presented with what appears to be an impossible challenge; more often than not it's because the task is misunderstood by the developer, the requirements have not been properly defined,...
July 7, 2015 at 8:42 am
quagmired (7/6/2015)
Eric M Russell (7/6/2015)
Where I work, we use TAB delimited files, so that's why I'm not familiar with the annoywances regarding the CSV file format and embedded commas.
What about...
July 7, 2015 at 8:25 am
Where I work, we use TAB delimited files, so that's why I'm not familiar with the annoywances regarding the CSV file format and embedded commas.
SSIS is definately not intended for...
July 6, 2015 at 12:52 pm
chrisn-585491 (7/6/2015)
The only compelling arguments presented, the ones that should be cringeworthy for the Marketing department at Microsoft, are that unlike SQL Server, PostgresSQL is cross-platform, and you can acquire...
July 6, 2015 at 8:51 am
chrisn-585491 (7/3/2015)
Now if they would just nuke SSIS from orbit. Millions of man hours lost to its quirks...
Working with SSIS is a lot like hiking through the jungle; simply striking...
July 6, 2015 at 8:09 am
Comparing computer languages is a lot like comparing any other type of language. If you're ever at a bar with a group of spanish speaking friends, and want to spark...
July 6, 2015 at 7:58 am
The referenced blog post was clearly written by someone who primarily works with PostgresSQL but occasionally has to context switch to SQL Server. The arugments that PostgresSQL has better documentation,...
July 6, 2015 at 7:46 am
I've been using VirtualBox. You can simulate a networked environment by having multiple virtual machines running with virtual networking between them, one can be setup as the domain controller, and...
July 2, 2015 at 11:59 am
Dropping the ball on an IT deliverable is somewhat stressful. It can ruin your day or your week, but it's not exactly the type of thing that sticks with you...
July 2, 2015 at 11:16 am
Steve Jones - SSC Editor (7/2/2015)
Eric M Russell (7/2/2015)
July 2, 2015 at 9:11 am
If the default trace is enabled (which is should be), then that can be used to query DDL events, including more information about the session and user than what the...
July 2, 2015 at 8:46 am
Maybe BI developers who use SSIS and SSRS daily have a different perspective, but as someone in Dev/Ops who spends most of my time coding T-SQL in tandem with DBA...
July 2, 2015 at 7:05 am
I think that any young person who has an opporunity to attend university should. However, simply getting an acceptance letter along with an approval for up to $200,000 in loans...
July 1, 2015 at 3:40 pm
Viewing 15 posts - 3,691 through 3,705 (of 6,041 total)