Viewing 15 posts - 45,001 through 45,015 (of 49,571 total)
We get tax rebates. Not sure of the full details. I don't do the tax myself and the tax consultant I have knows what to claim and how.
August 16, 2008 at 3:14 am
There's the cause of the bad plan straight off. For the optimiser, doing a RID lookup of 45 rows in a table with more than 300000 is very cheap and...
August 15, 2008 at 3:21 pm
David Branscome (8/15/2008)
Shrink file has the advantage of reducing the size of the database and reducing the amount of disk that has to be covered to query a table's data.
And...
August 15, 2008 at 3:20 pm
Interesting discussion.
For the last 4 years I've worked for a company (or more accurately for a manager) that was more than generous about training. I was allowed to buy any...
August 15, 2008 at 2:29 pm
SQL Noob (8/15/2008)
in most cases where tables and indexes have to share the same disk you have to denormalize depending on your environment to get performance.
I'm going to disagree...
August 15, 2008 at 1:59 pm
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums.
No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic553744-92-1.aspx
August 15, 2008 at 1:46 pm
Alter trigger ... with append was deprecated in SQL 2000 and removed in SQL 2005.
What are you trying to do?
August 15, 2008 at 1:40 pm
KB (8/15/2008)
What kind of permissions do a user need to have to connect to a linked server?
Virtually none, which is, IMHO sometimes a problem.
What's wrong is that you haven't set...
August 15, 2008 at 1:31 pm
GSquared (8/15/2008)
I just installed a trial copy of 2008 today. Tested both Intellisense and debugging on 2008 and then...
August 15, 2008 at 1:18 pm
Those are the estimated execution plans you have.
Is there any chance of you running the query in management studio with the "Include actual execution plan" option on?
Dev could have different...
August 15, 2008 at 11:43 am
Task manager doesn't show AWE memory. I think there's a bit more to it as well.
I personally don't trust it for SQL memory. Other stuff's ok.
August 15, 2008 at 11:41 am
A few comments...
Replicated databases do not require full recovery mode. That's true of log shipping and database mirroring. Replication works fine in any recovery mode.
Don't shrink databases on a...
August 15, 2008 at 11:40 am
rbarryyoung (8/15/2008)
Can you just give us the before and after *.SQLPlan files?
Problem is those also have the query included inside them.
August 15, 2008 at 11:20 am
Better but you're still assuming that there will only be one row in the inserted tables, example the following line
SET @ProductID=(select ProductID from inserted)
There could be any number of rows...
August 15, 2008 at 11:18 am
MrBaseball34 (8/15/2008)
August 15, 2008 at 11:14 am
Viewing 15 posts - 45,001 through 45,015 (of 49,571 total)