121 reputation
14
bio website streetadvisor.com
location Melbourne, Australia
age 39
visits member for 3 years, 8 months
seen Oct 15 at 21:41

Just another djork trying to ply his art in this mad mad world.


May
3
awarded  Notable Question
Jul
30
awarded  Popular Question
Feb
17
comment Is there a more helpful way to detect lock acquire/release stats in SQL Profiler?
@RemusRusanu Remus, I think RPM1984 is suggesting that the big-evil-EF-query has now been replaced by a stored procedure? (so that would suggest, it's doing the same thing .. but just a bit more efficiently). You also said that the proper solution should be to leverage proper Indexes. How would this help? Would that be because the index would know what records to -exactly- lock? instead of pages or even the entire table?
Feb
17
comment Is there a more helpful way to detect lock acquire/release stats in SQL Profiler?
@RemusRusanu Balltastic post! I definitely going to watching the commentary here to see how this gets resolved. Very helpful indeed!
Sep
8
comment How can I backup & restore a single FILEGROUP in Sql Server 2008
So if i have a script that does these 2 backups, would i backup the FILEGROUP first, then the LOG ... zip the two files together .. download .. restore FILEGROUP then LOG <--- in that order?
Sep
8
comment How can I backup & restore a single FILEGROUP in Sql Server 2008
@AHh .. so i need two more scripts. one to back up the FILEGROUP .. and now one to backup the logs. Then restore both. That's what you're saying, now? If so, any hints to the BACKUP LOG script?
Sep
8
comment How can I backup & restore a single FILEGROUP in Sql Server 2008
Hi Denny - thanks for the reply :) But I still don't understand blush :( So first up, my backup and restore syntax looks fine. Tick. But .. i need to also restore tx logs? but aren't those inside my PRIMARY filegroup? I'm not sure what I need to do (syntax wise) to ALSO backup the logs and then restore them into the db... ??
Sep
8
awarded  Student
Sep
8
comment How can I backup & restore a single FILEGROUP in Sql Server 2008
So why do they offer FILEGROUP backups if you need to do a full restore anyways? A full restore == a database backup, then restore? Maybe I've misunderstood your answer. I don't mind grabbing a NEW FILEGROUP backup and restoring, if i've done something wrong in my backup step.
Sep
8
asked How can I backup & restore a single FILEGROUP in Sql Server 2008
Mar
17
awarded  Autobiographer
Mar
17
awarded  Supporter