Viewing 15 posts - 2,776 through 2,790 (of 6,679 total)
Jeff Moden (9/30/2012)
+1. And, you should still change the awful default growth settings to something more reasonable.
Absolutely....
September 30, 2012 at 10:10 am
Wow - so much mis-information...
Tempdb will be resized to its initial size upon restart. If it has grown to 2GB over time - then that is the size it...
September 29, 2012 at 10:23 am
What is the actual version of each instance where this occurs? It could be a bug in the maintenance plan task - where it only performs the backup task...
September 29, 2012 at 10:15 am
I would recommend that you stop using backup devices - setup the maintenance plan or your backup scripts to use a separate file for every backup.
September 29, 2012 at 9:59 am
Evil Kraig F (9/21/2012)
JanTimmermans (9/21/2012)
What we do:
Select ID, Adress, Zipcode
From aTable
Open Cursor
Fetch Next into variables
Do while eof
...
September 22, 2012 at 9:25 am
If the current process is backing up to a single file - at what point is that file initialized? Because, once initialized - all previous log backups are gone.
If...
September 22, 2012 at 9:09 am
It could be related to when the Y:\ drive is actually becoming available. If that was never set as a dependency before - and it was coming up before...
September 19, 2012 at 12:50 pm
And that would be your problem - without the dependencies, SQL Server cannot see the drive. Since SQL Server cannot see the drive - it cannot be started.
September 19, 2012 at 11:51 am
Does the SQL Server cluster resource have a dependency on the Y:\ drive?
September 19, 2012 at 11:37 am
balajisrm (9/15/2012)
But this one is not working for SELECT CONVERT(CHAR(6), '2012-09-15', 112);i mean When we provide a hard coded date.
Because that is not a hard-coded date. It...
September 15, 2012 at 1:35 pm
HEAP's cannot be rebuilt - they will always show fragmentation.
As for the other indexes, how many pages in the index? What are the data types for the indexes? ...
September 15, 2012 at 1:27 pm
In addition to what Grant stated - there is a utility called SQL Server Configuration Manager. Open that and you can see all of the services available for SQL...
September 15, 2012 at 1:17 pm
jrichards54 (9/14/2012)
September 14, 2012 at 4:15 pm
Add another criteria to the where statement in the second pipeline:
Get-ChildItem C:\SSISFILES\Log -Recurse | Where {!$_.PsIsContainer -and $_.LastWriteTime -lt (Get-Date).AddDays(-5) -and $_.Extension -eq ".txt"} | Remove-Item -Force -WhatIf
September 14, 2012 at 1:28 pm
Okay - you need to install SQL Server first. When you get the compatibility warning - continue the install. Once that has finished, then you can apply the...
September 14, 2012 at 1:23 pm
Viewing 15 posts - 2,776 through 2,790 (of 6,679 total)