5,712 reputation
1821
bio website lobsterpot.com.au
location Adelaide, Australia
age 40
visits member for 3 years, 5 months
seen 6 hours ago

Owner / Principal at LobsterPot Solutions

Adelaide (Australia) based SQL MVP

On twitter @rob_farley

Blog at http://sqlblog.com/blogs/rob_farley
(Old blog at http://msmvps.com/blogs/robfarley)


2d
comment RAID10 vs. RAID5 for data files
Yup, I agree with what you write, Mark.
2d
answered RAID10 vs. RAID5 for data files
Mar
20
revised Best way to automatically reset sequence/identity once a year
added 41 characters in body
Mar
20
answered Best way to automatically reset sequence/identity once a year
Mar
15
comment Get object script in SQL Server via T-SQL?
Yup, Event Notifications do the trick too. :)
Mar
15
comment Get object script in SQL Server via T-SQL?
If you store every CREATE, ALTER, DROP, then you will have the full history, including the latest versions. See more at mssqltips.com/sqlservertip/2085/…
Mar
15
answered Searching from the latest date in SQL Server
Mar
14
answered Get object script in SQL Server via T-SQL?
Mar
13
comment Is Policy-Based Management dead? Is it scalable?
I consider PBM to be more alive than MDW, but I don't consider that MDW is dead either. I don't see it disappearing any time soon, and it's a useful system for people who don't have third party alternatives.
Mar
11
answered Is it a good idea to create an index for each column in a new table?
Mar
9
answered Referencing a single table from all tables in the database
Mar
8
answered Is Policy-Based Management dead? Is it scalable?
Mar
8
answered Sporadic execution time causing timeouts
Mar
3
answered How to check if Alter view/stored proc script has run successfully
Mar
1
reviewed Edit Cannot SUM datetime field in SQL Server migrated from Access
Mar
1
revised Cannot SUM datetime field in SQL Server migrated from Access
Added example code
Mar
1
answered Cannot SUM datetime field in SQL Server migrated from Access
Feb
26
revised Create database unique Surrogate Keys without using GUID’s
added 73 characters in body
Feb
26
answered Create database unique Surrogate Keys without using GUID’s
Feb
24
comment Truncating table without using Alter Table permission
Truncating a heap will free up the space better than just deleting the rows.