network profile
| bio | website | schmitzit.com |
|---|---|---|
| location | Denmark | |
| age | 37 | |
| visits | member for | 7 months |
| seen | May 10 at 21:12 | |
| stats | profile views | 3 |
Specialized in XenForo services.
|
May 10 |
comment |
Installation of SQL Server RAID 10 vs RAID 5 RAID 5 for C sounds like a waste of money. If it's for TempDB, then move that to it's separate RAID 10 partition if you can. Other than that, RAID 10, while more expensive, does offer better performance for relational systems with heavy WRITEs. Whether your case meets that is not something we could assess, but you can measure that. |
|
Jan 11 |
comment |
SQL Server 2012 database backup successfully report but no backup file Can you show the details of the maintenance plan, please? Some screenshots or something would help us assist you better. |
|
Nov 28 |
answered | limiting sql server backups inside .bak file |
|
Nov 20 |
answered | Error on SELECT - Primary filegroup is full |
|
Oct 20 |
awarded | Autobiographer |
|
Oct 18 |
comment |
Alter table on live production databases @AlexKuznetsov - I read the article as saying that there's risks involved, but not as a discouragement. Anyway, I didn't link the article for the GUI bit, but as an indication of some of the operations that lead to an ALTER statement leading to the creation of a temporary table due to changes in the underlying data structure. I haven't tested whether the exact same thing applies when issuing the statement directly from T-SQL, but I would think the process is pretty similar and that SL Server does the legwork behind the scenes. |
|
Oct 18 |
awarded | Editor |
|
Oct 18 |
awarded | Teacher |
|
Oct 18 |
comment |
Alter table on live production databases @AlexKuznetsov - I figured the preceding line, as well as the link with some of the cases listed would clarify this does not always happen. I amended the sentence to better reflect this. |
|
Oct 18 |
revised |
Alter table on live production databases added 19 characters in body |
|
Oct 18 |
answered | Alter table on live production databases |
|
Oct 14 |
answered | Transaction Log file .ldf is too small |
|
Oct 12 |
answered | Backup audit database |
|
Aug 3 |
answered | How SQL server database reorganize memory |
