SQL Server Blog
OK, so it's not really a blog; you can't add comments to the articles yet, but I'm working on it.My most recent articles are listed below.
max degree of parallelism - When to change it
max degree of parallelism is one of those SQL Server settings where it is often correct to change it from the default...
Continue reading "max degree of parallelism - When to change it"
How much time to take a backup for 300GB?
How much time to take a backup for 300GB?
Continue reading "How much time to take a backup for 300GB?"
Warning
This is a warning for anyone considering using a FastHosts hosting package. DON'T DO IT.
I had another website hosted with them and have just attempted to cancel the package.Despite having a button on their site that says "Don't Renew", it turns out they ignore this and will only cancel if you phone them first.
As a result, I have just been charged another £64.50; and FastHosts have refused to refund it.
This seems like a desperate attempt to get as much money as possible out of their customers, and is attrociously poor customer service.
Now compare that with SBI, who host this site.They are by far the best website host I have used, and it is their business building tools and knowledge that have grown traffic to 12,000 visits per month (and still growing).
I repeat the warning; choose FastHosts at your own risk.
SQL Server Connection Problems
I am having SQL Server connection problems. I get the message An error has occurred while establishing a connection to the server. I have definitely
Virtual Log File
What is a virtual log file? We have just been told by a consultant that we have too many for one of our databases and we need to reduce them to get
