Viewing 15 posts - 1,891 through 1,905 (of 2,463 total)
saghbash (4/3/2010)
how can I speed tracks my career and where to start. Many question in my mind and looking for your generous advice.
these type of FORUM also provide...
April 11, 2010 at 12:28 am
Kimberly L. Tripp (4/9/2010)
April 11, 2010 at 12:23 am
Jeff Moden (4/10/2010)
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...
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...
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...
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.
April 9, 2010 at 8:05 am
Try this
use cvent_dba
go
WITH agg AS
(
SELECT
[object_id],
last_user_seek,
...
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" ?
April 9, 2010 at 7:41 am
select * from sys.stats where auto_created = 0 And what does this query mean ?
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
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...
April 9, 2010 at 6:59 am
You posted the problem and Solution as well . then how and where we can help you ? 😀
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...
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
April 9, 2010 at 5:54 am
Viewing 15 posts - 1,891 through 1,905 (of 2,463 total)