Viewing 15 posts - 1,066 through 1,080 (of 1,995 total)
are you doing full backups at any point in your maintenance plan - log shipping does not prevent you from running full (non-copy only) backups - it just re-starts your...
June 1, 2012 at 9:09 am
Jonathan AC Roberts (6/1/2012)
michael vessey (6/1/2012)
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...
June 1, 2012 at 7:50 am
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...
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...
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...
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...
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...
June 1, 2012 at 4:16 am
sqlnaive (6/1/2012)
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...
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...
May 30, 2012 at 1:33 am
does that include the heartbeat IP addresses as well?
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
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...
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
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...
May 24, 2012 at 8:35 am
Viewing 15 posts - 1,066 through 1,080 (of 1,995 total)