network profile
| bio | website | |
|---|---|---|
| location | Arkansas | |
| age | 32 | |
| visits | member for | 1 year, 11 months |
| seen | Mar 8 at 15:10 | |
| stats | profile views | 4 |
Database Administrator
|
Dec 3 |
answered | Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2 |
|
Nov 14 |
comment |
Is there a negative impact to using SQL Server with a lower compatibility level +1 Justin Also don't forget that when running in compatibility mode 2000 (80), you'll have to use a slight hack to get some dmvs to work properly: sqlskills.com/blogs/paul/post/… |
|
Nov 12 |
comment |
All partitions in one filegroup Please post definitions for your tables or further clarify your explanation of the tables. A table can be both partitioned and have a clustered index. Is the second table a heap or does it also have a clustered index? It would also help to have definitions for the partition scheme and function. |
|
Oct 12 |
comment |
Differential backup of new sql database fails until full backup is made @BenThul Diffs can be taken regardless of the recovery model. If there are bulk loads in the environment and the recovery model is not full, Diffs could offer a significant advantage over the full recovery/tran log backup scenario. Additionally, recovery is much simpler with diffs. All you need to restore is the last full and the last diff. Much simpler than trying to recover with a full and 40 tran backups. On a tier 2 or 3 database, the cost of point in time recovery may outweigh the benefits. |
|
May 8 |
awarded | Supporter |
|
Dec 14 |
awarded | Teacher |
|
Dec 14 |
answered | SQL Server cannot connect after reboot and locked |
|
Jun 21 |
comment |
SQL 2008 and SQL 2008 R2 Server hangs on 'Welcome' screen while connecting using RDP Was this ever resolved? We're having the same issue. |
