191 reputation
17
bio website dane101.com
location Columbus, OH
age 35
visits member for 2 years, 8 months
seen Apr 3 at 21:16

Apr
2
accepted Are there any third party tools that can read and/or analyze SQL Profiler trace (.trc) files
Apr
2
awarded  Popular Question
Feb
17
answered Increasing time-out period for schema compare (windows server 2008, Sql Server 2008 R2 and VS2012)
Dec
3
comment What are all these databases with funny names?
Can we flag it to be migrated there?
Dec
2
accepted What are all these databases with funny names?
Dec
2
comment What are all these databases with funny names?
Thanks thats what I was looking for. I knew from the names what each database was but I was missing the part about the GUID. Makes sense now.
Dec
2
asked What are all these databases with funny names?
Aug
19
asked How to troubleshoot db/app latency during transaction log backup
Jul
24
asked Are there any third party tools that can read and/or analyze SQL Profiler trace (.trc) files
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.