SQL Server : how to find startup parameters for t272 -

-

for people know stuff identity field skipping 1,000 reason concern? know microsoft has done on purpose sql server 2012 want make sure issue won't arise in future because of identity fields being large, i'm thinking of adding t272 not know how big of performance hit might

i have sql server 2012 , trying locate 'startup parameters' can add t272 stop primary key skipping described on thread identity column value jumps 1001 in sql server if @ picture below not see option startup parameters

my sql management

this right here how supposed look; anyways can screen 1 below??

enter image description here

take these steps:

  1. open "sql server configuration manager"
  2. click "sql server services" on left pane
  3. right-click on sql server instance name on right pane -> default: sql server (mssqlserver)
  4. click "properties"
  5. click "startup parameters"
  6. on "specify startup parameter" textbox; type "-t272"
  7. click "add"
  8. confirm changes

Comments

Post a Comment

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

-
i plot number of emails in inbox on time using gmail api , i'm seeing lot of drop-outs, whatever reason i'm getting incomplete count of messages @ single time points. my plots here: https://plot.ly/~tdsmith/2 -- "drop-outs" i'm complaining trace shoots downwards , recovers previous level @ next timepoint. the code i'm using count emails here: https://github.com/tdsmith/gmail-plotly/blob/master/gmail-plotly.py#l47-l64 what can diagnose these faults?
Read more

Installing Android SQLite Asset Helper -

-
i need use ready made database. search solution on internet did not work until decided use mentioned library found here . however, found hard use library in installation procedures shallow beginners. i appreciate step step procedure on how use android studio. in struggle tried copying sources main/libs , adding line gradle did not work. use api 19 if helps. update here build.gradle // top-level build file can add configuration options common sub-projects/modules. buildscript { repositories { mavencentral() } dependencies { classpath 'com.android.tools.build:gradle:0.11.+' compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' // note: not place application dependencies here; belong // in individual module build.gradle files } } allprojects { repositories { mavencentral() } } trying compile project error error:(9, 0) no signature of method: org.gradle.api.internal.artifacts
Read more

Qt Creator - Searching files with Locator including folder -

-
one quick question qtcreator : know possible use locator open files using "ctrl-k" shortcut. however, possible search files including locations? for example, let's want locate file named "main.cpp" in folder named "myfolder" , have lots of other main.cpp files. what should type locator in order open ? just type myfolder/main.cpp in locator
Read more