The process tag has no wiki summary.
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
22
votes
4answers
813 views
Is there a “best-practices” type process for developers to follow for database changes?
What is a good way to migrate DB changes from Development to QA to Production environments? Currently we:
Script the change in a sql file and attach that to a TFS work item.
The work is ...
3
votes
2answers
2k views
Internal reason for killing process taking up long time in mysql
I copied a big table's structure with (it is an InnoDB table btw)
CREATE TABLE tempTbl LIKE realTbl
Then I changed an index, and filled it up so I could run some test.
Filling it was done using:
...
