Damien_The_Unbeliever
Reputation
511
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 5
Newest
 Supporter
Impact
~43k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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
Jul
1
comment Is select * still a big no-no on SQL Server 2012?
It's still "dangerous" in indexed or materialized views where you're telling the system to store all of those columns, perhaps unnecessarily.
Jul
1
comment Is select * still a big no-no on SQL Server 2012?
@paqogomez - the closest documentation I can find is Subqueries with EXISTS which states "The subquery does not actually produce any data; it returns a value of TRUE or FALSE. ... The select list of a subquery introduced by EXISTS almost always consists of an asterisk (*). There is no reason to list column names because you are just testing whether rows that meet the conditions specified in the subquery exist."
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"
Dec
10
comment SQL Server is started but didn't listen on any port
It looks like you're using a named instance (only the default instance listens on 1433, so far as I'm aware). Are you including the instance name when trying to create the DSN?
Dec
10
comment SQL Server is started but didn't listen on any port
Default SQL Server Network Configuration (for 2008, can't find 2012 version but I don't think it's any different)
Dec
2
comment SQL Server Standard High Availability (HA) with two nodes
The witness can be an Express Edition, unless they've changed things. And there's no real processing/storage overhead imposed by acting as a witness.
Nov
19
comment Having Issues Exporting to online SQL Server database
When a query stops performing any work in SQL Server and just seems to hang, it's almost always because some other query is holding onto a lock. There are plenty of ways to investigate the current locks and work out what's blocking you - but probably better answered on dba.