Viewing 15 posts - 556 through 570 (of 1,518 total)
Thanks all for the helpful discussion, keep it coming!
Another issue, which I think has not been brought up yet, is troubleshooting backup/restore errors when they occur.
Working with a 3rd...
__________________________________________________________________________________
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]
October 2, 2009 at 9:25 am
danielmanke (9/25/2009)
__________________________________________________________________________________
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 25, 2009 at 11:01 am
danielmanke (9/22/2009)
When I use the -g switch, the max free size is not increasing. I am assuming it 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 24, 2009 at 2:17 pm
Paul White (9/15/2009)
Marios Philippopoulos (9/15/2009)
It has worked for me though; I had the same problem as in this post, ran the DBCC statement and the issue was corrected (temporarily).
Yeah -...
__________________________________________________________________________________
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 15, 2009 at 2:42 pm
vijay_shanthi23400 (9/15/2009)
I am vijay , SQL DBA.. I am facing one problem with update statistics.. can any one help me out of this..
Below is the error i...
__________________________________________________________________________________
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 15, 2009 at 11:53 am
namrata.dhanawade (9/15/2009)
In my first two attempts, the email was delivered successfully, however now it gives me the message
'Mail queued'
Any reason, why this should happen?
I...
__________________________________________________________________________________
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 15, 2009 at 7:50 am
Paul White (9/14/2009)
Marios Philippopoulos (9/14/2009)
Sorry, my bad, I meant:
dbcc freesystemcache ('all')This will address the problem, while helping you avoid an instance restart.
Really sorry Marios, but still no go 🙂
Books Online
__________________________________________________________________________________
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 15, 2009 at 7:37 am
Paul White (9/14/2009)
Marios Philippopoulos (9/14/2009)
__________________________________________________________________________________
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 14, 2009 at 4:13 pm
danielmanke (9/14/2009)
Sunday was a day for Golf and football... I did see your request for what the CLR (C# code) does. Unfortunately, the application is an off the shelf
ERP...
__________________________________________________________________________________
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 14, 2009 at 7:42 am
danielmanke (9/11/2009)
It seems that 8074KB should be plenty of memory to run a simple function...
How many times is this function being executed though?
That would contribute to the mem...
__________________________________________________________________________________
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 11, 2009 at 10:48 am
Paul's last post stirred up my memory too! 🙂
Here is some code (probably similar to the one Paul just posted) that returns all VAS fragments (sorted by size, 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]
September 11, 2009 at 9:20 am
Rowan (9/9/2009)
No it's in full recovery mode
Best if you switch it to simple recovery then; it doesn't look like you are taking transaction-log backups (are you?), and switching to SIMPLE...
__________________________________________________________________________________
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 9, 2009 at 5:15 pm
Is your database on simple recovery mode?
__________________________________________________________________________________
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 9, 2009 at 1:48 pm
I have only been able to use the DTA on single SQL statements effectively in the past.
I think the reason you did not get any results is that the DTA...
__________________________________________________________________________________
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 9, 2009 at 1:18 pm
Elliott W (9/9/2009)
Which option makes more sense?
I know you are going to hate this.. But it depends on a lot of factors..
First off, I like the idea of a...
__________________________________________________________________________________
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 9, 2009 at 12:58 pm
Viewing 15 posts - 556 through 570 (of 1,518 total)