1,234 reputation
1917
bio website
location
age
visits member for 3 years, 5 months
seen 2 days ago

Jack of all trades, master of none.


Feb
28
comment What can cause Reads to slow down on SQL Server 2008R2?
@Mark Wilkinson: Should have added a note of caution, indeed.
Feb
28
comment What can cause Reads to slow down on SQL Server 2008R2?
Outdated statistics are also a possible source for performance degradation. You could run EXEC sp_updatestats on the database using Management Studio to update the statistics.
Jun
5
comment Move database files if database runs
You could do a backup and restore that one on the remote machine, if it's just for offline reporting or some consistency checks that you were mentioning. The backup could be done without having any downtime. You'd just have some load on your server.
Jan
18
comment SQL Server transaction log - shrinking and reattaching
You should not shrink your data file. See for details: sqlskills.com/blogs/paul/…
Jul
13
comment MySQL table design / architecture, table is too big
Values in TEXT columns are not stored in the row buffer, but nonetheless get stored in the database at some other memory location (depending on storage engine). Including TEXT fields in your queries might give you performance problems (see: stackoverflow.com/questions/2883867/…)
Jul
3
comment What is the actual lowest possible positive REAL number
+1: Haven't heard about subnormal numbers yet.
Jun
26
comment How to compare two SQL Server 2008 configurations
I know, that's why just a comment as additional info to your answer. Usually you got 80% default settings. So this way you're left to compare only the remaining 20%. (+1 btw)
Jun
26
comment How to compare two SQL Server 2008 configurations
Check out the script at sqlserverperformance.idera.com/uncategorized/… to quickly spot non-default settings for SQL Server 2008.
May
9
comment Is Index causing timeouts?
As soon as the first column in your index is not used in your query, the index cannot be efficiently used. Also, maybe you deleted some indexes that were crucial for some queries that now time out. I once had better performance using single indexes for each query column instead of a large combined one (stackoverflow.com/q/702469/44522).
Feb
17
comment Why can't I connect to SQL Server 2008?
Your SQL Server Browser service is maybe not running. See my checklist in this answer: stackoverflow.com/a/6001023/44522
Oct
5
comment SQL Server 2005 database engine login failed error?
Just accept the answer, if it helped you.
Sep
15
comment Should fields that aren't needed often be kept in separate tables?
+1 for: "To sum it up, I think you've got a bigger performance problem in using an ORM than in storing the descriptions in the same tag table."
Sep
12
comment MySQL Auto_increment going 2 by 2
As the documentation says, it's not possible to set it db or table-wise. I'm sorry, I can't help you here. Maybe you are trying to achieve something with the autoincrement feature that it wasn't intended for.
Sep
12
comment Weird error on simple query in MsAccess
ORDER BY should work with 2010, but it's not really sorting on the whole field content. But the problem in your case is the combination with DISTINCT, as Access is truncating internally the memo field to sort on it (like in my above sample). And that conflicts with DISTINCT.
Sep
2
comment Logical operators OR AND in condition and order of conditions in WHERE
No, current versions aren't patched, AFAIK. I meant that future versions will work again how it should be.
Sep
2
comment Logical operators OR AND in condition and order of conditions in WHERE
@Jack: Thanks for pointing this out. Looks like it has been fixed in June, so that case will work again as expected.
Jul
15
comment What is the JDBC URL for Oracle's Data Guard Fast-Start Failover?
Did you already check "Data Sources and URLs" from Oracle (download.oracle.com/docs/cd/B28359_01/java.111/b31224/urls.htm)?