Viewing 15 posts - 6,016 through 6,030 (of 49,571 total)
Nope, it's still a single drive no matter how many pieces it's been split into.
May 7, 2015 at 1:55 pm
Eirikur Eiriksson (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about different types of db recovery?
😎
If you mean recovery models, I've done those before. If now, please clarify?
May 7, 2015 at 1:53 pm
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about: Partitioning for performance, what it really means. 😛
This one not good enough? https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Hey, I'm...
May 7, 2015 at 12:14 pm
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about: Partitioning for performance, what it really means. 😛
This one not good enough? https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
May 7, 2015 at 12:06 pm
No.
The log can only be made reusable once the transaction completes. You can try to shrink it, but since there will be no free space the shrink will have no...
May 7, 2015 at 12:03 pm
Ok, I need to write something.
Article requests?
May 7, 2015 at 11:57 am
MotivateMan1394 (5/6/2015)
What was the main purpose of the partitioning? If it couldn't help me in a 300 GB Database, What is the use ?
From my first reply to this thread:
GilaMonster...
May 7, 2015 at 8:54 am
n.ryan (5/7/2015)
MS-SQL on Azure (Azure-SQL) is very much more a PaaS solution with quite restricted functionality compared to the lower-level tweaks and tools available on a local MS-SQL server.
Other...
May 7, 2015 at 7:21 am
Freeing the proc cache does a hell of a lot more than just dropping the cached tables. You can't say that it's all due to the cached temp tables when...
May 7, 2015 at 6:34 am
Then it's restore from a backup or complete loss of the DB. Sorry.
btw, this isn't damage to the log files, this is damage to the data files. Either the server...
May 7, 2015 at 6:30 am
The stretch feature looks useful for audit data too. There the inability to edit the rows is a feature, not a flaw.
May 7, 2015 at 6:26 am
n.ryan (5/7/2015)
I'd really see improvements(*) in the core engine as well
There are some nice ones coming.
May 7, 2015 at 4:41 am
Steve, shall I have a go at this one, if it's still wanted?
May 7, 2015 at 4:10 am
Keith, if you're not going to get to this I can take it (to be done within a week).
May 7, 2015 at 4:07 am
Yes, that setting (which does not need a transaction) means that all tables are read without shared locks. There are still schema stability locks, modifications still take locks. Read Uncommitted...
May 7, 2015 at 2:31 am
Viewing 15 posts - 6,016 through 6,030 (of 49,571 total)