Damien_The_Unbeliever
Reputation
579
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 6
Newest
 Nice Answer
Impact
~53k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Jan
26
comment How to combine 2 SQL statements into one?
Why are you manually partitioning this data rather than using the SQL Server features designed for this purpose?
Jan
21
answered Using Echo statement writes Echo is ON in the text file
Nov
24
comment Rowlock hint is doing Lock escalation at table level. i dont know why.?
Well, your information that "sql server does not do lock_escalation to table level when rowlock" was incorrect, as the documentation I pointed you towards indicates. I'm not sure what else you're looking for here.
Nov
24
comment Rowlock hint is doing Lock escalation at table level. i dont know why.?
I don't know where you read about escalation, but reading official documentation: "The Database Engine does not escalate row or key-range locks to page locks, but escalates them directly to table locks". I'm not clear on what you're trying to do, but without a WHERE clause, you're still telling the system to lock every row anyway. A table lock is far cheaper and has the exact same effects.
Nov
9
comment Determine 3rd Friday of each month
I always just use a "known good" date if I want to be safe in the face of language settings. E.g. if I'm looking for Fridays, I can look at a calendar and see that January 2nd this year was a Friday. So I'd write the first comparison as DATEPART(weekday,thedate) = DATEPART(weekday,'20150102') --Any Friday.
Sep
30
awarded  Nice Answer
Jul
10
comment Possible to upgrate SQL Server 2012 express to 2012 Standard?
Supported Version and Edition Upgrades
Jun
11
comment Index Seek on SQL Server
"Key/RId lookup which does not have a good performance" - so, the system uses a nice, narrow index to isolate a single row and then performs a lookup for that row. You think that's going to have worse performance than scanning the entire wide table?
Jun
9
comment SQL Server tempdb rogue temporary tables
@Rahul - what do you doubt? Temp tables in tempdb should always have a name with a lot of underscores, whereas table variables tend to have names composed of 8 hex-digits - exactly what the OP is showing.
Jun
9
comment SQL Server tempdb rogue temporary tables
I think that those are the tables for table variables (so look for the use of those instead)
Nov
12
comment Why does a VIEW with a CLUSTERED index not use the index?
@Zerotoinfinite - technically correct, but only because Developer edition and Enterprise edition (and, I think, Evaluation edition) are all in fact exactly the same code. The only difference between them is the license.
Oct
10
comment Restore database with different filename
Are you restoring onto the same server (or a server with access to the original server)?
Jul
24
comment SQL Server NULL values UNDO
You think that the database maintains not just all current data but all previous states as well? Do you not think that that would be a phenomenally "expensive" feature that most people would never need?
Jul
1
awarded  Supporter
Jun
17
comment How can I tell how many Cores SQL Server is actually using?
Express is limited to 1 CPU, not to 1 core. If those 4 cores are all in 1 CPU, then all seems fine.
Feb
19
comment Trigger to restrict users from creating a new table in the database
Or more exactly, don't grant them the permissions needed to create tables in the first place.
Feb
2
awarded  Yearling
Jan
28
comment SQL Server is configured to allow remote connections
1) The error message is talking about Named Pipes, not TCP, and 2) Why are you fiddling with your SQL Server Express's network settings when elsewhere you seem to be talking to the 2012 Developer Edition?
Jan
23
comment SQL Server Replication do not replicate DELETE statement
There are different types of replication. Might be worth adding what type you're using. At a guess, Transacional?
Jan
20
comment One of the Database Ownerhas been Removed and corresponding property changes in sql server
I don't think you can remove a user whilst they are an owner. So you have to explicitly change the owner of the database first. So the answer is "whoever you change the owner to be"