Reputation
22,579
Next tag badge:
98/100 score
50/20 answers
Badges
2 26 54
Newest
 Good Answer
Impact
~1.3m people reached

1d
awarded  Good Answer
Aug
15
comment SQL Server storage limits on Azure
Yep, pretty much.
Aug
15
answered Virtualize SQL High CPU
Jul
31
awarded  Necromancer
Jul
31
awarded  backup
Jul
27
answered Bidirectional Replication Push and Pull with SQL Server
Jun
17
awarded  Enlightened
Jun
17
awarded  Nice Answer
May
26
awarded  Revival
Apr
11
comment Restoring SQL Server 2000 database to SQL Server 2008
Yes you just need to restore the user databases to the new instance and change the compatibility level if you need the higher level compatibility. There's no need to change the collation.
Mar
23
comment What permissions does db_owner not have? (In SQL Server 2008)
If you are going to downvote a correct answer, you should at least tell me why.
Mar
17
answered Restoring SQL Server 2000 database to SQL Server 2008
Mar
17
answered What permissions does db_owner not have? (In SQL Server 2008)
Mar
17
comment How to change the instance name of SQL Server Express 2008?
This has not changed and probably never will.
Feb
25
comment What is the name for a table that keeps track of operations that have been performed on the database?
Sounds like a general auditing table to me. I assume this is something that was built into your application and isn't provided by your RDBMS automatically?
Feb
16
comment how to restrict user to run sql server database only on partiular ip only?
Are you trying to make it so that users can only connect from one IP address, or does the server have multiple IPs and you only want users to be able to connect to one IP address?
Feb
15
comment Is there a reason not to use white spaces for column names?
Because spaces are the devils handy work.
Feb
9
comment Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
I said preferred, not required. For normal applications that make up 98% of the databases in the world a clustered key on an identity column works just fine.
Jan
28
answered Best way to migrate a huge SQL Server database with low downtime over network
Jan
28
comment SSMS IntelliSense doesn't work on particular database
What compatibility level is the database and what version is the server?