Reputation
450
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 21
Newest
 Benefactor
Impact
~34k people reached

Mar
30
comment Should an OFFLINE database be SET EMERGENCY before dropping?
If you revoke connections for the database, and you need to bring it back online you would need to restore those connections. If I am not the one on call in the middle of the night when the application owner suddenly realizes they were wrong about not needing that database.... Well the on-call person is going to need to call and wake me up, so I can tell them all the things they need to undo, or so I can fix them. Online vs offline with no changes, is an easy recovery.
Mar
28
asked Should an OFFLINE database be SET EMERGENCY before dropping?
Mar
22
accepted What is a Forest?
Mar
21
asked What is a Forest?
Mar
16
awarded  Benefactor
Mar
15
awarded  Promoter
Mar
9
accepted Retire a SQL instance without impacting the primary server?
Mar
9
asked Retire a SQL instance without impacting the primary server?
Mar
8
awarded  Enthusiast
Mar
3
comment How unique does AUDIT_GUID need to be when creating a server audit?
@ShawnMelton where do you see "there is no reason to use the AUDIT_GUID unless you are setting it up for mirrored ", the quote in the question says it has be the same on mirrored databases, but it does not say it is only required for mirrored databases.
Mar
3
revised How unique does AUDIT_GUID need to be when creating a server audit?
added 5 characters in body
Mar
3
asked How unique does AUDIT_GUID need to be when creating a server audit?
Feb
24
asked Maximum Server Memory adjust in blocks of 1024MB?
Feb
23
accepted How to find the max date stamp in a database?
Feb
23
comment How to find the max date stamp in a database?
Perfect, answer accepted. I will put it through it's paces on some of our old stuff.
Feb
23
comment How to find the max date stamp in a database?
I just practicing against adventure works, returning the output query quickly and runs or fails quickly I get messages like Msg 4104, Level 16, State 1, Line 27 The multi-part identifier "Emp.StartDate" could not be bound. I am putting returns prior to each UNION SELECT and narrowing down where the issue occurs.
Feb
23
comment How to find the max date stamp in a database?
In theory there is not limit to unions, stackoverflow.com/questions/6676970/… but in practice here it seems to be a problem
Feb
23
comment How to find the max date stamp in a database?
Thank you this is working great on small databases, I am playing with it, I have found that if you run the output query against a large database with many date time fields (like adventureworks) it has issues. I am playing around with how to best idenityf how where to break the query. Also you did not include the datatype 'date' in line 4 of your master query, is there a reason? I put it in for early testing and it seemed to work.
Feb
23
comment How to find the max date stamp in a database?
If it is not possible to use the datatype in the select MAX(), than the I don't see any option other than unique queries. Imagine you all the sample databases Microsoft has created, spread out on multiple servers, some are duplicated, some are not. If you can find the max date in each that will give you some guide as to when a particular database was used.
Feb
23
comment How to find the max date stamp in a database?
Portable = As database agnostic as possible. If all the dates are some length of time in the past, I can make arguments that further research is without merit. If the future event was 5 minutes ago, more research is needed. I was hoping to somehow scan through all the datetime columns in the table and only select the MAX date. I am not overly concerned with performance impact as I will have already identified the db as not currently active.