Viewing 15 posts - 37,486 through 37,500 (of 49,566 total)
ps (7/23/2009)
Express edition (which is free) might not be useful to you as the maximum database size if 4GB.
Good catch.
In this case, I recommend getting developer edition. It's...
July 23, 2009 at 8:23 am
Grant Fritchey (7/23/2009)
There was a report on the radio of very severe rioting in SA.
There is?
July 23, 2009 at 8:20 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 23, 2009 at 7:23 am
The only time a scan can be faster than a seek is when there are multiple seeks against the same table (in clause, multiple ORs, inner table of a nested...
July 23, 2009 at 7:19 am
Lowell (7/23/2009)
I'll download one from redgate and report back to see if I think it would be of any use.
RedGate's log reader does not work on SQL 2005 databases....
July 23, 2009 at 7:12 am
Yeah, I have.
It turns out that the insert that's deadlocking is not the only insert in the transaction, which turns the deadlock from inexplicable to quite expected. Should have checked...
July 23, 2009 at 7:03 am
psemenye (7/23/2009)
Do I have to install SQL server 2005?
Yes
Will SQL server 2005 Management Studio Express do the job? (I have been told that this may have some limitations)
No. Management studio...
July 23, 2009 at 6:58 am
By using STOP AT, you're saying that you want to stop the restore at a particular point in time. No transactions after that point can be restored. You cannot then...
July 23, 2009 at 6:42 am
July 23, 2009 at 6:39 am
That setting's default in 2008, designed to prevent people from doing a change on a table (far too often big table in production) saving and then finding that their table...
July 23, 2009 at 6:32 am
You can check the default trace. It should store that event, but it doesn't keep the data forever (5 files of 20MB each). If it's not in the default trace...
July 23, 2009 at 5:49 am
If you turn it off then the optimiser can't create stats in order to get an estimate of rows affected by a query. If it can't get that estimate, it...
July 23, 2009 at 5:47 am
Jeff Moden (7/22/2009)
I can't believe this isn't handled automatically when you tell it to gen the script as SQL Server 2000.
It is, at least in SP3. I generated a script...
July 23, 2009 at 5:35 am
That's an automatically created statistics set. The user didn't run anything manually, they ran a query, the query optimiser decided it needed stats that didn't exist and since the db...
July 23, 2009 at 5:27 am
Don't use sp_updatestats. That only updates stats that the engine thinks are outdated. Use UPDATE STATISTICS to be sure that the stats do actually get updated.
As for exec plan on...
July 23, 2009 at 5:06 am
Viewing 15 posts - 37,486 through 37,500 (of 49,566 total)