FreshPrinceOfSO

less info
meta site favicon meta user | stack exchange network profile network profile
308 reputation
213
bio website jadito.us
location Chicago, IL
age 25
visits member for 9 months
seen yesterday
stats profile views 98

"I looked to my kingdom. I was finally there. To sit on my throne as the Prince of StackOverflow"

I am a SQL Server Database Programmer. My graduate research and studies are primarily involved with database models and optimization. I like to write on my blog about technical problems which I've encountered. Feedback is always welcome and appreciated.

I'm a Pastafarian and part of the Church of the Flying Spaghetti Monster.

Writing a question? Follow Jon Skeet's guide on how to write a good question.

Answering a question? Follow Jon Skeet's guide on how to write a good answer.


77 Actions

suggestions reviews revisions comments badges posts accepts all
Apr
24
 comment How to snapshot or version a relational database when data changes?
This question belongs on dba.se
Apr
21
 comment Simple MySQL query randomly takes forever
How do you know one doesn't already exist?
Apr
21
 comment Simple MySQL query randomly takes forever
Please update your question with the EXPLAIN and structure
Apr
17
 comment How to permanently delete a row in oracle forever
Sounds like you're trying to hide something?
Apr
17
 asked Best practice for copying tables from server to server
Apr
9
 comment mySql Relationships / Index - Checking for duplicates
An algorithm where?
Apr
9
 awarded  Teacher
Apr
9
 revised mySql Relationships / Index - Checking for duplicates
added 81 characters in body
Apr
9
 revised mySql Relationships / Index - Checking for duplicates
formatting, code, removed unncessary tags, unicorns
Apr
9
 answered mySql Relationships / Index - Checking for duplicates
Apr
9
 suggested suggested edit on mySql Relationships / Index - Checking for duplicates
Apr
9
 comment SQL Application Role access-control
This is off topic and belongs on dba.se
Apr
4
 comment SSIS keeps force changing excel source string to float
Since when is 323.2 a string?
Apr
2
 awarded  Outspoken
Mar
28
 comment Which database could handle storage of billions/trillions of records?
Is this for the NSA or something?
Mar
26
 comment InnoDB best index practises
Your best bet would be to evaluate the queries that are being performed and create (possibly composite) indexes best on high traffic queries.
Mar
22
 comment MySQL - run SELECT statement on another server without defining the table structure
possible duplicate of How to create linked server MySQL
Mar
21
 comment Does MySQL Replication hamper the performance of my DB?
It does but the question has more to do with DBA then software development.
Mar
21
 comment Does MySQL Replication hamper the performance of my DB?
This is not appropriate for StackOverflow and belongs on dba.se.
Mar
20
 awarded  Autobiographer
1 2 3 4