Viewing 15 posts - 18,271 through 18,285 (of 49,552 total)
Check what it's waiting for (doesn't have to be lock waits). Also check if there's massive differences in the row counts (unlikely since there are no predicates, but possible)
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
June 4, 2012 at 1:59 pm
pdanes (6/4/2012)
GilaMonster (6/4/2012)
Ok, now I see the difference...
Sorry, I ran out for some food.
That's changed the logical meaning of the query. The first query is a left join, the filter...
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
June 4, 2012 at 1:43 pm
I'm not a fan of columns with multiple data values in them, or columns I need to do bitwise operations on. With the current design it's trivial to find what...
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
June 4, 2012 at 1:41 pm
You run the risk of being considered over-qualified. A masters degree isn't going to magically get you a job.
I'd say, if you want to study further for the sake of...
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
June 4, 2012 at 12:05 pm
Try breaking the query down to use an intermediate temp table rather than a CTE, see if that helps at all. Maybe try breaking it down even further with more...
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
June 4, 2012 at 12:01 pm
Don't waste your time. Partitioning is not for performance. It's for ease of maintenance, bulk loads or removal of data from a table and possibly spreading the data over multiple...
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
June 4, 2012 at 11:56 am
Ok, now I see the difference...
That's changed the logical meaning of the query. The first query is a left join, the filter is done on the let-hand table of a...
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
June 4, 2012 at 11:22 am
isuckatsql (6/4/2012)
Wow, that was easy!I thought you had to reference the partitioned part of the table in the query.
I guess not!
Thanks
The whole point of partitioning is that it is transparent...
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
June 4, 2012 at 11:05 am
isuckatsql (6/4/2012)
I cant get even get the select count to work!
The one in the initial post? It won't work, it's Oracle syntax not SQL Server
Do a count and filter on...
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
June 4, 2012 at 10:48 am
Marius.D (6/4/2012)
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
June 4, 2012 at 10:43 am
I can't see a difference between queries 1 and 2... Did you paste the right one in
You should also note that because you have a filter on the right-hand 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
June 4, 2012 at 10:37 am
A view won't help. Views are nothing more than saved select statements.
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
June 4, 2012 at 10:17 am
That's not valid T-SQL syntax, it's not going to work.
The article that you found was for Oracle.
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
June 4, 2012 at 10:14 am
Mick Opalak (6/4/2012)
We can try that, but we'll have to find a window to bring down production.
For what? CheckDB is an online operation. Will add lots of load to 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
June 4, 2012 at 10:10 am
There is no way to delete without logging.
You can set the log to a fixed size, but if it fills every single query that tries to modify the database...
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
June 4, 2012 at 10:03 am
Viewing 15 posts - 18,271 through 18,285 (of 49,552 total)