Viewing 15 posts - 1,681 through 1,695 (of 2,463 total)
@psmith
4. Desired output - some visual representation of this.
need this also
May 14, 2010 at 7:28 am
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.
May 14, 2010 at 6:14 am
psmith-695163 (5/14/2010)
May 14, 2010 at 6:06 am
refer this also http://support.microsoft.com/kb/941105
May 14, 2010 at 5:38 am
sivark1 (5/14/2010)
@FROM ='abc@xxxxt.com', ...
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...
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...
May 13, 2010 at 11:34 pm
sp_readerrorlog use above query to read the things going on server at that time
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
May 13, 2010 at 4:11 am
USE master;
GRANT ALTER TRACE TO LoginID;
GO
May 13, 2010 at 3:58 am
i dont think a non sys admin can truncate any table
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...
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 ?
May 13, 2010 at 1:35 am
Did you get anything from Sql error log ?
May 13, 2010 at 1:29 am
Viewing 15 posts - 1,681 through 1,695 (of 2,463 total)