Viewing 15 posts - 1,666 through 1,680 (of 2,462 total)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 6:14 am
post sample data with table definiton . see the link in my signature
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 6:11 am
post sample data with table definiton . see the link in my signature
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 6:05 am
my guess is simple Sql Agent restart can work here , but that a GUESS so be careful
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 5:34 am
can u send mails throough sp_send_dbmail ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 8:25 am
jez.lisle (5/14/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 8:11 am
rossnruthie (5/13/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 7:30 am
@psmith
4. Desired output - some visual representation of this.
need this also
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 7:28 am
Viewing 15 posts - 1,666 through 1,680 (of 2,462 total)