We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently got corrupted and the databases are not working properly and pulling all kinds of consistency check errors. We have created a new iSCSI target and introduced it to the SQL server as a new disk partition. we have good backups that we [...]Continue Reading »
I’m installing a highly critical system. If the system fails, the users wants data up to the last minute. To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has anybody done this before? Is this the best way to achieve the 1-minute data loss tolerance? Appreciate any advice, Thanks! Asked by user1034912 Well, you can do frequent tx log, but it still looses data. Best approach is: 3 database [...]Continue Reading »
I had a similar question on stack overflow, but it seems to be more server/mysql setup related than coding. The queries below all execute instantly on our development server where as they can take upto 2 minutes 20 seconds. The query execution time seems to be affected by home ambiguous the LIKE string’s are. If they closely match a country that has few matches it will take less time, and if you use something like [...]Continue Reading »
I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow. What other database I can use that will use those 4 CPUs? I read that MySQL use only one. Is there SQL dababse or do I need to use NoSQL? Most queries are selects. Asked by jcubic You are [...]Continue Reading »
I’m getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don’t have the same problem, but we all run the same code. It seems to be that any query that includes a JOIN takes >20s, some taking up to a minute. Inserts and updates are fast. The total database size is about 30MB, so it’s hardly huge. During [...]Continue Reading »
There is a user account that someone set up on one of our database servers long ago, that no-one any longer knows the password for. However some apps have the password (for various reasons we cannot recover the password from the apps). Unfortunately we want to point the apps at a new server and will backup and restore the relevant databases to this new server – is there a way to copy the login from [...]Continue Reading »
I’m trying to find the best way to monitor my MS SQL server. I have been using pingdom for my web server and want to look at something else. I have done a lot of googleing but they all seem to be the same. Was hoping someone could tell me their good and bad stories that might make it easier to pick one. It is just for the MS SQL server. Just need to know [...]Continue Reading »
Are the older installations of Microsoft SQL Server needed after you installed Server 2012? I’ve been doing some cleaning and noticed I’ve a whole list of SQL Server installation. When I installed Server 2012, I clicked the upgrading option but previous versions are still present. I’m guessing they are needed but I want to be sure. Asked by reaper_unique This is a hard question. Many of us keep the older instance running for some reason [...]Continue Reading »
I have got problem with installation SP1 and SP2 to SQL server 2005 I get this text -> Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer. I don’t understand what I have to do? I can`t select this box with SQL server 2005 to make update. Start -> Menu Asked by n/a You are [...]Continue Reading »
Currently I have a Hyper-v VPS with 2 (vCPU) processor. I would like to install SQL Server Express 2012 that has a limitation of 1 Socket or 4 Cores, whichever the lesser. My Question: Are vCPU’s counted as a single core, or as sockets? or something completely different? Asked by TravisK Hyper-V presents one socket with multiple cores. You can verify this with a tool such as CPU-Z. Here’s a screenshot I took of a [...]Continue Reading »
- Cron expression that runs every 5 minutes from 1:30 am – 6:00 am [duplicate]
- Understanding redundant power supplies
- Is there a way for administrators to disable users from installing Firefox extensions?
- Is there research material on NTP accuracy available?
- How to create a limited “domain admin” that does not have access to domain controllers?