Viewing 15 posts - 44,656 through 44,670 (of 49,552 total)
Gary Johnson (9/5/2008)
mj obi-wan kenobi (9/5/2008)
Pretty strange behavior in 2k5...
Not really.
In query 1, because the expression in the order by is qualified with the table, it's clearly not 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
September 6, 2008 at 3:48 am
I'm assuming this table has a clustered index?
You can drop and recreate the clustered index and specify the new location on another filegroup. Then go and shrink the file...
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
September 5, 2008 at 12:10 pm
It won't. All the versions of showplan show the same data, just the methods of storing and showing it change.
Look at the seek predicates. If you've got a partial scan,...
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
September 5, 2008 at 11:58 am
Possibly parameter sniffing. When the optimiser compiles the proc, it will optimise the queries based on the current parameter values, and it will optimise all queries in the proc, regardless...
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
September 5, 2008 at 11:37 am
Ok, with 3 columns, populated much the same way as the first. I interleaved the queries to make it as equal as possible
set statistics time on
go
DECLARE @param char(1), @param1 char(1),...
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
September 5, 2008 at 11:25 am
After switching to simple, run a checkpoint. It's the checkpoint that triggers log truncation in simple recovery.
Make very, very sure you take a full backup after switching back to full...
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
September 5, 2008 at 11:10 am
Is there space free within the data file? What does the following return?
exec sp_spaceused
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
September 5, 2008 at 11:04 am
Jack Corbett (8/4/2008)
while searching on a range (column between a and b) will get a scan.
If either the start or the end of the range is sargable, a range...
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
September 5, 2008 at 11:01 am
jluniya (9/5/2008)
So does it mean, the index sequence can be decided on any order? Or is there any logic to decide the index ordering?
There is, and it depends on 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
September 5, 2008 at 10:25 am
When you say 'can't shrink' do you mean it's giving you an error?
Why are you shrinking the data and log files anyway?
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
September 5, 2008 at 10:14 am
Kenneth Fisher (9/5/2008)
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
September 5, 2008 at 10:12 am
Vika (9/5/2008)
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
September 5, 2008 at 9:54 am
Glen (9/5/2008)
And shouldn't the variation of "100 ms" in execution be random ?
In the test I posted the variations were indeed completely random. I'll test later with a couple 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
September 5, 2008 at 9:54 am
You can load the traces into a SQL table (profiler -> save to table or fn_trace_gettable) and then you can query them in SQL. Easier than analysing in profiler.
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
September 5, 2008 at 12:51 am
Database corruption. Do you have an up-to-date backup?
Please run the following and post the output.
DBCC CHECKDB ( < Database name > ) WITH NO_INFOMSGS
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
September 5, 2008 at 12:45 am
Viewing 15 posts - 44,656 through 44,670 (of 49,552 total)