Viewing 15 posts - 526 through 540 (of 1,518 total)
It's a native backup using the compression feature (SQL 2008 SP1 Enterprise Ed., v. 10.0.2531).
What is the backup application log?
Here is the full command:
BACKUP DATABASE [xxxx] TO DISK='....\xxx.BAK' WITH NOFORMAT,...
__________________________________________________________________________________
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]
January 30, 2010 at 4:32 pm
Steve Jones - Editor (1/18/2010)
Two things: can you change another services ( like SSIS) to Local System?
If that works, can you reboot and 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]
January 19, 2010 at 4:01 am
dmoldovan (1/12/2010)
The description I talked about is not taken from the MSDN link you mentioned. By the way, in my opinion the MSDN documentation is weaker and weaker...
This 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]
January 12, 2010 at 7:13 am
Lowfar (1/12/2010)
HiI've found this link useful in the past for performance counters;
http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SSAS.htm
The following link is to a microsoft whitepaper on ssas performance
Cheers
-Matt
Thank you for the prompt reply!
__________________________________________________________________________________
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]
January 12, 2010 at 7:05 am
dmoldovan (1/12/2010)
You can see its description in the "performance monitor":"Working Set is the current size, in bytes, of the Working Set of this process..."
Thanks, but where do you see that...
__________________________________________________________________________________
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]
January 12, 2010 at 6:08 am
John Rowan (1/8/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]
January 8, 2010 at 2:51 pm
abhishek-484864 (1/1/2010)
Thanks a lot for clarifying that. I feel a little dumb though i couldn't understand it 🙂cheers!
Abhishek.
I had the exact same question a few days ago, so don't feel...
__________________________________________________________________________________
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]
January 6, 2010 at 2:10 pm
Ted Thibodeau Jr (1/4/2010)
I suggest you start with...
__________________________________________________________________________________
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]
January 6, 2010 at 1:25 pm
Never mind, I figured it out, it is "Microsoft"...
__________________________________________________________________________________
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]
December 31, 2009 at 12:26 pm
Question on registering for an exam with Prometric:
I'm trying to register online from Canada and I'm asked to enter an exam sponsor, which I take it is the company 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]
December 31, 2009 at 11:29 am
I was able to fix the issue of incompatibility of the Jet Engine with the 64-bit platform by checking the "Use 32-bit runtime" checkbox under Execution Options in the SQL...
__________________________________________________________________________________
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]
December 31, 2009 at 11:05 am
Gift Peddie (12/29/2009)
There is no JET driver for either Itanium or X64 so is a working solution to run SSIS package with Excel.
Thank you for the link, it looks like...
__________________________________________________________________________________
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]
December 29, 2009 at 2:30 pm
When I try to install windowsserver2003-kb829558-x86-enu.exe on my 64-bit server, I get the following error:
This kb829558 is for a different hardware platform.
__________________________________________________________________________________
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]
December 29, 2009 at 2:13 pm
BSavoie (12/24/2009)
I've read that Access & Excel OLE DB drivers will not work on 64 bit version of SQL Server. Could that be it? Hope this helps.
It seems so, 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]
December 29, 2009 at 1:54 pm
Thank you both for your replies, I will follow through and will send an update.
__________________________________________________________________________________
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]
December 4, 2009 at 8:01 am
Viewing 15 posts - 526 through 540 (of 1,518 total)