meta user
network profile
| bio | website | adsi.mvps.org |
|---|---|---|
| location | Bern, Switzerland | |
| age | 47 | |
| visits | member for | 2 years, 3 months |
| seen | 11 hours ago | |
| stats | profile views | 207 |
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 :-)
|
Apr 23 |
comment |
Server side trace to database @BorisCallens: dumping into trace files IS the preferred way to go! This puts less load on your (production) server than writing directly into the database. Dump the trace into files, and then go grab those files onto your local test environment, and analyse them there! Put as little load as possible on your production machines... |
|
Apr 22 |
revised |
What is the future for system and database administration added 1 characters in body; edited title |
|
Apr 22 |
comment |
Does SQL Server place shared locks on scanned records when using REPEATABLE READ @BuddhiP: updated my response with two links to resources |
|
Apr 22 |
comment |
Does SQL Server place shared locks on scanned records when using REPEATABLE READ @BuddhiP: this is definitely different from vendor to vendor. My response is only for Microsoft SQL Server |
|
Apr 22 |
comment |
Does SQL Server place shared locks on scanned records when using REPEATABLE READ @BuddhiP: no - the locks will only be placed on those rows that actually match your UPDATE's WHERE criteria. Only those rows are "scanned" and then updated. Otherwise, you'd be locking the whole table all the time, no?? |
|
Apr 22 |
answered | Does SQL Server place shared locks on scanned records when using REPEATABLE READ |
|
Apr 22 |
revised |
Updating a table with more than 850 million rows of data added 4 characters in body |
|
Apr 20 |
revised |
How do I specify a linked server to a remote database over tcp/ip? edited tags; edited title |
|
Apr 19 |
revised |
Why use separate databases for high traffic/volume tables? added 1 characters in body |
|
Apr 19 |
revised |
SQL Server backup devices autentification by user without access to local computer account or AD Product is called **SQL Server** - not "MSSQL" or "MS SQL" or "MS-SQL" or anything like that |
|
Apr 19 |
revised |
Compress backup file using T-SQL deleted 3 characters in body; edited title |
|
Apr 19 |
revised |
Limiting user access to tables based on a ROLE added 25 characters in body |
|
Apr 19 |
revised |
Server side trace to database deleted 111 characters in body |
|
Apr 19 |
comment |
Server side trace to database @BorisCallens: I don't think the SQL Server Central thingie is a paywall - you just need to register (for free). Also: all those articles show how to use the SQL Profiler to define a SQL Server trace - this is really the same thing - you're just not running the trace "live" using SQL Profiler, but you have SQL Server run it as a "server task", so to speak. |
|
Apr 19 |
answered | Server side trace to database |
|
Apr 18 |
revised |
Only allow one checked row in a Column in SQL Server added 34 characters in body; edited title |
|
Apr 18 |
revised |
Can't get users default schema to change - SQL Server 2008 added 1 characters in body; edited title |
|
Apr 17 |
revised |
Migrating from SQL Server 2005 to SQL Server 2008 R2 on a different box added 19 characters in body; edited title |
|
Apr 17 |
revised |
Can SQL Server 2008 / 2012 have execute permission in a function for a user, but not for a table used in the function? added 8 characters in body; edited title |
|
Apr 17 |
revised |
Validate Primary Key and Index Selection edited tags |
