Browsing articles tagged with "sql - Admins Goodies"
Oct 18, 2012
tom

Restoring Microsoft SQL databases to a different disk partition on the same server

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 »
Jul 23, 2012
tom

How frequent can we do SQL transaction log backups?

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 »
Jun 1, 2012
tom

MySQL query, 2 similar servers, 2 minute difference in execution times

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 »
May 29, 2012
tom

What database server will benefit from 4 CPUs

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 »
May 28, 2012
tom

Ridiculously slow queries on Microsoft SQL Server 2008 R2

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 »
May 25, 2012
tom

SQL Server 2005: Move account from one server to another while maintaining unknown password

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 »
May 23, 2012
tom

Server Monitoring Options

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 »
May 23, 2012
tom

Are Previous Microsoft SQL Installations Needed After SQL 2012 Upgrade?

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 »
May 3, 2012
tom

SQL server 2005 installation SP1

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 »
May 2, 2012
tom

Are vCPU the same as 1 Socket, or a single Core?

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 »
Pages:1234567...27»