Shane Wealti

less info
meta site favicon meta user | stack exchange network profile network profile
157 reputation
16
bio website dane101.com
location Columbus, OH
age 35
visits member for 1 year, 9 months
seen yesterday
stats profile views 4

19 Actions

suggestions reviews revisions comments badges posts accepts all
Apr
3
 awarded  Notable Question
Dec
22
 accepted How do I troubleshoot loss of connection with SQL server
Nov
27
 awarded  Popular Question
Aug
14
 comment What is a good way to query data stored in multiple identical tables split by date/time
That is an interesting idea. So I would put row insert triggers on all the tables and insert added rows into the consolidated table which can be queried in a more standard way. I think I'm going to give this a try, assuming I have enough storage space to have two copies of all data.
Aug
14
 comment What is a good way to query data stored in multiple identical tables split by date/time
@Jon Seigel - Yes, the table roll over time may fall within a day so the first part of August 20th may be in one table and then it might roll over and add data from August 21 in that same table.
Aug
13
 asked What is a good way to query data stored in multiple identical tables split by date/time
Apr
17
 awarded  Editor
Apr
17
 revised How do I troubleshoot loss of connection with SQL server
added 427 characters in body
Apr
16
 asked How do I troubleshoot loss of connection with SQL server
Feb
28
 accepted Is there a restriction which prevents you from creating a user and a role with the same name?
Feb
28
 comment Is there a restriction which prevents you from creating a user and a role with the same name?
I figured that was it but I couldn't find any documentation confirming it. Please put your comment as an answer and I'll accept it. I didn't know where it stores that information and I just assumed roles would be stored separate from the users but now I know better.
Feb
28
 asked Is there a restriction which prevents you from creating a user and a role with the same name?
Sep
28
 awarded  Citizen Patrol
Aug
25
 awarded  Supporter
Aug
25
 awarded  Scholar
Aug
25
 accepted When you select from a table on an indexed column and order by that column in the opposite direction of the index, does the index help
Aug
25
 comment When you select from a table on an indexed column and order by that column in the opposite direction of the index, does the index help
For my specific problem Oracle, but I am also interested in other engine specific answers.
Aug
25
 awarded  Student
Aug
25
 asked When you select from a table on an indexed column and order by that column in the opposite direction of the index, does the index help