Reputation
249
Next privilege 250 Rep.
View close votes
Badges
2 4 12
Impact
~28k people reached

  • 0 posts edited
  • 5 helpful flags
  • 11 votes cast
2d
comment 'Id' with the format: YYYYNNNNNN with the NNNNNN part restarting each year
using a select max id query is a common practice. use that.
Nov
5
awarded  Famous Question
Nov
4
awarded  Famous Question
Aug
9
awarded  Caucus
Aug
9
revised Why should I create an ID column when I can use others as key fields?
deleted 1 character in body
Apr
4
awarded  Commentator
Apr
4
comment Which database could handle storage of billions/trillions of records?
save those IP addresses as 32 bit int
Apr
4
comment Can MySQL reasonably perform queries on billions of rows?
@haxney have you ever heard about renaming files using patterns?
Feb
20
awarded  Yearling
Feb
20
awarded  Teacher
Jan
28
awarded  Good Question
Aug
20
awarded  Notable Question
Dec
11
awarded  Popular Question
Sep
3
awarded  Notable Question
Apr
18
asked Are database servers less scalable than web servers?
Feb
18
comment Detecting SQL Server Utilization with a query
select * from sys.dm_os_performance_counters doesn't return anything relevant to CPU the rest of your answer about memory is accurate
Feb
14
accepted Does a transaction cover the subroutines?
Feb
14
comment Does a transaction cover the subroutines?
@Phil ms sql server
Feb
14
asked Does a transaction cover the subroutines?
Feb
14
comment What standard should I follow when naming tables and views?
@ypercube because I'm too lazy to type one extra underscore and I make typing mistakes easily. I read the words easier when I use an underscore and I use v for separating view from tables, and v is not a word so i dont use underscore.. It looks inconsistent, yes, but I find this format practical.