Reputation
5,288
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
8 22
Newest
 Civic Duty
Impact
~513k people reached

2d
reviewed Approve tuning postgresql for large amounts of ram
Mar
31
comment XML parsing slowly
Is the xml being passed in as a parameter?
Feb
29
comment Selecting from a table contains a XML column
Also, an XLS sheet has a limit of 65K rows, which was increased significantly in 2010 when they moved to the XLSX format. Converting to the lesser XLS format can result in data loss
Feb
29
answered How to model the relationship between these three tables
Feb
29
reviewed Approve Count null and not null values in a column
Feb
29
comment How to model the relationship between these three tables
As you already track the user_id in the meals table I see no need for the day table. Just add the date directly to the meals table.
Feb
29
comment Selecting from a table contains a XML column
Are you sure that you need to import it as XML instead of converting it to xml, and then populating a table from the XML? The only reason I ask is that the way you are trying to do it may not work as expected due to the shared string table, embedded functions, sheet/cell references etc.. FYI, Excel 2010 is a collection of XML files - change the extension from xlsx to zip and the extract the contents to see for yourself.
Feb
24
awarded  Civic Duty
Feb
23
reviewed Approve daas tag wiki
Feb
23
reviewed Approve daas tag wiki excerpt
Feb
23
comment Delete Works in one Stored Procedure but not another
@ARich could you post the definition for both procedures?
Feb
23
comment Delete Works in one Stored Procedure but not another
Does it work if you change the syntax to simply DELETE Database.Schema.tbl_Review_Response_FreeText WHERE Instance_ID = @InstanceID
Feb
23
comment Delete Works in one Stored Procedure but not another
Just to clarify, the data exists prior to the execution, and then remains after the delete is issued?
Feb
17
awarded  Vox Populi
Feb
17
reviewed Approve Field order in a composite index order with high selectivity and low selectivity fields
Feb
17
awarded  Suffrage
Feb
17
answered Login Schema Role User Setup
Feb
17
comment Login Schema Role User Setup
When you say "public website" - how public are we talking? Internet public, or VPN from customers etc...?
Feb
17
reviewed Approve How to get the ID of the conflicting row in upsert?
Feb
17
reviewed Approve What is surface area in SQL Server