Viewing 15 posts - 91 through 105 (of 321 total)
Try this: http://sqlblog.com/blogs/linchi_shea/archive/2007/02/26/maintain-database-partial-availability.aspx
January 15, 2010 at 3:45 am
SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. Any procedure that...
January 14, 2010 at 11:09 pm
If job fails it will definately writes into the log with error number. Can you provide me error number?
January 11, 2010 at 9:55 pm
If you have any unique fields in the table, take out the count having >1
into an temporary table. Delete the original table matching with the temporary table unique values...
January 11, 2010 at 9:47 pm
Yes
It works as follows
The unit of the size reduction is the virtual log file. For example, if you have a 600 megabyte (MB) log file that has been divided into...
January 8, 2010 at 2:26 am
Can u please provide some sample data?
January 6, 2010 at 11:00 pm
select name,city,email as amt from tb1 where amtount> 500
group by name,city,email
January 5, 2010 at 12:33 am
More information needed
January 4, 2010 at 12:17 am
Check to make sure the SQL Server is still online and that you still have connectivity.
Check the NT and SQL Server logs for any errors or problems.
Ensure that no SQL...
January 4, 2010 at 12:16 am
select Id_Pk,Emp_Name,isnull(Salary, 0) as Salary from dbo.MySalaryTable
December 31, 2009 at 2:34 am
Check the following :
Whether the table has constraints or triggers, or both.
The recovery model used by the database.
Whether the table into which data is copied is empty.
Whether the table has...
December 30, 2009 at 3:04 am
If u want the performance improvement an non clustered index is need on the columns you are using in where clause.
December 30, 2009 at 12:08 am
Viewing 15 posts - 91 through 105 (of 321 total)