2,180 reputation
815
bio website Nope
location Israel
age 39
visits member for 2 years, 8 months
seen Aug 22 at 5:29

@ Sql Server since 2000


Aug
22
comment When to add indexes to #temp tables?
@ErikDekker Creating some constraints means creating indices also
Aug
7
awarded  Notable Question
Dec
19
awarded  Yearling
Jul
24
awarded  Necromancer
Jul
24
revised SQL Server Frozen Ghost Cleanup workaround needed
added 1 characters in body
Jul
11
comment MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM?
Dear anonymous downvoters - please, write the reason of downvote, be fair
Jul
10
revised SQL Server Frozen Ghost Cleanup workaround needed
edited body
Jul
10
awarded  Self-Learner
Jul
10
accepted SQL Server Frozen Ghost Cleanup workaround needed
Jul
10
answered SQL Server Frozen Ghost Cleanup workaround needed
Jul
10
comment SQL Server Frozen Ghost Cleanup workaround needed
@MarkStorey-Smith Oh, yes - the MS is recognized it as a bug. It is exists up to sql 2008 R2. support.microsoft.com/kb/2622823
Jul
10
comment SQL Server Frozen Ghost Cleanup workaround needed
@MarkStorey-Smith No, regarding the issue - the MS support offered us with a free expertise and upgrade to sql2012. So we moved to sql2012Ent SP1 about a year ago. Since then the issue was not observed yet.
May
28
awarded  Constituent
May
19
awarded  Caucus
Feb
18
awarded  Popular Question
Jan
20
comment tempdb objects creator wanted, bufferpool issue caused by tempdb objects
@MartinSmith Thanks for useful function! But unfortunately there is no any info left in the log. Updated question with the groupings
Jan
20
revised tempdb objects creator wanted, bufferpool issue caused by tempdb objects
added 10214 characters in body
Jan
20
revised tempdb objects creator wanted, bufferpool issue caused by tempdb objects
added 1540 characters in body
Jan
20
comment tempdb objects creator wanted, bufferpool issue caused by tempdb objects
@MartinSmith Tried to fulfil the question with related data
Jan
20
revised tempdb objects creator wanted, bufferpool issue caused by tempdb objects
added 2675 characters in body