Viewing 15 posts - 3,976 through 3,990 (of 6,679 total)
Paul White NZ (3/30/2010)
CirquedeSQLeil (3/30/2010)
tosscrosby (3/30/2010)
Paul White NZ (3/30/2010)
WayneS (3/30/2010)
March 30, 2010 at 2:15 pm
HowardW (3/30/2010)
Jeffrey Williams-493691 (3/29/2010)
SQL will then automatically create a log file in the default location of the default initial size which you can then move/resize.
Do not do this - unless...
March 30, 2010 at 2:13 pm
You can query the backup table in MSDB to get the backup size. The size of the backup will show how much space was being used in the data...
March 30, 2010 at 2:02 pm
HowardW (3/29/2010)
I believe the steps you'll need to take are:
1) Detach the database
2) Rename/delete the old log...
March 29, 2010 at 1:35 pm
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/2010)
March 29, 2010 at 7:04 am
Perry Whittle (3/28/2010)
March 28, 2010 at 6:04 pm
Yes, the system will continue to take more memory as needed up to the max memory setting. If SQL Server is taking more the 44GB of memory, then you...
March 28, 2010 at 5:59 pm
It really depends upon the SAN. For one particular SAN, we were looking at mirroring the database volumes and daily performing a snap clone of the mirrored volume. ...
March 28, 2010 at 5:45 pm
Asif-414084 (3/28/2010)
I installed SQL 2008 on the same box that has 2005 and SQL 2008 cannot be the default instance. The default instance is called "MSSQLSERVER" which...
March 28, 2010 at 5:39 pm
Are you on x64 hardware with SQL Server 2008 x64 version? Did you set the max memory for SQL Server to 46GB?
If so, then yes - that is as...
March 28, 2010 at 5:36 pm
Without knowing a lot more about how you are setup and configured, my first thought would be to investigate the capabilities of the SAN you are using.
Each SAN has different...
March 28, 2010 at 12:06 pm
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/2010)
If you look at the calculation - it is not performing a calculation on getdate(), but rather on the results from the datediff calculation.
So it...
March 28, 2010 at 11:44 am
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/2010)
I don't like using a different seed date, mostly because it only works for days and I like having something that works for all.
That code...
March 28, 2010 at 11:43 am
Paul,
If you look at the calculation - it is not performing a calculation on getdate(), but rather on the results from the datediff calculation.
I know you disagree with using 0...
March 28, 2010 at 9:07 am
Animal Magic (3/27/2010)
i always just use left(getdate(),11). so i would just use
select * from datestable
where mydate between left(getdate() -1,11) and left(getdate(),11)
This is one of the slowest methods available....
March 27, 2010 at 4:16 pm
Viewing 15 posts - 3,976 through 3,990 (of 6,679 total)