925 reputation
418
bio website
location Minneapolis, MN
age 27
visits member for 1 year, 8 months
seen yesterday

I'm a database architect/administrator specializing in Business Intelligence out of MSP.


2d
comment Using #temp to work around Reporting Services blocking issue
I'd like to get some more information on this blocking issue since that is the root issue.
2d
comment Is it possible to get the queries executed in the past?
Are you asking for a list of most recently run queries?
Apr
14
awarded  Informed
Apr
11
comment SMS Suggesting covering all columns in an index?
You're worries are certainly legitimate. It the current runtime of this query problematic?
Apr
11
comment SMS Suggesting covering all columns in an index?
Alright that makes sense. The reason it's suggesting this is it would indeed benefit the query to have all of those extra columns included. If you were not doing a SELECT * it would only give you the columns you are selecting. Creating this will make the query you are running faster. However it is less likely to benefit other queries as well. You also need to keep in mind the additional overhead that an index has.
Apr
11
comment SMS Suggesting covering all columns in an index?
I think we need to see the query. The suggestions SSMS gives you should probably be just considered a starting point as they are very specifically suggested for that query. Even then you can usually make something more efficient yourself.
Apr
11
comment “Cannot insert the value NULL”, but there is no NULL values!
Bad advice. Even if Microsoft wasn't planning on obliterating that feature it's important to handle NULL properly.
Apr
10
comment Deadlock when update different rows with non-clustered index
Can you please elaborate or clarify this "And I have understand that without index, the update will acquire update lock for all the rows and covert to exclusive lock when necessary, which will eventually leads to deadlock. But I fail to find out why with clustered index, the deadlock is still there (though hit rate seems to be dropped)"
Apr
4
comment Import 10 Billion Rows, Daily
Do you have a batch limit to the amount of rows being inserted at a time or is your system overflowing it's buffer pool?
Apr
3
revised MySQL Rows to Columns to HBase (using Sqoop)
I don't like scrolling.
Apr
3
suggested suggested edit on MySQL Rows to Columns to HBase (using Sqoop)
Mar
31
comment How το find last time database was accessed and the inventory of all application and users accessing it?
HOW CAN I FIND LAST TIME DATABASE WAS ACCESSED!!!!!!!! AHHHH!!!!
Mar
27
comment Inserting a 30 million row table from a linked server
Or an average of your nightly inserts?
Mar
27
comment Inserting a 30 million row table from a linked server
Another question what's the volume of nightly inserts?
Mar
27
comment Inserting a 30 million row table from a linked server
If backing up isn't an option why not use SSIS? This looks like a perfect case for using an SSIS look-up/insert method. I can build you a demo if you'd like.
Mar
27
awarded  Popular Question
Mar
21
comment How to repair .mdf file?
+1 for necessary disclaimer.
Mar
19
answered copy/sync only data between 2 database with non identical table structure
Mar
18
comment copy/sync only data between 2 database with non identical table structure
Okay Give me some time I'll build you an SSIS tutorial.
Mar
14
comment “Ranking” values in an ORDER BY clause?
Great first question. Very high quality. Color me impressed.