1,891 reputation
321
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years, 6 months
seen Oct 13 at 20:35
coder & programmer of many defunct languages...

Mar
10
comment Is indexing binary?
Searching without an index is O(N) and inserting is O(k). Searching with an index is O(logN) and inserting is O(logN). This is usually seen as hugely positive trade-off.
Mar
3
revised How to diagnose what is causing DB timeouts
changed query-timeout tag to connection-timeout.
Mar
3
comment Known vulnerabilities for when a guest executes a stored procedure on SQL Server
@AnupShah Oops, you are right, I misread the question.
Mar
3
suggested suggested edit on How to diagnose what is causing DB timeouts
Mar
3
comment If user owns a database fixed role are they the admin of the role?
I guess you could count Application Roles as a fifth type, though they are really more of a Login/User type.
Mar
3
comment Known vulnerabilities for when a guest executes a stored procedure on SQL Server
Why don't you just give them a copy of your database?
Feb
28
comment indexing on multiple nvarchar(max) columns
Yes, that's true. I didn't quite understand that implementing a uniqueness constraint was your only need here. It's also a little odd to be using such a huge amount of text for uniqueness, since even a single extra space anywhere in up to 8GB would cause it to be different. Though i suppose that could make sense if you're using it to detect un-logged editing differences for versioning/revision identification.
Feb
27
comment indexing on multiple nvarchar(max) columns
I suspect you would be happier with Full-Text Search instead.
Feb
26
comment SQL Server 2008R2 - Stored Procedure with 2 updates causing deadlocks
The "Deadlock graph data extracted" appears to have little or no relationship to the "deadlock graph" you posted?
Feb
26
answered Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2
Jan
28
comment SQL Server 2012 is database name mandatory for logon?
+1: It's worth noting I think, that while not formally mandatory, specifying the DB is effectively mandatory if the Login's default DB either does not exist or if the Login does not have Connect rights to it. I mention this as it is a confusing, but not uncommon reason for connection/login failures.
Jan
28
comment SQL Server is configured to allow remote connections
@Damien_The_Unbeliever Generally, the "Named Pipes" reference in this error is a red herring. Named Pipes is just the last of the three protocols (Memory, TCP, Named Pipes) that is checked for a match between client and server, so it is always the protocol that is used in the error message. If the OP wants the SQL Server to support TCP (and this is what MS recommends), then they likely need to change the client configuration settings also (the client and server settings are separate, even on the same box). Also, there are 32bit and 64bit versions of each.
Jan
23
comment Why does SQL Server run a subquery for each row of the table it's qualifying?
Ah. Sorry to be a pest about this Martin. This must be some query plan subtlety that I'm just not grokking.
Jan
23
comment Why does SQL Server run a subquery for each row of the table it's qualifying?
But ... the estimated number of rows and number of executions are both 1. How can scaling 1 down to 1 change the subtree estimates?
Jan
23
comment Why does SQL Server run a subquery for each row of the table it's qualifying?
Hmmm, this is still confusing/weird. Why I'm looking at the slow plan and some of the "Estimated subtree cost"s are a lot less than the individual IO and CPU costs. Maybe my brain just isn't working today, but that seems impossible to me...?
Jan
23
comment Why does SQL Server run a subquery for each row of the table it's qualifying?
Frankly, this seems like a performance/optimizer bug to me. It's allowed to assume a static, stable result from the subquery and cache it, so why doesn't it just always do that, irrespective of the estimated row counts? When is the plan its chosen ever better?
Jan
1
comment Make View Supersede Table in Same Database?
You can also rename the table first, then make your View with the table's original name, pulling it's data from the renamed table. But I'd probably do what @MartinSmith said and just update the table.
Dec
29
comment Sql Server Fix Users
The error message seems pretty clear.
Dec
26
comment Is it possible to view LRU-K values in SQL Server?
Well, this is one way to spend your Christmas. :-)
Dec
25
comment Can geography datatype Lat/Long properties be returned using a view in SQL Server 2008?
There is no way that that SQL query works "when applied to the table". And Views in SQL Server support just about anything that you can do with a valid data-SELECT statement, excepting the ORDER BY clause.