meta user
network profile
| bio | website | adsi.mvps.org |
|---|---|---|
| location | Bern, Switzerland | |
| age | 47 | |
| visits | member for | 2 years, 3 months |
| seen | 12 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 :-)
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) I would recommend to always explicitly specify a length for a varchar. In different places, you get different default lengths; as a parameter to a procedure, you get a default length of 1 character - typically not what you expect. |
|
May 17 |
comment |
Is there a system primary key associated with each row? No, at least nothing you can get your hands on easily. Every row has some system-level location information - file id, page id and offset inside the page - but that information is very much internal to SQL Server and not easily accessible from the outside (and definitely not useable to select your row from T-SQL!) |
|
May 14 |
comment |
How to check if I am hitting the Express Edition size limit? SQL Server 2008 R2 Express also has a 10 GB limit (just for completeness) |
|
May 6 |
comment |
Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2? The method is called backups ..... |
|
May 1 |
comment |
Restoring SQL Server 2012 database onto 2008 You CANNOT under any circumstance restore a newer backup to an older instance. Just CANNOT be done. No tool, no trick, no hack - it just isn't technically doable. No way. Period. The database compatibility level doesn't help here. Your only viable option is using database scripts - or a database diff tool like Red-Gate SQL Compare to achieve this. |
|
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 |
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 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 12 |
comment |
Best way to perform backups with filegroups and then restore those backups PLEASE, next time around DO NOT SHOUT at all of us! Writing everything IN UPPERCASE is considering SHOUTING at people - and it's rude and offensive and won't help you get answers - do don't it, please! |
|
Apr 9 |
comment |
SQL Server 2000 trace file extension I think it's .trc (at least for SQL Server 2005 and newer) - but I quite honestly don't remember what the ancient 2000 version used.... (too long ago) |
|
Apr 7 |
comment |
SQL Server taking a lot of memory SQL Server Express does not have a profiler - that's one of its limitations |
|
Apr 6 |
comment |
Login failed for user sa ssis 2008 You shouldn't be using the sa account - not even in testing .... |
|
Mar 25 |
comment |
Can SQL Server 2000 and SQL Server 2012 CoExist? The OP didn't ask about migration, but about side-by-side co-existance ... |
|
Mar 25 |
comment |
why would command text not execute at all? Just wanted to be sure - sometimes it's the most basic, most silly things that stop us :-) |
|
Mar 22 |
comment |
Primary Key efficiency @Craig: well, there are two schools of thought - and they're often very religious about their conviction - so if your project was created by someone who insists on never using a "surrogate" key - then that would be the reason. From a practical every-day programmer point of view, I think using a 5-column natural key is just clunky, unnecessarily complicated and annoying.... |
|
Mar 22 |
comment |
Primary Key efficiency Just ask yourself this: if a child table needs to reference this table here - is it easier to have a join condition on a single identity column, or always have to join on five columns that make up your primary key? |
|
Mar 19 |
comment |
SQL Server in a state of confusion: does the database exist or doesn't it? So the physical files aren't there anymore, right? Do you still see your database in sys.databases ?? E.g. does SELECT * FROM sys.databases still list your database? |
|
Mar 6 |
comment |
How to backup a running SQL Server CE database with full data? Data Source=|DataDirectory|<database_filename.sdf> --> so go to your web application, find the App_Data directory --> that's where the .sdf file will be |
