361 reputation
27
bio website ta.speot.is
location Brisbane, Australia
age 24
visits member for 3 years, 8 months
seen 16 hours ago

I try to share knowledge of the arcane on my blog - I invite you to check it out.


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
31
comment Mysql: Possible to increase the priority of your query on a database?
What does it matter, you're using MySQL. "Oh boy, a high priority query! I'd better be slow with high priority" -- actual quote from mysqld.
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
10
comment BULK INSERT in SQL
I called it.
Jun
10
comment BULK INSERT in SQL
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 in SQL
@Spandan The statement is SELECT @@VERSION - open a new query window, type that in and push Execute.
Jun
10
comment BULK INSERT in SQL
How does it fix the 'BULK' rowset provider not supported in this version of SQL Server. error?
Jun
10
comment BULK INSERT in SQL
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
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?
Oct
29
comment Query Optimizing Request
Indexing the fields individually won't help as much as creating an index whose key is all three fields, or whose key and covering columns cover the three fields.
Oct
27
comment Query Optimizing Request
The clustered index scan on materials_progress suggests to me that there are no indexes on that table is for some combination job_id, line_no or component_name_id. You might need to index those fields in materials_progress. You might also have bad statistics.
Oct
27
comment Query Optimizing Request
What is the execution plan?
Oct
24
comment Database 'MyDb' is being recovered. Waiting until recovery is finished
+1 for Auto-Close
Sep
17
comment MS Access / MySQL: unlock locked Records
It looks like Access does the locking. Related: stackoverflow.com/questions/12026199/…