Viewing 15 posts - 1 through 15 (of 16 total)
This worked for me. Also resolved an issue where a new instance of SSMS was spawning each time I double clicked a .sql file.
June 14, 2018 at 7:06 am
I started up a trace yesterday to capture some of the statements. If I take one of those statements which was causing 1.4 million reads, with the same parameter...
October 3, 2013 at 10:02 am
That was my initial thought, but then when I saw that the query plans were the same before, during, and after the issue, I figured that couldn't be the case.
October 3, 2013 at 9:42 am
I have created a stored procedure in the msdb that will basically start a job and wait for completion. I have implemented the certificate signed stored procedure in one...
March 30, 2011 at 7:12 am
For those of us who registered using the SSC3D registration code, will you have a list of these individuals or do we need to bring something with us to the...
October 30, 2009 at 6:51 am
To add on to my earlier replies, I have the following information/inquiries.
I am trying to identify the best accounts to use for each service.
Microsoft SQL Server Best Practices Analyzer is...
June 2, 2009 at 6:58 am
Thanks for the reply Michael.
So I will use separate accounts for each of the services across each of the servers. Just out of curiosity besides what you mentioned about...
May 22, 2009 at 12:56 pm
I am in the process of researching and testing the use of domain user accounts to run the various SQL Server services as our startup accounts on our servers are...
May 22, 2009 at 12:28 pm
Thanks for the info. 😀
May 12, 2009 at 10:44 am
Doug Hora (5/12/2008)
May 13, 2008 at 11:01 am
Samuel Vella (1/9/2008)
select top 1
where convert(varchar, date, 103) +...
January 9, 2008 at 8:08 am
where session not in (select session from #rr where message = 'error')
order by date...
January 9, 2008 at 7:26 am
Exactly what I was looking for.
Many thanks for the quick replies.
January 9, 2008 at 7:12 am
Thanks for your reply. This is not quite what I need. A little more information. Session is reset daily and increases over time (so as the day goes...
January 9, 2008 at 7:04 am
In case anybody else experiences this problem.
When adding an article that uses automatic identity range management to a publication, after running a snapshot, when subscribers synchronize (without reinitializing) the...
November 9, 2007 at 6:15 am