Viewing 15 posts - 2,086 through 2,100 (of 18,923 total)
Check up that series, might give you great pointers :
October 13, 2011 at 7:49 am
You can stop the trace, restart it (that clears it all), run the report, and pause the trace right away.
once you find the correct row you can apply filters for...
October 13, 2011 at 7:48 am
Nice rant.
@jc-2 (not short for Jesus-Christ).
You were doing some headway lately but now you're getting back to your old habits. Plz keep up the <previous> good work.
October 13, 2011 at 7:43 am
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best...
October 13, 2011 at 7:36 am
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option for...
October 13, 2011 at 7:14 am
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option for that.
I'd go...
October 13, 2011 at 6:30 am
Greg Edwards-268690 (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
My dad used to fly when I was a kid.
Never got to go up and see the...
October 13, 2011 at 5:31 am
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option for that.
I'd go with the...
October 13, 2011 at 4:47 am
Start the trace, run the report (make sure to hit refresh to get new dataset).
Then copy and paste the command sent here so we can see that for starters.
October 13, 2011 at 4:47 am
The 99% correct answer is to work on the base table's indexing.
Please post the actual execution plan and we'll see what we can do.
Also the list of index with their...
October 12, 2011 at 11:47 am
+1 on the going backward point.
But for readability's sake :
IF @flag = 'ST'
BEGIN
IF ( @@ERROR =...
October 12, 2011 at 11:38 am
Why do you want to do that? I've never seen a business case where this is required.
Also, any reason why you can't do that client side? Seems like...
October 12, 2011 at 11:35 am
It will if this is the best way to access the data.
Now keep in mind that such a query would need to do a bookmark lookup to fetch the columns...
October 12, 2011 at 11:32 am
Roy Ernest (10/12/2011)
Redgate is sending a DBA to space. And somebody just tweeted asking if it was Grant "The Mon***" who was going to space. 🙂
That's got to be the...
October 12, 2011 at 11:28 am
I have sql 2K5 here and this is a regular ERP.
The min size for the logs which only includes the header is 125 KB.
Now for 2K8 + sharepoint I have...
October 12, 2011 at 10:56 am
Viewing 15 posts - 2,086 through 2,100 (of 18,923 total)