Reputation
1,854
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
10 26
Impact
~83k people reached

Jul
10
comment Efficiently storing sets of key-value pairs with wildly different keys
How much overlap is there in the fields? Do ten fields cover all 100 subtypes, or are there ~500 wholly distinct fields?
Jun
25
comment Where can I get error messages from SQL Server Auditing?
@ShawnMelton: Original RTM, 12.0.2000.8 (X64). Auditing is not mentioned in the SP1 release notes, but something could have been fixed or expanded.
Jun
25
comment What is the cause of this problem with CONVERT()?
@TomV: sure. Aaron did propose what seems to be the correct answer, so he should get the credit, but if wikifying it would be simpler I'm sure that's fine too.
Jun
22
comment Where can I get error messages from SQL Server Auditing?
@ShawnMelton: I added the code; any additional ideas are appreciated.
Jun
22
comment Guid vs INT - Which is better as a primary key?
Also discussed on SO: stackoverflow.com/questions/11033435/…
Jun
19
awarded  Notable Question
Jun
17
revised Where can I get error messages from SQL Server Auditing?
Added the audit script
Jun
17
comment Where can I get error messages from SQL Server Auditing?
There are system_health_%.xel files in this folder, with current time stamps, so this does appear to be the current location for system logging. The MSSQLSERVER user has full privs for the folder.
Jun
17
comment Where can I get error messages from SQL Server Auditing?
No joy; setting FILEPATH = 'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log`, I still get "see the error log, query ring buffers" and essentially the same 33222 error in dm_os_ring_buffers`.
Jun
17
comment Where can I get error messages from SQL Server Auditing?
There certainly should be! I saw Pinal's post, but it relates to moving the audit location. Also, the error messages he discusses do not match mine.
Jun
16
asked Where can I get error messages from SQL Server Auditing?
Jun
16
awarded  Custodian
Jun
16
reviewed Reviewed LinqToSql query is having intermittent problems
Jun
16
comment LinqToSql query is having intermittent problems
What's the query?
Jun
15
comment Bulk Insert - (0 row(s) affected)
@Thronk: Nonsense, some problems are very simple, and making an answer a comment just because it's short is wrong. If the problem had been that the OP had reversed the linebreak characters, this would have been a perfect answer, as it is it's simply a possible solution that turned out not to be the case. Note that the original question had \n\r as the row terminator.
Jun
15
comment Bulk Insert - (0 row(s) affected)
Can you post the first few lines of the file? If there's sensitive data, feel free to mask it with asterisks or something, but if so please test the masked file and ensure that it gives the same error.
Jun
13
comment Bulk Insert - (0 row(s) affected)
0x0A is decimal 10, 0x0D is decimal 13: the ASCII codes for linefeed (\n) and carriage return (\r), respectively. So \r\n should be correct.
Jun
12
comment Bulk Insert - (0 row(s) affected)
It couldn't have been that easy! K, I would next try loading the file in a hex editor to validate the exact content of the line breaks. For example, if the data is Unicode you may need \0\r\0\n as a separator, and/or the DATAFILETYPE ='widechar' flag.
Jun
12
answered Bulk Insert - (0 row(s) affected)
Jun
1
comment What causes “attribute key cannot be found when processing” errors?
@TomV: full processing; there are no hierarchies in the dimension. I can imagine that things could get out of synch if the system scans first one column, then another, then a third, while the underlying table is getting updated.