Viewing 15 posts - 4,516 through 4,530 (of 6,677 total)
jez.lisle (10/5/2009)
CASE
WHEN ASV.[1st_na] IS NOT NULL THEN 'NA1'
WHEN ASV.[completion_date] = CASE
WHEN ASV.[1st_NA] IS NULL THEN ASV.[booking_date]
WHEN ASV.[1st_NA] < ASV.[booking_date] THEN ASV.[1st_NA]
WHEN...
October 5, 2009 at 9:58 am
I don't have time right at this moment to write it all up - but take a look at the previous query we worked on. The rules appear to...
October 5, 2009 at 7:59 am
That's why I keep stating data files - I've had a few systems where they didn't have mdf/ndf files because someone decided to change it. SQL Server doesn't really...
October 4, 2009 at 6:00 pm
Using CONVERT to a VARCHAR(20) will not remove the time portion. And, yes - the method I show is one of the fastest methods for zeroing out the time...
October 4, 2009 at 4:54 pm
If your date is not null, but is actually an empty string - the empty string is evaluated as a 0 which is 19000101. Not sure that is the...
October 4, 2009 at 3:35 pm
Okay, then you have specified multiple files for the restore where you only need to specify one of the backup files.
I am not sure what your intent is with a...
October 4, 2009 at 1:35 pm
It sounds like you did not use or create a mirror backup, but instead striped your backup across multiple files.
If you just put in two files in the backup window...
October 4, 2009 at 9:52 am
The thing I like about the maintenance plans is the fact that I get all of the history for the sub-plans without having to implement anything myself.
A lot of my...
October 4, 2009 at 9:47 am
repent_kog_is_near (10/4/2009)
If the data and index files are separated (mdf and ndf), does it matter where the amount of free space is required/needed?
Yes, your log files should be stable and...
October 4, 2009 at 9:02 am
repent_kog_is_near (10/3/2009)
Do you always beat the Autogrowth before it kicks in (If you suspect from your monitoring that it is going to happen in the next 2 weeks, do you...
October 4, 2009 at 9:01 am
The amount of free space is from experience only. Nothing specific from Microsoft - but 10 years of practical experience has shown that being able to give management 6...
October 3, 2009 at 9:20 pm
You are welcome - glad I could help.
October 3, 2009 at 7:29 pm
Yes, if you backup/restore all databases - the files associated with those databases will be defragmented.
No technical reason for sizing in MB's - just preference. For me, it just...
October 3, 2009 at 7:28 pm
What other files reside on that volume? If there are other files - are they other database files or are they something else? If something else, you should...
October 3, 2009 at 3:39 pm
Dan, yes you understand correctly. If you have the space available and expect to continue growing, there is no reason not to extend the database to 300GB.
Yes, with the...
October 3, 2009 at 1:22 pm
Viewing 15 posts - 4,516 through 4,530 (of 6,677 total)