Viewing 15 posts - 931 through 945 (of 1,069 total)
Run the following query. It will generate the script you need. Change to "Result to Text" from "Result to grid" before you run it.
select 'sp_recompile ' + [name] +...
September 26, 2008 at 7:04 am
and for performance issue, I need to insert the latest daily data into a another table to perform search operations with better spped
Have you created any indexes to improve the...
September 24, 2008 at 7:13 am
Becuase the subject says
script needed - to lists all the tables without a clustered index - sql2k5/2k
September 23, 2008 at 3:25 am
select o.name from sys.indexes i
inner join sys.objects o
on o.object_id = i.object_id
where i.index_id = 0
September 23, 2008 at 3:01 am
Is it x64 machine?
x86 update does not run on x64 machine.
September 22, 2008 at 6:29 am
use master
go
select * from sysprocesses
where blocked > 0
Above query shows if there is any blocking issue.
September 9, 2008 at 6:46 am
Under what circumstances they are preferable ?
It can help to improve the select query performance and avoid deadlocks.
August 28, 2008 at 5:03 am
Can anyone explain simply the difference between LDF data and TRN data
LDF file contains transaction log. Every database must have atleat one .LDF file.
TRN file contains transaction log backup....
August 28, 2008 at 1:06 am
In SQL Server 2008, it is possible to pass table as parameter.
In SQL Server 2005, you can use the work around mentioned in link:
August 27, 2008 at 7:16 am
Create an extra step between the steps to send e-mail notification.
On Failure: Go to the new next step which you just added
On Success: Go to the step next to the...
August 27, 2008 at 6:52 am
BOL:
All mirroring connections on a server instance use a single database mirroring endpoint.
August 25, 2008 at 7:41 am
management plan i enabled the earlier disabled plan
Enabled the schedule as well.
August 8, 2008 at 7:57 am
Viewing 15 posts - 931 through 945 (of 1,069 total)