Viewing 15 posts - 1 through 15 (of 59 total)
Hi,
@B_Oakes : Execution plans are identical
@mvdba: the first few rows come back quick, then the wait starts. Though looking at the execution plan, there are no...
October 14, 2019 at 8:07 pm
Hi,
@john-2: The server is idling, with only one DB running. No tasks. The RAM is set min 10gb to max 70gb. The current production server is max 25gb....
October 14, 2019 at 4:45 pm
Apologies, should have stated, have also rebuilt indexes and updated statistics.
The bit that stands out to me is the fact I can run a large query (100,000 rows), and the...
October 14, 2019 at 3:31 pm
Thank you to Eddy and Beatrice for your kind responses. I shall look into those options further.
June 12, 2019 at 10:04 am
Hi John,
Thank you for your response.
Yes, it does, although we are concerned about lines and lines of legacy code that may rely on the instance name being specified.
If we can't...
May 10, 2019 at 2:44 pm
ricoohh (4/16/2014)
download link seehttp://www.sqlservercentral.com/Forums/Topic1457275-391-1.aspx#bm1562208
Very kind of you to post. I think this is 2008, rather than 2008 R2.
April 22, 2014 at 4:56 pm
Hi Guys,
Thanks all for your input. I suppose the MM solution is as close as we are going to get to "eloquent", adn certainly beats mine !!
Thanks again.
Matt
November 6, 2013 at 9:22 am
Hi Mark,
Your solution is good, but it has a limitation in that if a period start and end more than one hour apart, it doesn't get calculated.
Dwain: Yours, I can't...
October 31, 2013 at 7:04 pm
Thanks Mark. I'll give it a go. The midnight issue shouldn't be a problem.
October 30, 2013 at 10:55 am
Hi,
To explain further. Let us assume that table @t represents light bulbs being switched on and off. So the first light bulb is switched on at 9.30am and off at...
October 30, 2013 at 8:14 am
Joie Andrew (6/11/2013)
June 11, 2013 at 4:38 pm
HanShi (6/11/2013)
It's getting very weird. Now I also can't download the requested file (executable) anymore and get directed to SQL2012.Try this one: http://www.microsoft.com/en-us/download/details.aspx?id=6362
Hi,
I get end with same HTML file linked,...
June 11, 2013 at 2:57 am
Joie Andrew (6/11/2013)
try this link:
http://www.microsoft.com/en-us/download/details.aspx?id=8158 which leads to
http://www.microsoft.com/en-us/download/confirmation.aspx?id=8158
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Yep, that's the same...
June 11, 2013 at 2:28 am
Joie Andrew (6/9/2013)
Microsoft® SQL Server 2008 R2 Evaluation : Trial Experience for Developers
Hi, thanks for that, but the end result is still pointing you at 2012.
I am 99% sure you...
June 10, 2013 at 4:22 pm
e4d4 (10/14/2012)
The user must have view server state permission, to grant user that permission execute:
GRANT VIEW SERVER STATE TO yours_user;http://msdn.microsoft.com/en-us/library/ms179881.aspx sys.sysprocesses (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms186717.aspx GRANT Server Permissions (Transact-SQL)
Thanks e4d4.
All working
October 15, 2012 at 4:17 am
Viewing 15 posts - 1 through 15 (of 59 total)