Viewing 15 posts - 12,016 through 12,030 (of 39,896 total)
The original specs for Filestream in 2008 (on which Filetable is based) stated that storage must be local. Paul Randal wrote about this.
http://www.sqlskills.com/blogs/paul/misconceptions-around-filestream-storage/
There was support for RBS, remote blob store...
August 21, 2013 at 6:23 pm
Nadrek (8/13/2013)
DBA's handle Database<->Disk and disk retention/aging, automated and ad-hoc and PITR.
Backup team handle Disk<->Backup software (disk and tape), automated and ad-hoc, and tape retention/aging.
DBA's get requests,...
August 21, 2013 at 6:01 pm
It's been in Sept before, a few times, and once in Jan when the Sept one was cancelled because of a hurricane.
When it's in Seattle, it's usually Nov because of...
August 21, 2013 at 6:00 pm
Sept 2, check. Ready and waiting. A whole new strategy this year to try and not sweep up the basement.
August 21, 2013 at 5:57 pm
Wow, 4,000.
I am so rooting for him to make 3k in MLB.
August 21, 2013 at 5:56 pm
It's not necessarily memory, and physical memory doesn't matter all the time. SQL Server has its own memory management and limits.
Perhaps you could start from the beginning and explain how...
August 21, 2013 at 12:21 pm
You are pulling back 6GB of data. If you're doing this in a client, you might have rendering issues, as well as IO/memory issues on the server. 6GB of data...
August 21, 2013 at 11:37 am
SQLSteve (8/21/2013)
run regular integrity checks 🙂
DBCC CHECKDB on every database at least every month if you can't do it every week or every day.
August 21, 2013 at 11:28 am
Craig-315134 (8/21/2013)
... I sometimes think that an investment in developer education would quickly erase any productivity losses ...
Education is always a good thing, but it applies all around,...
August 21, 2013 at 11:16 am
It's too much for me to write about. Basically a trace that's running and rolling over all the time. You can search for more info and read about it.
August 21, 2013 at 8:21 am
I'd agree training can be important and Brent is great. Relatively few hours with his company might save you a lot of headaches later and teach you some things.
In terms...
August 21, 2013 at 8:20 am
Was this database upgraded from an earlier version?
August 21, 2013 at 8:15 am
I'd think that a net stop would be an expected shutdown. It could be some driver in Windows that is is not shutting down cleanly, and one that SQL Server...
August 21, 2013 at 8:13 am
There is the default trace, which gives some information, but if you are looking for some storage history of who modified which objects, this isn't really tracked by SQL Server.
August 21, 2013 at 8:09 am
No idea. I use Firefox most of the time on my desktop. I'd guess it has some security setting, but no idea.
August 21, 2013 at 7:44 am
Viewing 15 posts - 12,016 through 12,030 (of 39,896 total)