network profile
| bio | website | |
|---|---|---|
| location | San Juan Capistrano, CA | |
| age | ||
| visits | member for | 1 year, 9 months |
| seen | Apr 3 at 15:30 | |
| stats | profile views | 4 |
Eric Johannsen
VP of Engineering at BlueCava
Email: my first name at my last name dot us
|
Apr 3 |
accepted | Executing sys.dm_fts_parser without sysadmin server role |
|
Apr 1 |
comment |
Executing sys.dm_fts_parser without sysadmin server role The answer really came from a Stack Overflow user. The whole topic was deleted on SO because both the question and answer were copied to MSDN (apparently some user not the original answerer was gaming both sites) and SO didn't want to have any copyright issues. I'll see if I can find a way to reach the original SO answerer. Thank you for your help and I appreciate the advice to use a separate DB to minimize the security exposure. |
|
Apr 1 |
comment |
Executing sys.dm_fts_parser without sysadmin server role I tried it (by literally executing every step) but it did not work for me. Can you see any details left out of any step that DBA would just fill in but a non-DBA might miss? On a separate note, your blog on logins vs. users was very useful to me. |
|
Apr 1 |
comment |
Executing sys.dm_fts_parser without sysadmin server role There's another approach discussed on MSDN. Unfortunately I could not get that to work. Would you mind having a look and sharing whether you think it should work in principal? social.msdn.microsoft.com/Forums/en-US/transactsql/thread/… |
|
Mar 31 |
asked | Executing sys.dm_fts_parser without sysadmin server role |
|
Oct 27 |
awarded | Critic |
|
Oct 27 |
comment |
Save Results as CSV *with* headers in SSMS If that were strictly true, it should not have any export option at all. For any software, if you add a feature, make it work right. At least SSMS 2008R2 fails that test when it comes to exporting. Additionally, SSMS actually can satisfy the OP's need. |
|
Oct 11 |
awarded | Editor |
|
Oct 11 |
comment |
Scripting a Backup Process and Backup File Ownership @SqlRyan: Added the script and source to a short C# program that does the S3 upload. If you find a functional, command-line S3 client for Windows please let me know. s3.codeplex.com crashed when I ran it, and it is no longer maintained. |
|
Oct 11 |
revised |
Scripting a Backup Process and Backup File Ownership added 7411 characters in body |
|
Oct 11 |
awarded | Scholar |
|
Oct 11 |
accepted | Scripting a Backup Process and Backup File Ownership |
|
Oct 9 |
asked | Scripting a Backup Process and Backup File Ownership |
|
Jan 26 |
awarded | Student |
|
Jan 25 |
comment |
SQL Server VARCHAR Column Width @marc_s: Can the entire column not be indexed, or will an index on the column only consider the first 900 bytes? I know MySQL allows indices on the first N-bytes of a column but not sure how SQL Server works. |
|
Jan 25 |
comment |
SQL Server VARCHAR Column Width @MartinSmith: That's good information about estimated memory requirements. |
|
Jan 25 |
asked | SQL Server VARCHAR Column Width |
|
Jan 25 |
awarded | Supporter |
|
Jan 25 |
comment |
overstating field size in database design If the 100MB causes 20% less data to fit in a 512MB disk controller cache, it will absolutely matter (voice of experience). |
|
Aug 10 |
comment |
Is there any point in undersizing VARCHAR columns? UTF-8 will generally use one byte for one character for western languages. It's multi-byte in the sense that it allows for multi-byte "escape" sequences to represent non-Western characters. |
