Reputation
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 17 40
Newest
 Yearling
Impact
~384k people reached

19h
comment Unable to open SQL Server database file (.mdf)
Are you logged in as Jason Kurant?
1d
awarded  Yearling
Mar
25
answered Clustering a heap by date in stead of unique composite key
Mar
25
reviewed No Action Needed SQL Server not starting at Windows startup but starts manually
Mar
24
comment How recording of every change of a row in a database is generaly stored?
@Thomas What RDBMS are you using? Triggers operate on single tables, as far as I am aware. You can't have one trigger capture data changes from multiple tables. As for storing all changes in one single table via XML, what is your performance like? I be reporting on such a table is a huge problem.
Mar
18
awarded  Popular Question
Mar
14
reviewed Approve SQL Server Replication with 2 systems in different locations
Mar
4
awarded  Popular Question
Feb
24
comment Restore master database from SQL Server 2008 R2 on SQL Server 2012
I did not see the new name. I thought the OP was restoring over top of the existing master database which would break SQL. I still would not restore a system database from one version to another. It is not an activity that would normally take place. I am going on instinct here, so no I cannot directly link you to any articles explaining this. When you restore a database from an earlier version, upgrade scripts are applied. This particular path may not have been fully tested by Microsoft, as it is not a common path to follow.
Feb
17
reviewed Approve Daily backup with mysqldump
Feb
11
awarded  Enlightened
Feb
11
awarded  Nice Answer
Feb
11
comment Can SQL Server stop me from running an UPDATE statement without a WHERE clause?
Unless the person highlights the commit portion accidentally as well.
Feb
10
comment A more efficient way to write multiple CASE statements
I'm voting to close this question as off-topic because it is more of a "please fix this for me" request. I am sure people out there are willing to stop what they are doing and fix the query, but this really seems lazy on the poster's part.
Feb
10
revised NVARCHAR column as PRIMARY KEY or as UNIQUE column
changed trillion to billion
Feb
10
comment NVARCHAR column as PRIMARY KEY or as UNIQUE column
int is 4 byte in SQL, which gives you -2.1Billion to + 2.1Billion.
Feb
5
comment SQL Server Timeout Expired in ASP.NET C# WebForms application
@JohnM, That isn't to say that ExtendedEvents isn't awesome, because it is.
Feb
5
comment SQL Server Timeout Expired in ASP.NET C# WebForms application
It may be be deprecated, but it is still part of SQL 2000, 2005, 2008, 2012, 2014. It will also be part of the next release, but after that who knows. msdn.microsoft.com/en-us/library/ms181091.aspx
Feb
5
answered SQL Server Timeout Expired in ASP.NET C# WebForms application
Feb
5
reviewed Approve How to use a group by in inner join