Viewing 15 posts - 17,326 through 17,340 (of 22,206 total)
Enterprise or Express or Developer, those are all database servers. It sounds like you want the client tools. That's Management Studio and can be installed seperately from any of the...
May 29, 2009 at 6:43 am
So the estimated & actual rows are the same? Actual number of executions, rebinds, rewinds... There is more data to it than just the operators. Sorry, just trying to understand...
May 29, 2009 at 6:34 am
GilaMonster (5/29/2009)
Lurking a fair bit here at the moment, cause there's little better to do. Hence I'm catching this kinda stuff early.
Got no major projects that I'm busy with, just...
May 29, 2009 at 6:29 am
I do hate doing this, but those are both estimated plans. Can you post the actual plans?
As to why you're getting a seek or scan, if you look at the...
May 29, 2009 at 5:33 am
David Burrows (5/29/2009)
Grant Fritchey (5/28/2009)
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German...
May 29, 2009 at 5:24 am
Are there other columns in the table? Do you know what a foreign key (FK) is? Maybe this is a FK to another table where you can look up what...
May 28, 2009 at 5:07 pm
You just schedule it to run every x number of minutes/hours, however often you or the the business have decided it needs to be run, and start it at 11:15...
May 28, 2009 at 12:24 pm
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German Shephard, Maximus. He's a...
May 28, 2009 at 12:20 pm
Don't worry Roy, I've got your back. I can't stand cats either.
May 28, 2009 at 11:47 am
I suspect you're seeing parameter sniffing (do a search on that term for possible solutions). I'm saying this based on the fact that you see this: '[woon_ptc]=[@P1]' in the first...
May 28, 2009 at 10:36 am
If it expires, it usually means it can get overwritten or removed by the backup process, so you might want to watch for that. The real question is, how often...
May 28, 2009 at 10:27 am
Lynn Pettis (5/28/2009)
Anyone catch this little gem?
I didn't even read what he said...
You don't suppose it's our favorite emmveepee that was so desperate to convince us all that we...
May 28, 2009 at 10:24 am
Pradyothana Shastry (5/27/2009)
May 28, 2009 at 10:21 am
GilaMonster (5/28/2009)
Roy Ernest (5/28/2009)
BTW, the echo guy is strange. He has been doing this quite often. Or give an answer without reading the question. :hehe:
Or posting bad advice (truncate tran...
May 28, 2009 at 8:21 am
stonecold560 (5/28/2009)
Abhay,So that means when I first did the backup manually it picked up all the trasacations?
Each transaction log backup gets all the logged operations to...
May 28, 2009 at 6:53 am
Viewing 15 posts - 17,326 through 17,340 (of 22,206 total)