1,999 reputation
311
bio website
location The Netherlands
age
visits member for 2 years, 3 months
seen Oct 2 at 20:25

Aug
27
awarded  Yearling
Feb
11
awarded  sql-server
Feb
7
answered Is it possible to restrict SQL Server DB_Owner when connecting using SQL Server Mgt Studio?
Feb
6
comment AlwaysOn Availability Groups Delayed Replica
@AaronBertrand no you no longer are ;-). Thanks for making me aware of this feature request!
Jan
30
answered SQL Server 2008 RC2 Edit transaction Log
Jan
30
comment SQL Server 2008 RC2 Edit transaction Log
If I understand your question correctly it's: Forget about the failed restore intro, just focus on how to undo a transaction by using info from the current T-log right? what did the transaction do?
Jan
30
comment SQL Server - Copy data from one database to another - identical tables, new identity values needed
do you have foreign key constraints in place and how are they setup?
Jan
30
answered sp_setapprole and creating users / logins
Jan
28
comment Backup is getting failed with following error
most likely memory related within Windows SMB. see support.microsoft.com/kb/304101
Jan
24
comment SQL Server 2008 R2 Restore constantly hanging
Can you rule out SQL Server by just copying a large file from the same location as the backup files to the same location as the mdf and ldf files. (and if these mdf and lfd are on different disks, just perform the test two times..)
Jan
24
comment SQL Server 2008 R2 Restore constantly hanging
does the SQL Service account have "perform volume maintenance tasks" permissions and when you start the restore, are the mdf and ldf files of the database that you are restoring the database over a representative size? or do they need to grow a lot before the backup that you are trying to restore "fits" ?
Jan
24
comment SQL Server 2008 R2 Restore constantly hanging
can you post: The script used to create the backup. The script used to restore the backup and the waitstats of the server while it has been hanging for a long time. with for example this script: sqlskills.com/blogs/paul/…
Jan
24
comment Cannot read property Collation.This property is not available on SQL Server 7.0
As suprising as it might be, but I think I found a duplicate: stackoverflow.com/questions/11635539/…
Jan
24
comment Session hanging with TM REQUEST and plan handle 0x0000
Is the mirror choking on the load? is it STND or ENT Edition. (1 vs multiple redo threads). Can you relate the incidents to preceding bursts of hi transactional load? For example does it happen after/during maintenance?
Jan
24
comment What causes lost updates being observed in my SQL Azure database?
Thanks for posting the update!. Be careful that since SQL Azure runs in read commited snapshot your SELECT UserId, AvailableMoney, dbo.ufn_ComputeNewBalance(some params) FROM UserBalances WHERE SomeIncorrectConditionHere might select unintended 'old' data from UserBalances that is in the middle of a transaction from '[dbo].[usp_ChangeUserBalance]'
Jan
24
comment What causes lost updates being observed in my SQL Azure database?
@sharptooth. just seconds? or also miliseconds? If the time column of those duplicate records is identical it would indicate that the problem is somewhere within the same procedure doing multiple inserts? If it was a transaction isolation/concurrency issue between two instances of the stored procedure running at the same time, the [time] column would most likely have slightly different values for each duplicate record, right?
Jan
18
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
@MartinSmith I like the extra detail about why it actually estimated the scan on 20%.
Jan
17
comment T-SQL - Enforce Atomic Operations x Locks
@Tiziani If my solution solves your issue remains to be seen. Please post your table definition including indexes and keys, the where clause and explain how you want to update the balance table?
Jan
17
revised T-SQL - Enforce Atomic Operations x Locks
added 525 characters in body
Jan
17
answered T-SQL - Enforce Atomic Operations x Locks