143 reputation
5
bio website jorriss.net
location Miami, FL
age 40
visits member for 3 years, 3 months
seen Jul 29 at 13:43

Application Architect, Data Architect and Project Manager


Mar
22
revised Primary Key efficiency
edited body
Mar
22
comment Primary Key efficiency
If you're using a DATETIME you may want to consider using DATETIME2. DATETIME has a precision of .000 seconds and rounds the value to .000 or .003 or .007. For a POS the exact time matters in most cases. DATETIME2 has precision to .0000000 seconds.
Mar
22
awarded  Teacher
Mar
22
answered Primary Key efficiency
Nov
12
comment Performance Tuning for Huge Table (SQL Server 2008 R2)
You didn't mention if the table is partitioned. Are you using table partitioning? msdn.microsoft.com/en-us/library/ms190787.aspx
Jul
10
awarded  Excavator
Jul
10
awarded  Editor
Jul
10
revised Delete rows in a table that has multiple FKs
Corrected minor grammar issue. Happens to the best of us.
Jul
10
suggested suggested edit on Delete rows in a table that has multiple FKs
Mar
12
awarded  Supporter
Aug
11
awarded  Autobiographer