Strategies

• Topics

  Started by

  Posts

  Last post

• Migration of on-premises SQL Server to an AWS PostgreSQL database

  We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database instead of AWS …

  Abhishek

  2 replies

  3 months, 4 weeks ago

  By: Grant Fritchey

• SQL Server Migration Workbenches

  WHy doesnt MS provide a migration workbench to convert other database systems to a SQL Implementati…

  Santosh Benjamin

  2 replies

  10 months, 1 week ago

  By: ratbak

• Best Practice for Web Development

  We use access,VB and Sql in our company. We need to move on to some web based systems. What would a…

  spaski

  7 replies

  3 years, 6 months ago

  By: breywhite9377

• Strategies for storing tags

  Hi all, I am replacing a fixed category structure with a free form tagging structure. The tags will…

  kangarolf

  1 replies

  6 years ago

  By: Gail Shaw

• Batch Delete is Slow :angry:

  Batch Delete is Slow I am deleting some 200000 records from 5000000 rows. set rowcount 10000 while …

  yuvipoy

  21 replies

  10 years, 11 months ago

  By: Lynn Pettis

• Data Warehouse question

  This is more of a 'what is a general best practice' question than a specific code or syntax questio…

  David Lester

  8 replies

  11 years, 10 months ago

  By: alexanderzarita

• Data conversion data validating using information_schema.columns

  I am looking for an efficient to validate data for a data conversion. The path I am taking is impo…

  doodleshelp

  1 replies

  11 years, 11 months ago

  By: x

• conversion from access to sql server..

  i try to convert from access database to MSSQL Server but there's an error the error msg is "Attach…

  john_edman24

  1 replies

  12 years, 1 month ago

  By: Koen Verbeeck

• Auto generated primary key

  Ok guys, I'm a student, new to sql and really need help. How do u auto generate your primary key? I…

  dilakshan31

  8 replies

  13 years ago

  By: Lynn Pettis

• Sql Server Load Balancer

  Hi all, My company is planing to implement load balancer for HTTP requests in case to increase the …

  Jagz W

  3 replies

  13 years, 1 month ago

  By: Gail Shaw

• Apostrophes and Double Quotes - Should They be Allowed in table Text-Type Columns?

  As a best practice, should apostrophes and double quotes be removed from text in SQL tables? I can …

  mtillman-921105

  15 replies

  13 years, 1 month ago

  By: mtillman-921105

• Strategy for adding Constraints to legacy database

  I'm a senior developer working on a mid-sized SQL Server 2005 system (1000 tables) that is several …

  meade.swenson

  1 replies

  13 years, 4 months ago

  By: Bill Hansen

• I need help with my table design

  Hi All, The database Iam working on is MSSQL2000. The database got a call log table [tblCallLog] (…

  dlam 18073

  2 replies

  13 years, 4 months ago

  By: Bill Hansen

• Moving data between databases

  Hello, I have a couple of questions regarding a framework that I may want to change regarding the m…

  ducon

  8 replies

  13 years, 9 months ago

  By: ducon

• Alter constraints - non-clustered PK -> Clustered PK

  Hi all, In SQL 2K (or SQL 2K8), is it possible to programmatically alter the PK constraints on the …

  schleep

  2 replies

  14 years, 7 months ago

  By: schleep