207 reputation
110
bio website
location Juneau, AK
age 46
visits member for 2 years, 7 months
seen 14 hours ago

I have three wonderful kids, two boys and a girl. My wife is a treasure.


Sep
24
awarded  Autobiographer
Sep
10
comment Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
@AaronBertrand: updated the question with some details and psuedo-code.
Sep
10
revised Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
Added addition details
Sep
9
asked Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
Aug
2
comment Rebuilding an entire Microsoft SQL Server Database
I would script the table structure, import the data, and then synch the database structure -- foreign keys, indexs, procs and so forth.
Jul
25
revised How do I place leading zeros for numbers less than 10 without affecting those 10+?
added 349 characters in body
Jul
25
answered How do I place leading zeros for numbers less than 10 without affecting those 10+?
Jul
18
awarded  Popular Question
Jun
25
awarded  Yearling
May
2
accepted DDL statements being commited within transaction
May
2
comment DDL statements being commited within transaction
I should have thought of that. I'm sure you're right and this is what is happening. And I do have some statements wraaped in GOs. I have SET XACT_ABORT is ON trying to avoid that, but the GOs are probably interfering....
May
2
asked DDL statements being commited within transaction
Mar
19
awarded  Popular Question
Aug
7
answered How to query a database for empty tables
Jun
5
answered Find procedures that haven't been called in <n> days
Dec
2
accepted Why SQL Server doesn't support foreign key constraints on views?
Nov
30
awarded  Critic
Nov
30
asked Why SQL Server doesn't support foreign key constraints on views?
Nov
23
comment Security and Performance implications of “View Server State”
@PeterCarter: thanks for answering.
Nov
23
accepted Security and Performance implications of “View Server State”