Viewing 15 posts - 1,666 through 1,680 (of 2,463 total)
Daniel Wood (5/20/2010)
I cannot see what benefit this clustered index would it not be better to add the index on a more unique field.
here it is non uniue clus index...
May 24, 2010 at 7:21 am
CirquedeSQLeil (5/20/2010)
Interesting, I get nothing but Clustered Index scans for all three select statements.
me too get clus index scan for all 3 statements
May 24, 2010 at 7:09 am
see this link http://msdn.microsoft.com/en-us/library/ms182776(SQL.90).aspx
Some lines fron above link
rowversion is the synonym for the timestamp data type and is subject to the behavior of data type synonyms. In DDL statements,...
May 24, 2010 at 6:14 am
post sample data with table definiton . see the link in my signature
May 24, 2010 at 6:11 am
post sample data with table definiton . see the link in my signature
May 24, 2010 at 6:11 am
Incorporate SSIS package's script and copr script in a stored proc SP
then open a job , go to step and new/edit it
and add below code
if ( @check =...
May 24, 2010 at 6:05 am
my guess is simple Sql Agent restart can work here , but that a GUESS so be careful
May 24, 2010 at 5:56 am
see if this link can help you http://stackoverflow.com/questions/596365/what-does-sp-reset-connection-do
May 24, 2010 at 5:51 am
rikk (5/24/2010)
ideally one which won't impact performance too much or cause the transaction log to balloon up.
here you are talking about MSDB backup but i dont think this...
May 24, 2010 at 5:34 am
can u send mails throough sp_send_dbmail ?
May 14, 2010 at 8:26 am
Are you sure that u are getting duplicate data ? in my system i am getting same records with or without DISTINCT
May 14, 2010 at 8:25 am
jez.lisle (5/14/2010)
May 14, 2010 at 8:11 am
rossnruthie (5/13/2010)
May 14, 2010 at 7:56 am
BP-503183 (5/14/2010)
Adding members to fixed database roles requires membership in the db_owner fixed database role.
Did i suggest you right above ?
May 14, 2010 at 7:34 am
deepak.a (5/14/2010)
For the Query 3if the dbo.EmployeeSrc table having Index on EmpID ,Instead of #EmployeeDur Temp table u can join the the
dbo.EmployeeSrc to Empgig1
i would say...
May 14, 2010 at 7:30 am
Viewing 15 posts - 1,666 through 1,680 (of 2,463 total)