Viewing 15 posts - 1,891 through 1,905 (of 2,462 total)
Kimberly L. Tripp (4/9/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 11, 2010 at 12:23 am
Jeff Moden (4/10/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 11, 2010 at 12:20 am
K. Brian Kelley (4/9/2010)
you can turn on login auditing at the server level and the info will be written to both the event log
Can you post any link for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 11, 2010 at 12:09 am
tony.turner (4/9/2010)
On the other hand a large heap (no clustered index) would INSERT very slowly (I have come across some prize examples of same).
This is a bit new/strange...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 10, 2010 at 11:58 pm
amalanto (4/9/2010)
I want to know that this non clustered index will refer clustered index(primary key) or not?
Look for Key look up in Exec plan. if Non clus index...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 8:06 am
rpatil22 (4/9/2010)
WHERE machine = 'ABCSSSS'
For this query it will show Clustered index update in Exce. plan but performance wise we cant say anything.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 8:05 am
Try this
use cvent_dba
go
WITH agg AS
(
SELECT
[object_id],
last_user_seek,
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 7:44 am
vani_r14 (4/8/2010)
we would like to delete the tables if it is not used.
What do you mean by "Not used" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 7:41 am
select * from sys.stats where auto_created = 0 And what does this query mean ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 7:08 am
cfradenburg (4/9/2010)
It's possible
select count(*) from sys.stats where auto_created = 1
1804
drop statistics tablename._WA_Sys_00000002_00750D23select count(*) from sys.stats where auto_created = 1
1803
Thanks , good learning for me
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 7:05 am
ah0996 (4/8/2010)
Thank you guys, these are all great advice!!!! Thank you again!
You should also share the solution you used to fix above issue.So that other people can also learn from...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 6:59 am
You posted the problem and Solution as well . then how and where we can help you ? 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 6:05 am
sanketahir1985 (4/9/2010)
when i fire SP_Updatestats on database after completing the same,everything works fine and CPU utilzn. also comes down to 40%
But how did you find out that firing SP_Updatestats will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 5:57 am
subramanian22 (4/9/2010)
Delete is the DML or DDL?
Spend some time http://msdn.microsoft.com/en-us/library/ms189835.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 5:54 am
hennie7863 (4/9/2010)
Don't know. Why do you ask?
because these are automatically generated by Sql server and you cant drop them (as far as i know )
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 4:56 am
Viewing 15 posts - 1,891 through 1,905 (of 2,462 total)