59,285 reputation
779160
bio website
location Rhode Island
age 40
visits member for 3 years, 5 months
seen 15 mins ago

Senior Consultant at SQL Sentry, SQL Server MVP, @AaronBertrand on twitter, blogger at sqlperformance.com and sqlblog.com, Mac user, volleyball player, curler, hockey/football/tennis fan (Go Bruins!), proud father and Canadian, eh?


36m
comment SQL Database is corrupted
Please provide a lot more detail. For example, did you have any backups before the hard disk crashed? How exactly are you trying to attach? It sounds like the file is corrupt, and if you don't have a backup, there's not much anyone is going to be able to do for you. This might be an expensive lesson in why we take backups at all...
39m
comment Share centralized queries for multiple databases
@n8 You can turn that off. Tools > Options > SQL Server Object Explorer > Scripting > set Script USE <database> = false.
1h
comment Share centralized queries for multiple databases
@n8 well, how do you deploy a stored procedure change in dev to one database in production? For two databases, just do that twice. For more, you could look at SMO (via C# or PowerShell) or tools like MultiScript from Red Gate.
2h
revised 2008 R2 Express Silent Install - FullText Service Not working
edited tags
3h
answered Share centralized queries for multiple databases
3h
revised 2008 R2 Express Silent Install - FullText Service Not working
Your CAPS KEY WAS STUCK - I think I fixed it
3h
comment Share centralized queries for multiple databases
Out of curiosity, why are you afraid of Dynamic SQL? Anyway there are tools out there that can help you synchronize multiple databases to make sure, say, a stored procedure is the same in both databases, or to help you deploy a change to multiple databases at the same time.
8h
answered SQL Server: Using 4 part identifiers when database may be on the same server
10h
revised How to pull rows only from the weekends?
deleted 7 characters in body; edited title
10h
comment How to pull rows only from the weekends?
+1 Just make sure SET LANGUAGE ENGLISH; :-) Alternatively, you could use DATEPART and check for the right integer, just make sure SET DATEFIRST is correct.
22h
comment Trying to filter msdb..sysjobs by job_id
@MaxVernon No problem. But seriously, just use CONVERT always.
23h
answered Trying to filter msdb..sysjobs by job_id
1d
revised Online index rebuild LOB types
added 139 characters in body
1d
comment Online index rebuild LOB types
I've made massive updates to my answer (not sure if you get pinged when I do).
1d
revised Online index rebuild LOB types
added 2245 characters in body
1d
comment Unknown Error when attempting to run Import Data wizard
What is your version of Management Studio (Help > About)?
1d
comment Consolidating 2 Tables with same Values
Are those order id values just in this table, or do they have references in other tables too?
1d
comment AlwaysOn FCI + HA Setup Question
I'm not even going to try to analyze the entire description of your environment (that's a lot of words). But to maintain quorum you know that more than half of the quorum votes have to be online, yes? Exactly half means cluster down.
1d
comment Foreign key, key split in two tables
It's not just a performance issue - they can fail to do their job.
1d
comment Foreign key, key split in two tables
Uh, @blobbles, I'd be VERY careful with check constraints using functions. Check out the first few articles from this search‌​...