Viewing 15 posts - 931 through 945 (of 1,518 total)
Jeff Moden (9/6/2008)
Heh... if YOU had a question on what it does, others will to. Time to break out the grossly underused "dash dash" function. 😉
I still don't fully...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2008 at 5:07 am
talentguy123 (9/5/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2008 at 11:41 am
Peso (9/5/2008)
For this set of records, the query then group them...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2008 at 5:02 am
Peso (9/5/2008)
Thank you for the feedback.It's nice to see the query went from about 800 ms / 15500 reads down to 15 ms / 56 reads.
The only drawback I see...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 5, 2008 at 11:16 am
Thank you for all this work!
I will talk to the developer about changing the query accordingly.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 5, 2008 at 3:58 am
I'm sorry, you are absolutely right, this does work indeed (returns 2 rows as expected):
select * from test1
left join test2
on test1.corpoid = test2.corpoid
where test1.corpoid is NOT null and test2.corpoid is...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 4:22 pm
PW (9/4/2008)
Nope, that's not true in this case.
The check...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 4:12 pm
It's just dawned on me that the original query makes no sense!
The D and D2 tables are joined (left join) on the COID column, but then the filter "D2.CORPOID...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 3:58 pm
Here is the plan of the original query (pls see attached).
I will now try the suggested modified query and will post the plan shortly.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 1:30 pm
Grant Fritchey (9/4/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 11:53 am
Peso (9/4/2008)
Marios Philippopoulos (9/4/2008)
D.COID
,MIN( D.COTID )
FROM
dbo.tblName AS D
LEFT JOIN
dbo.tblName AS D2
ON
D.COID = D2.COID
WHERE
D.CCBID = 100000 AND
D.CCBID = D2.CCBID AND
D2.COID IS NULL AND
D.COID IS NOT NULL...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 11:20 am
Grant Fritchey (9/4/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 9:12 am
Grant Fritchey (9/4/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 8:18 am
I know very little about SANs but one thing that's always bothered me is the fact that multiple drive letters in each server can be striped across a single physical...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 4, 2008 at 8:09 am
sudhakara (9/3/2008)
What's sQL's max memory setting? 10 GB
What else in running on the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 3, 2008 at 9:45 am
Viewing 15 posts - 931 through 945 (of 1,518 total)