Viewing 15 posts - 1,336 through 1,350 (of 1,518 total)
Adam Bean (3/21/2008)
Marios Philippopoulos (3/19/2008)
Also:Case matters. Refer to your objects in the exact case in which they were created. Not doing so will result in recompilations.
Really? Do you a link...
__________________________________________________________________________________
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]
March 21, 2008 at 6:22 pm
TheSQLGuru (3/21/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]
March 21, 2008 at 6:16 pm
I got it to work through scripting!
EXEC sp_addlinkedserver 'targetServer\targetInstance, N'SQL Server';
GO
Is there a bug in the GUI in SSMS for linked-server creation??
__________________________________________________________________________________
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]
March 20, 2008 at 1:20 pm
I see this issue reported before on this site: http://www.sqlservercentral.com/Forums/Topic353977-146-1.aspx
Does Kerberos auth. need to be enabled for this to work?
I don't want to use SQL Auth. in the linked server.
__________________________________________________________________________________
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]
March 20, 2008 at 12:56 pm
I googled "trace flag 1118" and this was at the top of the list:
PRB: Concurrency enhancements for the tempdb database
support.microsoft.com/kb/328551
__________________________________________________________________________________
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]
March 20, 2008 at 9:46 am
Look for nasty queries, ones with lots of IO. Your high tempdb utilization is likely due to inefficient execution plans.
In SQL 2005 there are powerful tools to allow you great...
__________________________________________________________________________________
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]
March 20, 2008 at 9:43 am
chris (3/20/2008)
However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value....
__________________________________________________________________________________
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]
March 20, 2008 at 9:05 am
No worries, it wasn't meant like that... 🙂
I was concerned that maybe I had missed something all this time.
This flag is good to know, something new I learned this morning.
Thanks!
__________________________________________________________________________________
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]
March 20, 2008 at 9:02 am
Buxton69 (3/20/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]
March 20, 2008 at 8:14 am
net (3/19/2008)
thank to reply,
It was asked for me to create a database following some "best practice",
one of these was to set the number of files to match the number of...
__________________________________________________________________________________
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]
March 19, 2008 at 4:54 pm
A couple of other things to consider when concerned about low cache-hit ratio:
Interleaving DML and DDL statements in code. Put all your DDL statements (such as temp-table creation etc) at...
__________________________________________________________________________________
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]
March 19, 2008 at 4:27 pm
Also:
Case matters. Refer to your objects in the exact case in which they were created. Not doing so will result in recompilations.
__________________________________________________________________________________
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]
March 19, 2008 at 4:19 pm
The procedure cache does not benefit from AWE memory extensions. The only benefit of AWE memory is on the data cache.
And, yes, do always qualify your database objects (tables, sprocs...
__________________________________________________________________________________
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]
March 19, 2008 at 4:07 pm
GSquared (3/19/2008)
GilaMonster (3/19/2008)
Shorter transactions means less blocking and less chance of deadlocks. In turn means less work to do. Always a good thing. 😀
If you're using transactions to reduce 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]
March 19, 2008 at 1:32 pm
Lynn Pettis (3/19/2008)
I mean, there isn't much you can do when connected to SSIS using SSMS. You import and export packages, you run packages, that's about it.
Agreed.
Precisely who...
__________________________________________________________________________________
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]
March 19, 2008 at 1:24 pm
Viewing 15 posts - 1,336 through 1,350 (of 1,518 total)