Viewing 12 posts - 1 through 12 (of 12 total)
I have generated test data with 1 000 000 000 000 000 000 000 rows and according to my tests all the queries proposed run within 1 second. You guys...
June 6, 2014 at 12:27 am
GilaMonster (10/3/2012)
Alexander-449406 (10/3/2012)
October 3, 2012 at 9:30 am
I understand this is a horrible design to expect an ordering without specifying it (this has been already fixed as you suggest). But I'm still trying to find out what...
October 3, 2012 at 8:39 am
Alexander-449406 (10/2/2012)
SELECT
TOP 1 s.SiteID
FROM
Sites s
INNER JOIN SiteUrls su
ON su.SiteID = s.SiteID
WHERE
@Url like su.URL...
October 2, 2012 at 7:12 pm
IgorMi (6/8/2012)
Nils Gustav Stråbø (6/8/2012)
The result of the final SELECT statement would have been the same even if you had dropped the IGNORE_DUP_KEY=ON. The only difference is...
June 8, 2012 at 9:16 am
If you find the SSAS Service in the list it means SSAS is installed on the box.
May 23, 2012 at 9:11 am
Thank you, this wont be an issue in this case. The app just calls the SP and the isolation level is set inside of it.
May 23, 2012 at 12:03 am
Thank you very much for your reply Fitz. Will test this tomorrow, didnt know about this optimizer hint.
From your experience, is there any overhead for the server when using...
May 22, 2012 at 11:52 pm
First you could iterate through the list of servers and query the services trying to find SSAS service on each (http://stackoverflow.com/questions/842533/in-c-sharp-how-do-i-query-the-list-of-running-services-on-a-windows-server).
After that you iterate through the list of...
May 22, 2012 at 5:30 pm
May 26, 2008 at 10:34 pm
This is something that I prefer to implement using an environment variable, or actually reading the environment variable COMPUTERNAME, the good thing with SSIS is that you won't have to...
April 10, 2008 at 10:47 am
Thank you, I will schedule a restart of the server and give feedback if it fixes the problem.
November 4, 2007 at 2:17 pm
Viewing 12 posts - 1 through 12 (of 12 total)