Viewing 15 posts - 37,471 through 37,485 (of 49,552 total)
Just checked out the local news. There have been some riots in Mpumalanga, the province to the east of where I live and also in the Western Cape, mostly in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 8:38 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 6:42 am
http://msdn.microsoft.com/en-us/library/ms175513.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 5:27 am
Viewing 15 posts - 37,471 through 37,485 (of 49,552 total)