Viewing 15 posts - 13,951 through 13,965 (of 26,484 total)
No.
February 24, 2012 at 7:31 pm
Ray K (2/24/2012)
I haven't been on these things in a while. I was REALLY hoping that Cel-BLOW had disappeared. Wishful thinking on my part....
February 24, 2012 at 6:50 pm
IIRC, I believe the answer is yes. Each instance must listen on a different port, such 10234 and 10235.
February 24, 2012 at 6:44 pm
Quite an interesting day. I gave my two weeks notice and was basicly told that I would not need to come back. Not that I don't mind, it...
February 24, 2012 at 6:38 pm
Ray K (2/24/2012)
I haven't been on these things in a while. I was REALLY hoping that Cel-BLOW had disappeared. Wishful thinking on my part....
February 24, 2012 at 6:34 pm
Wildcat (2/22/2012)
Hakuna Matata (2/22/2012)
Try this :
WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())I don't recommend to use this
I agree with wildcat as it would cause a table scan. The convert function has to be applied...
February 22, 2012 at 2:39 pm
MysteryJimbo (2/22/2012)
Lynn Pettis (2/22/2012)
Jeremy... (2/22/2012)
MysteryJimbo (2/22/2012)
February 22, 2012 at 1:11 pm
Only reason I even thought about it was due to the fact I have suggested the changes to one database that would eliminate about 14 or so redundant or duplicate...
February 22, 2012 at 11:45 am
Here comes the consultant answer (wait for it ...)
It Depends.
Now that we have that out of the way, what edition of SQL Server 2005 are you using?
February 22, 2012 at 11:06 am
Jeremy... (2/22/2012)
MysteryJimbo (2/22/2012)
February 22, 2012 at 11:04 am
My first question before I try answering such a broad question, have you looked up indexed views in Books Online?
February 22, 2012 at 10:09 am
captcooldaddy (2/22/2012)
He didnt ask for set based solution but a cursor alternative. Who knows maybe your right. My solution was pre cte days. Old habits die hard.....
Even if the OP...
February 22, 2012 at 9:35 am
Jeremy... (2/22/2012)
Lynn Pettis (2/22/2012)
Jeremy... (2/22/2012)
Where FM.Openeddate = getdate()
did not work. ...
February 22, 2012 at 8:45 am
This may sound a bit ridiculous, but if you aren't using index hints what about periodically building a redundent index and then drop the fragmented one? Not sure if...
February 22, 2012 at 8:25 am
Jeremy... (2/22/2012)
Where FM.Openeddate = getdate()
did not work. It took me...
February 22, 2012 at 8:16 am
Viewing 15 posts - 13,951 through 13,965 (of 26,484 total)