Viewing 15 posts - 2,896 through 2,910 (of 3,232 total)
We are also in the process of standardizing our processes. We currently do not have all of our database objects in a source/version control software, but we are moving in...
April 28, 2006 at 2:43 pm
I think that has alot to do with the developer's comfort/talent level with SQL. Our programmers have varying degrees of skill with SQL so some need more support than others. ...
April 28, 2006 at 2:28 pm
When you executed the BACKUP DATABASE script, did you send the backup file to the exact same location as the maintenance plan would have?
April 28, 2006 at 2:17 pm
I think you have 2 seperate issues here. One is that you need a way to look at archived data on a seperate server. Second, you need to save off backups...
April 28, 2006 at 2:11 pm
There is no need to perform a compute or count of any kind if you are looking for parent rows without children. You need an outer join. This...
April 28, 2006 at 9:22 am
OK, so you need to archive off all tables in your database on a regular scheduled basis to a different server where the data will then be available until the...
April 28, 2006 at 9:10 am
I'm not quite clear on what you are trying to do here, so let me tell you what it sounds like you are asking for. It sounds to me...
April 27, 2006 at 3:35 pm
This would not be possible with BACKUP. You would need to create a data extract script that could conditionally pull data from your tables.
April 27, 2006 at 3:20 pm
The parser is trying to cast the first portion of you @sql to int implicitly. Instead, you need to explicitly cast @id to varchar.
DECLARE @id int
SET @id=2
DECLARE @sql varchar(400)
SELECT...
April 27, 2006 at 2:50 pm
The I/O problem looks like it came during the CREATE DATABASE portion of the restore. I would suggest creating your database first. You should be able to size...
April 27, 2006 at 1:53 pm
My bad, I did not see that this was a 2005 post. You will need to use the Cleanup History task like David has suggested.
April 27, 2006 at 8:50 am
Well, I would say that it still holds true. If your Total and Target memory are the same, SQL Server would benefit from additional memory. If you are not experiencing...
April 27, 2006 at 8:43 am
Could you post some sample data from table1 and table2 as well as an example of the results you are expecting? Is there a reason you chose a RIGHT OUTER...
April 26, 2006 at 1:56 pm
I just finished putting together a T-SQL standards document for our developers to use. The following sites have some good info to consider:
http://www.sql-server-performance.com/vk_sql_best_practices.asp
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04l9.asp
I agree with you with...
April 26, 2006 at 10:53 am
There is an option in the Maintenance Plan Wizard that will allow you to specify backup retention. Setting this option will remove old files for you.
April 26, 2006 at 10:20 am
Viewing 15 posts - 2,896 through 2,910 (of 3,232 total)