| Thread | Last Post | Replies |
|
| Performance Issues | 04 Mar 2008 18:04 GMT | 4 |
I have just recently started having performance issues on my biggest Sql Server. Jobs that had been taking 10 minutes are now taking 90 minutes to complete. At first I thought it might be a CPU issue but when I monitor the usage on the server it rarely goes above
|
| Restoring differential backup | 04 Mar 2008 16:51 GMT | 20 |
I am using SQL Server 2005 I have a full backup from midnight and a differential backup from 8 am. I restored the full backup from midnight to a new database, say called NewDB.
|
| Trying to fix SQL | 04 Mar 2008 16:27 GMT | 1 |
I am VERY new at SQL and trying to fix code to get something to work. I keep getting this message? Does anyone know what I need to do to problem solve? Thanks -
|
| Does anyone have any ideas .. | 04 Mar 2008 16:18 GMT | 2 |
.. on making a DB map? Hopefully someone knows of a tool/util. Here's where I'm coming from: We have a list of changes to make to our DB and the PHP interface.
|
| size of varchars | 04 Mar 2008 14:46 GMT | 2 |
Someone else asked this and got referred to a Discussion that didn't address the question so I'm going to ask again. If you have a column that typically is going to be less than 12 characters in length, the obvious choice would be to use a
|
| How to copy database from one server to another | 04 Mar 2008 14:41 GMT | 2 |
I have a database on a SQL Server 2005 Express. I want to copy this database along with all its data into another server which is a SQL Server 2005 (full edition). I can't seem to figure out an easy way to do this. I tried backing up and restoring database but it told me that
|
| How to know What Query Statement that consume the Server resources most ? | 04 Mar 2008 14:39 GMT | 2 |
We have problem with SQL Server 2000 : there something in the application that cause the server out of memory. I suspect this is because an inefficient and heavy query. In Oracle we have TOP SQL from Enterprise Manager to see what query
|
| dm_db_index_physical_stats not getting updated | 04 Mar 2008 14:21 GMT | 9 |
I have a sql script that I use to reorganize indexes with more than 5% fragmentation and rebuild indexes (ONLINE OFF) with more than 30% fragmentation. On running this, I found that, the script was working fine but every iteration updated about 550 indexes. After a run, if I ...
|
| database recovery testing - procedure | 04 Mar 2008 14:02 GMT | 4 |
how frequent you guy verify database backup from tape ? What is the procedure? do you restore from tape and attach to database Cheers,
|
| DBA First Date | 04 Mar 2008 08:04 GMT | 5 |
Hi, I am going to start as the only DBA in a company, very nervous, since there is no peer at the company and no transition from the job, could someone told me when I start, what would be the initial steps to take for starting? I read some article about daily activities on the ...
|
| Backup/restore to different servers | 04 Mar 2008 06:17 GMT | 7 |
Is it possible to specify a server in a backup script & likewise specify a restore to a different server e.g. BACKUP DATABASE 'LIVESERVER..' + @DBName TO DISK = @Path
|
| SQL Server Log: Starting up database | 04 Mar 2008 02:56 GMT | 6 |
My SQL Server Log shows a ton of records starting up two different databases. One of them was an old test database of mine, so I deleted it. However, the other is a production database, recovery mode set to simple. Can someone tell me why these particular databases were / are ...
|
| cleaning up backups | 03 Mar 2008 19:26 GMT | 2 |
I recently took responsibility for a sharepoint 2003 server & corresponding SQL 2000 server. The backups are working through a maintenance plan, but I'd like to implement a richer plan and am having difficulties developing the best approach. understand I've not done much care & ...
|
| the effect of huge amounts of RAM? DB cache? | 03 Mar 2008 19:22 GMT | 10 |
I have tons of short SPs being called all the time. The # of milliseconds on each matters and I'm at a point where pulling data from the hard drive slows down the operation more than anything. I've done tuning, etc. So if I get more RAM on a SQL Server 2005 than the size of ...
|
| SCREWY LAST BATCH DATE | 03 Mar 2008 18:09 GMT | 1 |
Using SQL2k EE SP3 There's a spid in the activity monitor that has a Last Batch date of 1/1/1900 12:00AM however, the logged In date is recent. What could cause this to happen?
|