Viewing 15 posts - 91 through 105 (of 1,518 total)
Robert Davis (7/17/2012)
__________________________________________________________________________________
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]
July 18, 2012 at 3:04 am
Thanks both for your suggestions.
__________________________________________________________________________________
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]
July 17, 2012 at 2:41 am
Thank you all for your comments so far.
Derek and Timothy:
Thank you for the kind words.
Chris:
Yes, developers definitely have a role to play in making sure stats and fragmentation are addressed...
__________________________________________________________________________________
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]
July 10, 2012 at 3:51 am
With Service Broker you can have multi-threading so your queue can initiate multiple copies of the activation procedure, each picking up a single message from the queue. That could speed...
__________________________________________________________________________________
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]
June 15, 2012 at 3:55 am
Leo.Miller (6/10/2012)
...I've not been able to find any notes on this, but is there a requirement that each node have unique Drive letters (excluding c:)?
...
No, in fact it is recommended...
__________________________________________________________________________________
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]
June 15, 2012 at 3:47 am
You do need a quorum disk as the cluster witness.
This could be just a network share hosted in a separate file server (network and file share majority, see 1st...
__________________________________________________________________________________
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]
June 15, 2012 at 3:41 am
Lynn Pettis (5/31/2012)
Unless something has changed with COPY ONLY full backups, it was my understanding that they could not be used as the base for a recovery.
They can.
I was not...
__________________________________________________________________________________
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]
May 31, 2012 at 12:08 pm
Thank you all for the responses.
Certainly VMs present an advantage in that sense.
Regarding physical servers, I still think it is preferable to copy the binaries, registry (under SQL node) and...
__________________________________________________________________________________
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]
May 31, 2012 at 11:58 am
Jan.Sundbye (5/30/2012)
In my ConfigurationFile.ini:ACTION="Install"
is the first parameter. It seems like the value for ACTION is missing in your ConfigurationFile.ini
That line is also the first one in my file.
__________________________________________________________________________________
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]
May 30, 2012 at 9:53 am
OK, got it to work with help from http://www.progtown.com/topic374931-sql-server-2012-rtm.html.
Opened regedit.exe as Administrator.
Then:
On [HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\FileExtensionMapping\PRC] I changed the Default key value to {B5A506EB-11BE-4782-9A18-21265C2CA0B4}.
On [HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\Default Editors\PRC] 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]
May 28, 2012 at 2:20 pm
Very interesting topic. I have wrestled with this in the past, and have ended up choosing the specialization path. A lot of it has to do with where one ends...
__________________________________________________________________________________
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]
May 26, 2012 at 6:02 am
I spend around 4-5 hrs a week reading articles and other online material, as well as attending webinars, usually at work. Our management has no issues with that, as long...
__________________________________________________________________________________
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]
May 19, 2012 at 5:54 am
I would move away from shared storage, now that we have SQL 2012 AlwaysOn Availability Groups.
In our organization, at least, we have had a bad experience with shared storage in...
__________________________________________________________________________________
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]
May 18, 2012 at 2:30 pm
I will be going through the same exercice in a few days, installing AlwaysOn Avail Groups on a cluster.
Have you configured the listener on default port 1433, on all replicas?
__________________________________________________________________________________
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]
May 18, 2012 at 2:17 pm
We are itching to upgrade our critical production servers to SQL 2012 to take advantage of AlwaysOn Availability Groups for HA/DR. At the moment we use Windows clustering for HA...
__________________________________________________________________________________
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]
May 1, 2012 at 6:24 pm
Viewing 15 posts - 91 through 105 (of 1,518 total)