Viewing 15 posts - 46,591 through 46,605 (of 49,552 total)
Run
SELECT @@version
It will say what edition you're running.
From what I recall, the editions are:
Express (free)
Workgroup
Standard
Enterprise
Developer (enterprise features, not for usage in producion system)
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
May 13, 2008 at 12:31 am
Can you post query, table schema and index definitions please. Can't say anything for sure without seeing those.
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
May 13, 2008 at 12:27 am
jeff.williams3188 (5/12/2008)
Off the top of my head, I would suspect that you are seeing the checkpoint operation in action.
Sounds very plausable.
At the times that the disk queue length goes up,...
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
May 13, 2008 at 12:15 am
Paul Fechner (5/12/2008)
How do i attach an sql exec plan for all you experts to review?
As I said above
(saved as a .sqlplan file, zipped and attached to the thread)
If...
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
May 12, 2008 at 11:56 pm
I'll take a look, but I'm going to need more than 1 row of data. Can you give me data for all the dest airports like 'b%' (the ones you...
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
May 12, 2008 at 11:53 pm
Table doesn't have a single clustered index. But it have non clustered index on mid.
Will it help to resolve this running total issue ?
Only if the smallest MID was the...
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
May 12, 2008 at 8:05 am
Does anyone know of any such logging?
Profiler. 🙂
Profiler should be included in workgroup. It's just Express that doesn't have it.
You could also log the sys.dm_exec_requests to a table. Run 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
May 12, 2008 at 7:58 am
You'll get an error if a constraint exists and you try to create another with the same name.
Since they're on Temp Tables and the constraint is dropped when the...
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
May 12, 2008 at 6:59 am
Probably a different query plan was generated with the clustered index present that required less of the table to be locked.
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
May 12, 2008 at 6:38 am
Don't name constraints created on temp tables. Object names (including constraint names) must be unique.
When you create a temp table, SQL puts a hash value on the end to...
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
May 12, 2008 at 6:37 am
I've seen this a number of times, over on http://www.thedailywtf.com 😀
Get out of that company while you still can. That design is one of the things that sounds nice 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
May 12, 2008 at 5:56 am
Are there any jobs running regularly?
Is the DB set to autoclose?
Is the DB set to Autoshrink?
At the times things go slow, do you see any unusual blocks or waits 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
May 12, 2008 at 5:56 am
Ok, maybe this one...
SELECT depAir.Name AS departureAirportName,
dest.Name AS destination,
TotalFlights,
...
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
May 12, 2008 at 5:45 am
The two Stansteds are because they have different destinations. You want only 1 row per departure airport, regardless of where the flight is going?
I think the 2 rows for Gatwick...
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
May 12, 2008 at 5:27 am
How does this look?
SELECT depAir.Name AS departureAirportName,
dest.Name AS destination,
TotalFlights,
Offers.ARR_AIRPORT,
Offers.DEP_AIRPORT,
LowestPrice,
LowestPrice/NO_ADULTS AS Price,
Offers.DEP_DATE,
Offers.RtnDEP_DATE,
Offers.NO_ADULTS,
DATEDIFF(d, Offers.DEP_DATE, Offers.RtnDEP_DATE) AS duration
FROM cached_offers_flights Offers INNER JOIN
(SELECT DEP_AIRPORT, ARR_AIRPORT, COUNT(*) AS TotalFlights,
MIN(CAST(STANDARD_PRICE...
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
May 12, 2008 at 4:37 am
Viewing 15 posts - 46,591 through 46,605 (of 49,552 total)