178 reputation
115
bio website
location United Kingdom
age
visits member for 2 years, 9 months
seen Apr 15 at 16:29

Mar
19
comment How to audit all activity for a Windows Group in SQL Server 2012/2014?
This is being forced on me. No the DBA Team is not trusted.
Mar
19
asked How to audit all activity for a Windows Group in SQL Server 2012/2014?
Mar
12
awarded  Famous Question
Aug
29
comment How to shut down clustered SQL Server 2008 R2 with NOWAIT?
@James not true. A graceful shutdown WAITS for the transaction to finish before shutting down. SHUTDOWN WITH NOWAIT does not wait :) (clue is in the name of the command) so any active transactions will be rolled back.
Aug
28
comment How to shut down clustered SQL Server 2008 R2 with NOWAIT?
I've done some testing on this and discovered that SQL Server in a cluster ALWAYS does a SHUTDOWN WITH NOWAIT. Interesting, in that you CAN'T do a graceful shutdown on a cluster. Kind of surprised me... And if you don't believe me test it yourself. BEGIN TRAN, change some data and then take your SQL Server service offline in cluster manager. Start up and see if your transaction is there...
Aug
28
asked How to shut down clustered SQL Server 2008 R2 with NOWAIT?
Jul
31
awarded  Notable Question
May
21
awarded  Popular Question
Jul
6
accepted Does it make sense to consolidate Oracle databases?
Jul
5
comment Does it make sense to consolidate Oracle databases?
Thanks Phil, could you elaborate Option 1 a little more? Do I need to use Oracle RAC or Oracle RAC One Node to achieve this? Once migrated to the consolidated server, would each instance map to each database, or do I need to fold all the databases into one with different schemas? I guess my confusion lies in what an "Oracle Database" is.
Jul
5
asked Does it make sense to consolidate Oracle databases?
Apr
2
awarded  Teacher
Jan
3
answered SQL Server 2008 Failover cluster
Jul
6
awarded  Student
Jul
5
awarded  Scholar
Jul
5
awarded  Supporter
Jul
5
accepted How do I declare and use variables in Oracle?
Jul
5
comment How do I declare and use variables in Oracle?
Thanks for the links, useful.
Jul
5
comment How do I declare and use variables in Oracle?
Thanks, how do I use the variable in a query? Would I do select * from myTable where START_DATE > startDate;?
Jul
5
asked How do I declare and use variables in Oracle?