Gennady Vanin Novosibirsk

less info
276 reputation
19
bio website
location Novosibirsk, Russia (Новосибирск, Россия)
age
visits member for 2 years
seen Jan 16 at 9:02

Business Analyst,
ex-

  • programmer,
  • biz analyst,
  • Q&A developer in Test,
  • chemical cybernetics engineer,
  • scientist,
  • US patent attorney,
  • translator,
  • tourist guide,
  • traveller,
  • parachuter,
  • tennis player,
  • futebolista,
  • military officer
  • etc.

Apr
14
awarded  Popular Question
Jan
16
comment What are the options of reducing tempdb latency?
I can add files, as the only option available to me from all, and probably I, in hurry, have forgotten to specifically ask from the very beginning if this is an option in context of having SQL Server in a virtual machine as one of many - all of servers in each of regional offices are in VMs on the same, single, physical device with a single/the-same RAID)
Jan
16
comment What are the options of reducing tempdb latency?
@Aaron-Bertrand, thanks for helpful references
Jan
16
comment What are the options of reducing tempdb latency?
I cannot tune indexes, they are governed and overriden by application platform (translating app's code into its own internal/gibberish T-SQL) and app code+configuration which are out of my reach even for reading.
Jan
16
comment What are the options of reducing tempdb latency?
This is the only option available to me. Hope it was clear from the question. Anyway, it is correct for me, might be different for others
Jan
14
accepted What are the compelling resons to update SQL Server name to a real one after its changing?
Jan
14
comment What are the compelling resons to update SQL Server name to a real one after its changing?
The main problem is in down-time since, it requires restarting the instances and the fear of unforeseen consequences
Jan
13
comment What are the options of reducing tempdb latency?
Thanks but these options are out of my reach
Jan
13
asked What are the options of reducing tempdb latency?
Jan
13
asked What are the compelling resons to update SQL Server name to a real one after its changing?
Jan
13
comment Changing Domain on SQL Server
+1 for RTFM link but you are not correct. My SQL Servers 2012 SELECT @@SERVERNAME (as well as sys.servers) return: 1)old machine name (the one before renaming); 2)name without domain name. And all work for years. Actually "my" SQL servers recognize new server name for all purposes and fail to recognize the old one though the SQL Server metada has not been updated and return the old namу (and for quite a time)
Jan
13
answered What port is used by SQL Server to write backups to a remote server?
Dec
27
revised How, when and why does implicit changing of transaction isolation level happen?
edited title
Dec
27
asked How, when and why does implicit changing of transaction isolation level happen?
Dec
27
comment Does DBA need (a read) access to virtualization infrastructure? And why?
I cannot use the argument:"what are the system admins trying to hide from you?". It will not faciltate, resolve, prove anything or convince anybody
Dec
27
comment Does DBA need (a read) access to virtualization infrastructure? And why?
Thanks, but I cannot tell anybody "they wasted money" on something I've never seen and a priori having less knowledge and exp on than those who mounted it (virtualization infrastructure)
Dec
27
awarded  Yearling
Dec
26
revised Does DBA need (a read) access to virtualization infrastructure? And why?
added 634 characters in body
Dec
26
asked Does DBA need (a read) access to virtualization infrastructure? And why?
Nov
11
accepted SQL Server Facets: “Linked Server” exist but “Registered Server” doesn't - why?