2,230 reputation
916
bio website Nope
location Israel
age 40
visits member for 3 years
seen Dec 10 at 5:07

@ Sql Server since 2000


Nov
30
awarded  Enlightened
Nov
30
awarded  Nice Answer
Nov
22
comment When to add indexes to #temp tables?
@ErikDekker You can specify which type of index will be created for constraint
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