Reputation
8,824
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 21 47
Newest
 Enlightened
Impact
~427k people reached

Sep
13
revised Retrieving data speed tweaks SQL Server 2005
deleted 9 characters in body; edited tags
Sep
13
reviewed Reject Sleeping connections
Sep
13
reviewed Reviewed Count duplicate versions of databases (SQL Server 2008 R2)
Sep
13
comment Count duplicate versions of databases (SQL Server 2008 R2)
Have you tried to UNION [ALL] the two queries?
Sep
13
revised Count duplicate versions of databases (SQL Server 2008 R2)
added 4 characters in body
Sep
13
reviewed Reviewed Memory management scenario with MongoDB
Sep
13
comment Memory management scenario with MongoDB
This sentence is not quite clear for me: 'If it is good or not it depends on, while Linux will page out some parts of the physical memory, so not the whole virtual segment have to be in physical memory just the recently accessed parts' Could you reword it?
Sep
13
revised Memory management scenario with MongoDB
added 78 characters in body
Sep
13
reviewed Reviewed linked server to specific access table
Sep
13
revised linked server to specific access table
deleted 47 characters in body; edited tags
Sep
13
reviewed Leave Closed How to retrieve a query from 3000 tables in SQL?
Sep
13
reviewed Close What are reasonable privileges to grant typical users?
Sep
13
reviewed Reviewed Help me to map Column types betwenn SQL and TopSpeed Clarion Tables
Sep
13
revised Help me to map Column types betwenn SQL and TopSpeed Clarion Tables
added 9 characters in body
Sep
13
reviewed Close Which schema is better for a shopping project?
Sep
13
reviewed Reviewed Why would a query in code be slower than a query in a SQL tool
Sep
13
comment Why would a query in code be slower than a query in a SQL tool
Without actual query plans your question can attract guesses in the best case. Could you please check whether that query produces the same plan here and there? Also, try to compare timing using the same query tool, you have too many factors in the equation.
Sep
13
revised pg_dump from 9.2 to 8.4
edited body
Sep
13
revised Duplicate key violates unique constraint
added whitespace
Sep
12
reviewed No Action Needed How to design a table that each rows have 5K boolean attributes?