Reputation
381
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 7
Newest
 Enlightened
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Apr
27
comment SQL Server to MySQL data transfer using Talend Open Studio - recent performance drop
I don't think MySQL has any good bulk insert interface that doesn't involve putting a file on the server and importing the CSV. Well, MySQL doesn't have a lot of good things. Probably best to just stick to SQL Server.
Dec
13
comment How do i Optimize/Improve ram while running a massive import into sql server
The first upload failed at about 38 million Upload what? Are you using SSIS, SqlBulkCopy, why aren't you backing up and restoring?
Nov
25
comment SQL Server 2012 Express with Reporting Services
I think you just "add to existing" and select reporting services. Hopefully relevant screenshots: blogs.lessthandot.com/media/users/koenverbeeck/SP2013DemoEnv/… blogs.lessthandot.com/media/users/koenverbeeck/SP2013DemoEnv/…
Nov
2
comment How to auto start instance of sql server 2012 localdb on startup?
Install SQL Server 2012 non-LocalDB.
Oct
16
awarded  Enlightened
Oct
16
awarded  Nice Answer
Sep
14
comment Restore failed for server (Microsoft.SqlServer.SmoExtended)
It means that you haven't tested your backup and restore strategy recently.
Sep
8
comment How to design a table that each rows have 5K boolean attributes?
You want an EAV model.
Aug
2
comment Describe Interim Table and Basic Concept behind it?
According to the first result on Google... blog.sqlauthority.com/2009/06/04/…
Jun
11
awarded  Critic
Jun
10
comment BULK INSERT not supported
I called it.
Jun
10
comment BULK INSERT not supported
What was the point of Googling to discover that BULK INSERT is supported by SQL Server 2008? You're not using SQL Server 2008.
Jun
10
comment BULK INSERT not supported
@Spandan The statement is SELECT @@VERSION - open a new query window, type that in and push Execute.
Jun
10
answered BULK INSERT not supported
Jun
10
comment BULK INSERT not supported
How does it fix the 'BULK' rowset provider not supported in this version of SQL Server. error?
Jun
10
comment BULK INSERT not supported
Apparently BULK INSERT isn't supported on SQL Azure.
Jun
10
comment adding ORDER BY decreases speed by 15x
@OnoSendai That's not how IN works. sqlfiddle.com/#!2/4f5de/1/0
Jun
10
answered adding ORDER BY decreases speed by 15x
Apr
23
comment How to enhance the SQL query performance for thousands and millions of huge data
You have more than one huge datas? I think you need MongoDB, I hear it's web-scale.
Jan
26
comment Index included columns
There's a difference, in your query SQL Server has to do much more work when inserting, updating and deleting data because it has to order by three columns instead of one. Timestamp by itself might be selective enough to filter out 90% of the results, how much data do you change?