Forum Replies Created
Viewing 15 posts - 48,511 through 48,525 (of 49,552 total)
-
RE: presenting 25 sorted records from table with 150,000 records
The clustering key refers to the columns that make up the clustered index. Nothing fancier than that.
So, if your clustered index is on the field ClientID, your sample queries 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Column Extraction
{} are curly brackets
EXEC (@SQL)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: presenting 25 sorted records from table with 150,000 records
The concept of row number is a meaningless one. In a table with a clustered index, the clustering key is the only 'identifier' of row location
Try a nonclustered index 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Unusual performance issues
This sounds familiar...
How much memory is on the server? What service pack of SQL 2005 are you using?
There were some memory-related bugs in SQL 2005 RTM and SP1. If 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 70-431 simulations question
Forgive me for answering the retorical question...
I would guess by having the end result different from what was required, or not been able to work out how to do 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 70-431 simulations question
On the server exam, all the sim questions had a 'reset' option, which set the sim back to how it started. So what I did was to fiddle with each...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 70-431 simulations question
I wouldn't bet on 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 70-431 simulations question
I wrote 431 before the sims were added, so this isn't directly related. I did sims in a Server 2003 exam.
I had 2 or 3 sims on active directory, 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Optimising a report to re-use query plans and use the correct indexes.
given a choice between those two, go for properly parameterised dynamic SQL using sp_executesql
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Help with scheduling/configuring a Profiler trace
You can use profiler to create the script file. Open profiler, set all the options you want, including end time, then go to the file menu and select the option...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Bad execution plan ?
Do you have indexes on t1.ClientID and on the join columns? If so, are they been used?
The order that the joins and where clause are done in depends on, amoung...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Optimising a report to re-use query plans and use the correct indexes.
sp_executesql does not recompile on every execution. The execution plans for adhoc SQL are also cached along with procs. The difference is that the seperate pieces of sql executed by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Dynamic drop/create for Foreign Key
I wrote the following a while back when I needed to drop and recreate primary keys. I've just included the foreign key parts.
Warning, this is rough code and needs 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Help On Trigger
Can't see any reason, unless there are no rows that satisfy the conditions "FINISHTIME = '---'" and 'RMJOB.RMJOBID = PREPLOG.RMJOBID'
If you do a select for those conditions, what do 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: "Governor" for select sql applications?
It does, but the governor is enabled either a server level or per connection. All the governor will do is prevent very expensive queries from been run, depending 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 48,511 through 48,525 (of 49,552 total)