Viewing 15 posts - 6,661 through 6,675 (of 7,636 total)
GermanDBA (6/11/2008)
I...
June 11, 2008 at 8:27 pm
This really sounds like it should be a Service Broker application. This would allow you to decouple the WALKDOWN / WALKUP from the Sending of 100000 rows.
June 11, 2008 at 8:07 pm
I just always kept a session open to each of my SQL Servers.
The good news is: This feature is supported on all versions! 🙂
June 11, 2008 at 7:58 pm
Robert klimes (6/11/2008)
Having tempdb on its own drive (raid 10 preferable) and having same number of tempdb file as you have cores would be optimal configuration.
This is a SQL 2000...
June 11, 2008 at 6:43 pm
Not sure. We're already a little beyond me specific knowledge. I'd suggest checking some of the "see also" links from that article, or Synch to the Table of...
June 11, 2008 at 5:00 pm
Matt Miller (6/11/2008)
hehe...I see Barry has better recollection than I as to why the @whereand parameter doesn't work. And - he types faster too!:D
I have to confess that I...
June 11, 2008 at 4:54 pm
Please check out "Row Versioning-based Isolation Level Example" in Books On-Line. It should answer a lot of your questions.
June 11, 2008 at 2:44 pm
Matt Miller (6/11/2008)
June 11, 2008 at 12:20 pm
Michael (6/11/2008)
exec sp_MSforeachtable@command1 = 'DELETE FROM ? ',
@whereand = '(TSTAMP < ''2007-01-01 00:00:00'')'
Results the same:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'TSTAMP'.
That's probably because...
June 11, 2008 at 12:17 pm
Matt Miller (6/11/2008)
Jeff Moden (6/11/2008)
rbarryyoung (6/11/2008)
Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.
Heh... ok, I gotta ask... has anyone actually ever...
June 11, 2008 at 11:48 am
Jeff Moden (6/11/2008)
rbarryyoung (6/11/2008)
Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.
Heh... ok, I gotta ask... has anyone actually ever done a...
June 11, 2008 at 11:10 am
Thanks, I will take a look at these.
June 11, 2008 at 10:59 am
Viewing 15 posts - 6,661 through 6,675 (of 7,636 total)