Viewing 15 posts - 6,016 through 6,030 (of 49,552 total)
Nope, it's still a single drive no matter how many pieces it's been split into.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2015 at 12:03 pm
Ok, I need to write something.
Article requests?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2015 at 4:41 am
Steve, shall I have a go at this one, if it's still wanted?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2015 at 2:31 am
Viewing 15 posts - 6,016 through 6,030 (of 49,552 total)