meta user
network profile
| bio | website | adsi.mvps.org |
|---|---|---|
| location | Bern, Switzerland | |
| age | 47 | |
| visits | member for | 2 years, 4 months |
| seen | yesterday | |
| stats | profile views | 215 |
Note to all SO beginner:
Please read (and embrace!) Jon Skeet's helpful hints on how to write a good question (or at least his short version here ) - one that has a chance that someone can answer it.
A Pascal/Delphi programmer and database freak at heart, I work as a C# developer on line-of-business applications (mostly ASP.NET).
I'm interested mostly in distributed systems (WCF), database (design and SQL), and Active Directory.
I'm an MCPD .NET 4 Web Developer, MCPD .NET 4 Windows Developer, MCPD Enterprise Application Developer (.NET 3.5), and MCTS for WCF, ADO.NET, Winforms and ASP.NET.
catch me at mscheuner -at- gmail -dot- com if you need to :-)
|
1d |
comment |
What happens when we create index Welcome to StackOverflow: if you post code, XML or data samples, please highlight those lines in the text editor and click on the "code samples" button ( { } ) on the editor toolbar to nicely format and syntax highlight it! Then you don't need any of those messy <br> and tags, either! |
|
2d |
comment |
Column of generic/variable type? What concrete database system? More advanced things like blob store are not part of "core" SQL query language - but they are highly vendor-specific - so we need to know what database this is for |
|
2d |
revised |
Insert performance with Geography column added 9 characters in body; edited title |
|
2d |
revised |
Bechmarking for MongoDB vs MySQL edited tags |
|
Jun 14 |
comment |
Stored procedures vs. inline SQL A properly parametrized query is just as good as a stored procedure, from a performance point of view. Both gets compiled before first use, both will reuse the cached execution plan on subsequent executions, both plans get stored in the same plan cache and both will get handled the same name. There is no performance benefit for a stored procedure anymore, in SQL Server today. |
|
Jun 14 |
revised |
How do these snapshot isolation level configurations interact on a SQL Server 2005 instance? added 7 characters in body; edited title |
|
Jun 13 |
comment |
LDAP in SQL Server 2012 You could e.g. use a web service and call it using SQL-CLR from your SQL Server code |
|
Jun 13 |
revised |
LDAP in SQL Server 2012 added 28 characters in body; edited title |
|
Jun 11 |
revised |
How do I rollback a dropped table using log? added 2 characters in body; edited title |
|
Jun 10 |
revised |
Can a partitioned table span on multiple files across different file groups? added 7 characters in body; edited tags; edited title |
|
Jun 8 |
revised |
What is the timeout of a query in SQL Server 2008 added 6 characters in body; edited title |
|
Jun 7 |
revised |
Database Mail sending functionality not working on local system added 106 characters in body; edited title |
|
Jun 7 |
revised |
Running a DELETE stored procedure but finding degradation in performance in WHILE loop as iterations increase edited body; edited title |
|
Jun 4 |
revised |
MS Access displays alle columns in SQL Server tables as “deleted” added 10 characters in body |
|
Jun 4 |
revised |
Which database engines will allow me to GRANT/REVOKE on a specific column? added 5 characters in body |
|
Jun 4 |
revised |
How to restore SQL Server 2008 R2 backup to SQL Server 2008 added 5 characters in body |
|
Jun 4 |
revised |
Converting data from SQL Server to MySQL using MySQL Workbench and preserving special characters added 15 characters in body; edited title |
|
Jun 4 |
revised |
How database administrators can see my requests to SQL Server? added 11 characters in body; edited title |
|
Jun 4 |
revised |
best way to copy data from SQL Server db to MYSQL DB(remote) edited title |
|
Jun 4 |
revised |
Memory problems with MySQLWorkbench added 1 characters in body |
