Viewing 15 posts - 1,771 through 1,785 (of 2,462 total)
dubem1-878067 (5/1/2010)
I am looking for a software that will check (analyse) my stored procedures and tells me if there is missing index on tables, or if the stored proc...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 5:32 am
these are the tables present in msdb
use msdb
go
select top 2 * from sysmaintplan_logdetail
select top 2 *from sysdbmaintplans
select top 2* from sysmaintplan_log
select top 2* from sysmaintplan_subplans
select top 2* from sysdbmaintplan_history
select...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 5:13 am
bryan van ritter (5/3/2010)
Hi,Is there a way to query the progress of a maintenance plan?
bryan
What exactly you want here ? elaborate your requirement.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 5:07 am
mvm_mca07 (4/23/2010)
how the fragment and defragment was done in index
Refer this http://www.sql-server-performance.com/articles/per/detect_fragmentation_sql2000_sql2005_p1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 5:03 am
Niths (5/2/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 12:41 am
But on the same server, different databases have same query with different results, it means that there should be some different database settings. if not then what else could be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 2, 2010 at 3:03 am
CirquedeSQLeil (4/30/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 2, 2010 at 2:45 am
One more thought from my side , you are using table variable instead you should use temp table with clustered index on it as you are using these tables...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 2, 2010 at 2:39 am
ravikanth232 (4/30/2010)
Error Message isMsg 214, Level 16, State 2, Procedure sp_executesql, Line 1
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
post the SP run sample code which you are using
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 7:22 am
Did you get solution ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 7:03 am
Also post
what below statement @sqlstr prints ?
print @SqlStr
EXECUTE SP_EXECUTESQL @SqlStr;
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 7:01 am
ravikanth232 (4/30/2010)
I am using SP_EXECUTESQL in a procedure to insert data in to temp table. but it is giving errorMsg 214, Level 16, State 2, Procedure sp_executesql, Line 1
post...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 6:57 am
Post your script along with table/index defintion , may be we can help you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 6:44 am
Drammy (4/29/2010)
One particular INSERT statement is causing me problems.
Can you elaborate your problem ? how do you think tempdb is culprit ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 5:28 am
can you post index definition ?
I think TempTraveller table needs better indexing.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2010 at 5:23 am
Viewing 15 posts - 1,771 through 1,785 (of 2,462 total)