andyhky + sql   105

StarInix Corporation
Database Compare 2.0 just made my day. A free schema diff tool.
Bookmarks  sql  schemadiff  diff  database  dba  tools  free  tool  freeware  compare 
august 2009 by andyhky
Ranking Functions (Transact-SQL)
This is awesome, I had no idea T-SQL could do this.
Bookmarks  sqlserver  dba  sql 
april 2008 by andyhky
sp_change_users_login (Transact-SQL)
This is a handy stored procedure dealing with Orphaned users.
Bookmarks  development  security  sqlserver  work  migration  login  sql  restore  tsql 
january 2008 by andyhky
Linchi Shea : Ad Hoc vs. Parameterized
On the Oracle database, by simply setting its cursor_sharing parameter to forced, the transaction throughput went up from ~1,200 per second to ~16,000 per second ... SQL Server 2005 has a similar database option called forced parameterization.
Bookmarks  performance  sql  sqlserver 
january 2008 by andyhky
SQL Agent Date & Time
Some useful functions in order to deal with SQL Server Job Agent's integer timestamps (one field YYYYMMDD and one field HHMMSS)
Bookmarks  sqlserver  dba  sql  time 
january 2008 by andyhky
Tibor Karaszi's SQL Server pages
There's no support at the TSQL level to keep generations of backups. For instance, you want to keep backups for 3 days. The functionality is available in Maintenance Plans (MP), but sometimes you want a higher degree of customization.
Bookmarks  sqlserver  dba  backup  sql 
january 2008 by andyhky
« earlier      
per page:    204080120160

related tags

accesskeys  acid  administration  adodb  ajax  algorithms  analytics  apache  api  articles  awe  backup  blog  Bookmarks  bug  c#  cheatsheet  clustered  code  coding  commands  compare  comparison  compatibility  connection  crosstab  cte  dag  database  databases  datamodels  date  datetime  db  db2  dba  dbazine  dbms  deadlock  design  development  diff  digraph  django  documentation  dts  dual  duplicate  emergency  errorhandling  examples  explain  faq  free  freeware  fulltext  ghetto  gis  google  graph  guid  guide  hardware  hierarchical  howto  http  ibm  indexes  indexing  injection  install  installation  isolation  java  javascript  join  joins  keyboard  learning  linked  links  linq  log  logging  login  magazine  maintenance  maps  memory  merge  microsoft  migrate  migration  mirroring  models  moss2007  msdb  msdn  mssql  mysql  networking  news  odbc  online  opensource  optimization  oracle  orm  pagination  pdf  performance  php  pivot  plsql  podcast  postgis  postgres  postgresql  programming  python  queries  query  rails  rand  random  recovery  recursion  recursive  reference  remote  rename  reporting  reports  research  resources  restore  rules  samples  scalability  schemadiff  script  search  security  select  server  servers  sharepoint  sharepoint2007  software  sourcecontrol  sp2  split  sql  sql-injection  sql.server  sql2005  sqlite  sqlserver  sqlserver2000  sqlserver2005  sqlserver2008  sqlserverexpress  ssms  ssrs  stats  storage  storedproc  storedprocedure  storedprocedures  stress  string  support  sysadmin  table  tcpdump  tdd  testing  threading  time  tips  tool  tools  toread  transaction  transactions  transfer  tree  trigger  triggers  troubleshooting  tsql  tuning  tutorial  tutorials  twitter  upgrade  utl_http  version  versioncontrol  videos  vmware  web  webdev  webservices  windows  work  xml  xss  yahoo  yql 

Copy this bookmark: