| ITS Manager |
| SQL Server and Table partitionning |
| 11.03.2009 16:23:17 | |
|
There are no translations available. Have you ever had a table that kep growing, while the performaces kept degrading, the first nice idea would be to define indexes, fair enough, but as the table continues to grow so does the indexes, and still the indexes might not be sufficient. So what do you do? buy a more powerful server? Well this is an extreme solution, before just try to partition your huge table (well what is huge? above 10Gb is already huge in my case) Partitionning is equivalent to create as many smaller objects as your partition boundaries Tags: transfer | existing table | SQL Server | Partition | Table | schema | function Hits: 8459 | Read more... |
| ITS Manager |
| BizTalk SQL Server -> Login Failed user Null |
| 01.11.2008 22:27:32 | |
|
There are no translations available. I already experienced several times the error : "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" Could any one explain to me to what this is related? This time there was no impact, but it could have in the future? For information purposes only, we found what was going wrong. The BizTalk Server is not the same as the SQL Server A user belonging to the Active Directory was used by BizTalk Server to access SQL Server Tags: user null | Error | Connection | BizTalk | Active Directory | SQL Server Hits: 10452 | Read more... |
.png){kind=logo}
