meta user
network profile
| bio | website | |
|---|---|---|
| location | Indianapolis, IN | |
| age | 30 | |
| visits | member for | 2 years, 4 months |
| seen | 13 mins ago | |
| stats | profile views | 67 |
|
May 16 |
comment |
DELETE vs TRUNCATE +1 Great answer. |
|
May 14 |
awarded | Caucus |
|
Feb 7 |
reviewed | Needs Improvement How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages? |
|
Feb 7 |
reviewed | Satisfactory Recovery time effects of AlwaysOn |
|
Feb 7 |
reviewed | Satisfactory Is there a way to speed up an ALTER statement in SQL Server |
|
Feb 7 |
awarded | Custodian |
|
Feb 7 |
reviewed | Satisfactory Incredibly slow query performance |
|
Jan 10 |
awarded | Yearling |
|
Dec 28 |
comment |
How much do foreign keys affect performance? It is important to note that foreign keys can only be used in this capacity if they are trusted. Meaning, if the foreign key was created or enabled with the WITH CHECK clause, and the check was successful. The NOT FOR REPLICATION clause will also render foreign keys "untrusted" on the subscriber side. |
|
Nov 17 |
revised |
Does varchar size matter in temporary tables? deleted 190 characters in body |
|
Nov 17 |
comment |
Does varchar size matter in temporary tables? @AaronBertrand You are absolutely correct. This was a misconception on my part. I have altered my answer to reflect this. Thanks! |
|
Nov 16 |
answered | Does varchar size matter in temporary tables? |
|
Nov 14 |
comment |
How define select, if bridge pair may have 3 players? +1 for mentioning that the preferable way to perform this is outside of T-SQL. For kicks, I compared the execution plans of our two solutions, by running them in the same batch and forcing a plan recompile. I show that your query costs 73% relative to the batch, and mine costs 27%. For this small sample, this means next to nothing. However, I would be interested to see how both of our queries scale to a large data set. Good stuff! |
|
Nov 14 |
answered | How define select, if bridge pair may have 3 players? |
|
Nov 8 |
awarded | Civic Duty |
|
Oct 23 |
comment |
Attempt to fetch logical page (5:65424) in database 2 failed @RemusRusanu In that case, the service could be restarted, and tempdb recreated. If there is hardware failure, however, this could potentially manifest itself later in a user database. |
|
Oct 23 |
revised |
Attempt to fetch logical page (5:65424) in database 2 failed added 12 characters in body |
|
Oct 23 |
comment |
Attempt to fetch logical page (5:65424) in database 2 failed @RemusRusanu Thanks for the correction. I answered too early in the morning. Edited to reflect reality. +1 For corruption seldom comes alone. |
|
Oct 23 |
answered | Attempt to fetch logical page (5:65424) in database 2 failed |
|
Oct 12 |
comment |
SQL query to return a column per date in date range? @AaronBertrand That's a good point. |
