7,016 reputation
1156
bio website brentozar.com
location Chicago, IL
age 40
visits member for 3 years, 6 months
seen yesterday

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


Dec
27
answered How to structure Master/Detail tables for performance without denormalizing?
Dec
27
answered 823 errors on tempdb
Dec
27
answered Could not continue scan with NOLOCK due to data movement SQL Server 2008 R2
Dec
27
answered Which workarounds exists to missing relative path feature of SQLCMD :r?
Dec
27
answered “Prelogin failure” when attempting to run stored procedure across linked server
Dec
27
answered The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline
Dec
27
comment database 'msdb' cannot be opened. it has been marked suspect by recovery 2008 error code 926
It doesn't have to be the same build or SP - just as long as it's on the same major version. (SQL 2008R2 is considered a new major version from SQL Server 2008.)
Dec
27
answered ALTER TABLE SWITCH statement failed
Dec
27
answered Reconcile users with logins using 'sp_change_users_login'
Dec
27
answered database 'msdb' cannot be opened. it has been marked suspect by recovery 2008 error code 926
Dec
27
answered What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Dec
27
answered Reconnect mirroring server SQL2008 R2
Dec
27
answered SQL Server Management Studio Change User Server Roles to sysadmin?
Dec
27
answered Schannell: Certificate received from the remote server was issued by an untrusted certificate authority
Dec
27
awarded  Revival
Dec
27
answered How do I remove a SQL Server 2008 instance from command prompt w/o removing the server?
Dec
27
answered SQL Server 2008: The database [dbName] is not accessible
Dec
27
answered Couldn't install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1
Dec
27
answered TempDB data files don't shrink well on SQL 2008
Dec
27
answered sql server database sharding - what to do with common data / non sharded data