Viewing 15 posts - 376 through 390 (of 1,518 total)
Thank you!
__________________________________________________________________________________
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]
November 21, 2010 at 6:41 am
Is there a way to download extractor.exe separately? Or do I need to download the whole source from QUEST 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]
November 19, 2010 at 11:19 am
george sibbald (11/9/2010)
sys.master_files is the 2005 and above equivalent of sysaltfiles. Expect sysaltfiles to be deprecated, so I recommend getting in the habit of using sys.master_files.
Thanks, I saw that, I'm...
__________________________________________________________________________________
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]
November 9, 2010 at 7:48 am
Steve Jones - SSC Editor (11/8/2010)
SELECT fileid ,
groupid ,
size ,
...
__________________________________________________________________________________
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]
November 9, 2010 at 2:25 am
Will do, 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]
November 5, 2010 at 9:30 am
Perry Whittle (11/4/2010)
SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity...
__________________________________________________________________________________
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]
November 4, 2010 at 7:12 pm
Have a look at this link:
http://www.mssqltips.com/tip.asp?tip=1721
__________________________________________________________________________________
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]
November 4, 2010 at 7:04 pm
Perry Whittle (11/4/2010)
SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity...
__________________________________________________________________________________
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]
November 4, 2010 at 6:59 pm
You only need to log in to the passive node (Node 4) and in the setup click "Add node to a SQL Server Failover cluster".
You will have to do this...
__________________________________________________________________________________
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]
November 4, 2010 at 1:10 pm
I just found out that on the remote server, the MSDTC setting is on "Mutual Authentication Required"; it should be on "No Authentication Required".
I will change it and restart 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]
November 4, 2010 at 11:03 am
Perry Whittle (11/3/2010)
Do you have access to the VI client? You can create rules regarding VM movement when DRS is enabled on the ESX cluster
Unfortunately not, no expertise and no...
__________________________________________________________________________________
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]
November 3, 2010 at 10:49 am
Perry Whittle (11/3/2010)
What makes you think it's VMotion, do you supsect manual or automatic VM movement?
One thing to check would be the network stack between the physical and virtual networks,...
__________________________________________________________________________________
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]
November 3, 2010 at 10:41 am
praveen_vejandla (10/28/2010)
We want to failover to mirror server and then run applications against mirror server for 2-3 hours
and failback...
__________________________________________________________________________________
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 28, 2010 at 8:01 am
hotfix4sql (10/27/2010)
__________________________________________________________________________________
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 27, 2010 at 1:12 pm
Thanks both for your responses.
__________________________________________________________________________________
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 27, 2010 at 12:53 pm
Viewing 15 posts - 376 through 390 (of 1,518 total)