481 reputation
25
bio website damientheunbeliever.blogspot.…
location United Kingdom
age 36
visits member for 2 years, 9 months
seen Nov 13 at 8:31

Generalist, currently in a (C#/VB.Net/SQL Server) Systems department of a Charity, producing Fat Clients and Web Apps (and utilities for other devs, and anything else I can find to play with)


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.
Oct
15
comment SQL Server 2008 database restore
When you restore a database, there are a set of options you can pick between for what state you want it to be left in afterwards - some of those options will leave it in the "restoring..." state.
Jul
10
comment Check existence with EXISTS outperform COUNT! … Not?
@Serge - using your script, 4 times are output for both queries - I was just reporting the values I received on my machine - which when you add them all up indicates that the EXISTS query took, in total, 12ms less than the COUNT one.
Jul
10
comment Check existence with EXISTS outperform COUNT! … Not?
I don't know what version/edition/OSs your running, but on my machine (Win7, x64, SQL Server 2012 Developer), for COUNT I get 0ms, 12ms and 0ms, 96ms, and for EXISTS I get 1ms, 1ms, and 16ms, 78ms. Which by my maths makes the EXISTS one marginally faster.
Jul
10
comment Check existence with EXISTS outperform COUNT! … Not?
If you could post the full query and the alternative (with EXISTS) we might be able to comment on it. At the moment, we can only see a partial query and, whilst it may be obvious to you, it's not obvious to me what the EXISTS variant is meant to look like.