Lynn Pettis

Forum Replies Created

Viewing 15 posts - 13,951 through 13,965 (of 26,486 total)

RE: Can we setup mirroring with two different instance with a same server.

No.

February 24, 2012 at 7:31 pm

#1451667
RE: Are the posted questions getting worse?

Ray K (2/24/2012)
OH FOR CRYING OUT LOUD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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

#1451660
RE: Can we setup mirroring with two different instance with a same server.

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

#1451658
RE: Are the posted questions getting worse?

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

#1451654
RE: Are the posted questions getting worse?

Ray K (2/24/2012)
OH FOR CRYING OUT LOUD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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

#1451653
RE: Current Date issue in where clause

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

#1450570
RE: Current Date issue in where clause

MysteryJimbo (2/22/2012)
Lynn Pettis (2/22/2012)
Jeremy... (2/22/2012)
MysteryJimbo (2/22/2012)
I dont mean to be pedantic but for accuracy I'd want to see this query as a between and in a stored procedure with default...

February 22, 2012 at 1:11 pm

#1450529
RE: Reindexing issue on SQL Server 2005 Standard Edition

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

#1450495
RE: How Can we Create Indexed Views In Sql Server 2005

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

#1450462
RE: Current Date issue in where clause

Jeremy... (2/22/2012)
MysteryJimbo (2/22/2012)
I dont mean to be pedantic but for accuracy I'd want to see this query as a between and in a stored procedure with default values so it...

February 22, 2012 at 11:04 am

#1450461
RE: How Can we Create Indexed Views In Sql Server 2005

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

#1450424
RE: Alternative to cursors?

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

#1450409
RE: Current Date issue in where clause

Jeremy... (2/22/2012)
Lynn Pettis (2/22/2012)
Jeremy... (2/22/2012)
I am trying to write a query that pulls our new orders for the current day.
Where FM.Openeddate = getdate()
did not work. ...

February 22, 2012 at 8:45 am

#1450368
RE: Reindexing issue on SQL Server 2005 Standard Edition

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

#1450349
RE: Current Date issue in where clause

Jeremy... (2/22/2012)
I am trying to write a query that pulls our new orders for the current day.
Where FM.Openeddate = getdate()
did not work. It took me...

February 22, 2012 at 8:16 am

#1450336

Viewing 15 posts - 13,951 through 13,965 (of 26,486 total)