Viewing 15 posts - 1,591 through 1,605 (of 2,462 total)
if you still struggling for solution , post sample data along with desired output.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 21, 2010 at 7:12 am
s.enchill (6/16/2010)
thanks a lot.... what about any post installation best practices for an instance ?
thats solely depended on your requirement like
checking database mails , linked server , connectivity...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 16, 2010 at 11:20 pm
Google it.:-) that can hep you better because nobody has precise answers/description for your query.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 16, 2010 at 10:34 pm
Refer this link http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-quick-guide.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 16, 2010 at 10:29 pm
gtschech (6/15/2010)
But I wonder if maybe I should switch to an indexed view for better View retrieval performance.
it depends on the main base tables transactions , if there is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 11:45 pm
So finally you got some improvement after updating statistics. right ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 11:08 pm
Have you got anything from sp_readerrorlog ? and if possible restart sql server , this is the last weapon i have 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 4:28 am
have you updated the statistics ?
i guess you need to update the statistics for
ZuoPositionAggregation 3.8 Mio
ZuoRisikofaktorAggregation 1.8 Mio
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 1:31 am
mw112009 (6/14/2010)
What I mean is I'd like to build the index but not have to worry about the details
what does it mean ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 1:20 am
iklektic (6/14/2010)
I've got a question (no surprise there).
I have a query that I would like to search by the StaffID, I would also like to separate...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 12:39 am
i found it difficult if i think on my top of mind but if those JOIN exist in stored proc then
select * from syscomments where text like '%...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 15, 2010 at 12:04 am
CavyPrincess (6/14/2010)
Not that you asked, but I would research if an in-place install is really the best approach for your upgrade. I personally wouldn't recommend it
i didnt get...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 11:57 pm
samiam914 (6/14/2010)
Is there something that needs to be done in sql server.
NO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 11:01 pm
gary.jenkinson01 (6/14/2010)
If I wanted to run the above code against a specific DB, where do I place the USE clause.
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Administrator',
@recipients = 'gary.jenkinson01@rotherham.gov.uk',
@subject = 'Fragmentation Results' ,
@query =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 11:00 pm
below is the sql code that can help you
EXEC msdb.dbo.sp_send_dbmail
@profile_name = @profile_name ,
@recipients = @recipients,
@copy_recipients = @copy_recipients,
@subject = @subject,
@body = @body,
@body_format = 'TEXT',
@query =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 6:47 am
Viewing 15 posts - 1,591 through 1,605 (of 2,462 total)