Viewing 15 posts - 4,516 through 4,530 (of 6,679 total)
JuanBob (10/5/2009)
The primary reason is for scalability without the SQL 64bit costs...
October 5, 2009 at 3:32 pm
Before going down that road - can you explain why you think you need to install SQL Server 2005 32-bit on x64?
There are very few reasons why you would need...
October 5, 2009 at 1:41 pm
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
Viewing 15 posts - 4,516 through 4,530 (of 6,679 total)