Viewing 15 posts - 1,681 through 1,695 (of 2,462 total)
your 3rd query is takig so long time. it means the related tables dont contain any indexes.
temp table must contains indexes here, to make JOIN optimal/fast.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 6:14 am
psmith-695163 (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 6:06 am
refer this also http://support.microsoft.com/kb/941105
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 5:38 am
which sql server 2005 Service pack you have ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 5:36 am
sivark1 (5/14/2010)
@FROM ='abc@xxxxt.com', ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 5:33 am
Shivrudra (5/14/2010)
can you please tell me some details about when transcation commit in sql
SQL Server supports three Transaction Modes: Auto commit, Explicit, and Implicit.
•Auto commit Mode is the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 4:20 am
-Shree (5/13/2010)
so stored the 1st 3 joins result into a temp table and joined it with 4th table
Try to add indexes on temp table( i would go with...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 11:34 pm
sp_readerrorlog use above query to read the things going on server at that time
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 4:33 am
BP-503183 (5/12/2010)
I create an NT group login TEST_DB_SECADMIN and granted securityadmin permission to it.
you need to set db_owner
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 4:11 am
USE master;
GRANT ALTER TRACE TO LoginID;
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 3:58 am
i dont think a non sys admin can truncate any table
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 3:50 am
malavika.ramanathan (5/13/2010)
now if i remove distinct i am getting 31 rows. but that will not match my requirement.
it seems that query is syntatically right but your logic is NOT as...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 2:09 am
Ninja's_RGR'us (5/12/2010)
Nothing in the logs except jobs successful.
what a about sql error log ? or sql agent log ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:35 am
Did you get anything from Sql error log ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:29 am
are you doing this for log shipping ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:28 am
Viewing 15 posts - 1,681 through 1,695 (of 2,462 total)