Viewing 15 posts - 1,066 through 1,080 (of 1,993 total)
If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per month for enterprise edition, possibly half that...
MVDBA
June 1, 2012 at 7:37 am
You could get a multiprocessor SQL Server machine with a $1000 a month per cpu license fee or you could find an open source database that would do the necessary...
MVDBA
June 1, 2012 at 6:51 am
Jonathan AC Roberts (6/1/2012)
Hugo Kornelis (6/1/2012)
Jonathan AC Roberts (6/1/2012)
IceDread (6/1/2012)
If you want to go from MS Sql server, you...
MVDBA
June 1, 2012 at 4:41 am
Jonathan AC Roberts (6/1/2012)
Hugo Kornelis (6/1/2012)
Jonathan AC Roberts (6/1/2012)
IceDread (6/1/2012)
If you want to go from MS Sql server, you...
MVDBA
June 1, 2012 at 4:38 am
+1 hugo
it's also a complete re-hash of an article posted 30 days ago
http://www.sqlservercentral.com/articles/MySQL/88971/
both referencing the website convert-in.com
perhaps they should pay for an advert rather than posting articles with inaccurate content...
MVDBA
June 1, 2012 at 4:16 am
sqlnaive (6/1/2012)
MVDBA
June 1, 2012 at 2:18 am
sqlnaive (5/30/2012)
I'll try if I can get the execution plan whenever we get this situation again. Meanwhile I am sure that there is no process blocking the stuck procedure instance.
i...
MVDBA
May 30, 2012 at 2:42 am
why don't you have a look at your wait stats? - flush them before you go home and then if there is an instance then you can maybe see if...
MVDBA
May 30, 2012 at 1:33 am
does that include the heartbeat IP addresses as well?
MVDBA
May 28, 2012 at 10:28 am
Koen Verbeeck (5/24/2012)
What!? You want to ban the biggest comedian of this entire forum?😀 😎 :hehe:
true
MVDBA
May 25, 2012 at 2:31 am
Eugene Elutin (5/24/2012)
You need to change your code (and coding practice)
Whenever you are using string datatype for date values, ensure that unambiguous...
MVDBA
May 24, 2012 at 8:41 am
Lynn Pettis (5/24/2012)
I would identify the tables that you need to delete records frm and delete them from the tables directly.
+100
MVDBA
May 24, 2012 at 8:36 am
WiRL (5/24/2012)
I tried DECLARE email_cursor CURSOR FOR SELECT email, @job_detail = RTRIM(Job_name) +' '+ RTRIM(short_desc) FROM vw_expiring_jobs
but recieve an error stating I can't set variables within a CURSOR?
How else...
MVDBA
May 24, 2012 at 8:35 am
and please re-read the thread yourself - lowels reponse was to change the "query results to text" - which is nothing to do with a select to a grid (although...
MVDBA
May 24, 2012 at 8:31 am
can we also lose the 90s please - what is the correct parameter for that ?
MVDBA
May 24, 2012 at 8:23 am
Viewing 15 posts - 1,066 through 1,080 (of 1,993 total)