270 reputation
311
bio website ledgerscope.com
location Bingley, United Kingdom
age 29
visits member for 3 years, 8 months
seen Sep 12 at 18:37

Software Developer at Ledgerscope


Jul
2
awarded  Curious
Apr
10
awarded  Notable Question
Dec
2
awarded  Popular Question
Jul
28
comment Running out of Transaction Log space during Alter Table
That looks to be what I'm after. It was the batch copying of rows that I thought was going to be the hardest. I've got a copy of production that I can run this through for timings etc. Thanks
Jul
28
comment Running out of Transaction Log space during Alter Table
@swasheck I'm on SQL Azure so can't change the recovery model
Jul
28
comment Running out of Transaction Log space during Alter Table
Yes, I'm attempting to change the datatype of a non-key column. I also got this error while trying to change a column from NOT NULL to NULL, but got round it for that one by deleting indexes that referenced it, changing the column and then re-adding the indexes. The same workaround doesn't work for this.
Jul
28
asked Running out of Transaction Log space during Alter Table
Jul
12
comment Don't use a transaction for Stored Procedure
Updated to clarify slightly
Jul
12
revised Don't use a transaction for Stored Procedure
added 114 characters in body
Jul
12
comment Don't use a transaction for Stored Procedure
Will that create sub transactions within my Stored Procedure? Ideally I'd like to avoid that if possible
Jul
12
asked Don't use a transaction for Stored Procedure
Jun
20
comment What is the difference between these two index declarations and do I need both?
As a follow up to this question, what is the advantage of putting the column in the include section rather than in the index itself?
Apr
8
awarded  Nice Question
Feb
15
awarded  Notable Question
Dec
13
answered How can I profile SQL Azure?
Aug
28
awarded  Yearling
Aug
28
awarded  Teacher
Jun
1
revised What database technologies do big search engines use?
I know it's a small change, but title said "to" instead of "do"
Jun
1
suggested suggested edit on What database technologies do big search engines use?
Mar
16
answered Is it possible to check a date in SQL?