113 reputation
6
bio website None
location Netherlands
age 29
visits member for 2 years, 9 months
seen Aug 22 at 13:30

.NET Developer at NedFox BV


Aug
22
comment When to add indexes to #temp tables?
I know. But the question was about adding a nonclustered index. That can't be done directly in the create statement ;-)
Aug
21
comment When to add indexes to #temp tables?
You can't add an index in the CREATE TABLE statement. Only constrains can be added there.
Aug
5
awarded  Popular Question
Mar
11
asked Can't set up mirroring for a specific database
Jan
31
comment SQL Server mirrored database is stuck in recovery mode
Already tried that, but I can't kill the process, error: "Only user processes can be killed."
Jan
31
awarded  Editor
Jan
31
revised SQL Server mirrored database is stuck in recovery mode
added 195 characters in body
Jan
31
comment Sql Server database in recovery: How to stop, Take ofline or delete?
What if you can't stop sql server because of other databases that shouldn't go down? There is no other way?
Jan
31
asked SQL Server mirrored database is stuck in recovery mode
Apr
24
awarded  Supporter
Dec
21
awarded  Scholar
Dec
21
accepted How often should I run integrity and consistency checks on SQL Server 2008?
Dec
21
comment How often should I run integrity and consistency checks on SQL Server 2008?
The indexes are rebuild or reorganized every night, depending on the fragmentation. What do you suggest for table statistics?
Dec
5
awarded  Student
Dec
5
awarded  Autobiographer
Dec
5
asked How often should I run integrity and consistency checks on SQL Server 2008?