Viewing 15 posts - 20,506 through 20,520 (of 49,552 total)
Jason-299789 (2/7/2012)
Hence the question about whether the overhead of the Query Recompile outweighs the associated overhead of paramater sniffing.
It depends. That's only answer possible. Depends on how expensive 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
February 7, 2012 at 8:02 am
derekr 43208 (2/7/2012)
The older style database mirroring (as in 2005 and 2008) will still be there as-is, unchanged.
I thought that a change is 2012 was that the mirror(secondary) database would...
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
February 7, 2012 at 7:57 am
No, the foreign keys will not automatically reference it. If you add a clustered index on a column that is already the PK, the only thing that happens is that...
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
February 7, 2012 at 7:37 am
First things first...
It's not Always On Database Mirroring. Database Mirroring and Always On are two different things. The older style database mirroring (as in 2005 and 2008) will still be...
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
February 7, 2012 at 7:35 am
Cool.
So with Grant's list you have somewhere to start investigating. Post back with more info if you need more help.
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
February 7, 2012 at 7:10 am
No way to answer that.
Those counters are cumulative since SQL started. If the server started last an hour ago, yeah they're high, if the server started 3 days ago, no...
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
February 7, 2012 at 7:08 am
That specific query or any query?
If that specific query, post it here with exec plan, table and index definitions and someone will take a look. If any query in general,...
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
February 7, 2012 at 6:21 am
If you're talking about the execution plan, it means that the query optimiser estimated that the clustered index scan (which is a read of the entire table) was 46% 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
February 7, 2012 at 5:39 am
Without an order by the results are returned in whatever order the last query operator left them in. If all the query did was a scan of an index (and...
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
February 7, 2012 at 4:35 am
Cadavre (2/7/2012)
Shall we get rid of the cursor? Yes, I think we should. 😀
The recursive CTE is still iterating, it's just a lot more subtle about 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
February 7, 2012 at 4:31 am
As I said, you may as well just run CheckDB with repair again since you've already lost data.
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
February 7, 2012 at 4:30 am
Well that saves me the effort of finding the links... 😀
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
February 7, 2012 at 2:54 am
So you discarded an unknown amount of data from your database with no consideration as to the possible consequences or possible alternatives? You have likely lost huge amounts of data...
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
February 7, 2012 at 2:50 am
It's not that max is limited to 5 characters, it's that it is doing a string comparison (the column is varchar), and in string sorting, z is greater than aaa,...
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
February 7, 2012 at 2:00 am
cheetahkatsu (2/6/2012)
1) Should I be running the reindexing stored procedure within a transaction?
Probably not because that prevents the log from been marked reusable between the individual index rebuilds.
2) What 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
February 7, 2012 at 1:57 am
Viewing 15 posts - 20,506 through 20,520 (of 49,552 total)