1,941 reputation
321
bio website movingsql.com
location New Jersey
age 57
visits member for 2 years, 8 months
seen Dec 13 at 18:07
coder & programmer of many defunct languages...

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.
Dec
16
comment Maximum dataset size for a well-performing SQL Server 2012?
Even with "bad" hardware and a billion rows, SQL server can still handle 1 read/write request per second (once the caches are warm anyway). Presumably your peaks are going to be a lot more than that.
Dec
14
comment SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
This is not that hard to do with Service Broker and External Activation.
Dec
13
comment Specific TempDB insert of UserDB select results in SOS_SCHEDULER_YIELD to ENCRYPTION_SCAN
I don't see the INSERT in the query plan?
Dec
12
revised Backup Oracle DB using TSM server version 6.3.0
adding tag
Dec
12
revised TDP setup for SQL Server databases
Adding tags
Dec
12
suggested approved edit on Backup Oracle DB using TSM server version 6.3.0
Dec
12
suggested approved edit on TDP setup for SQL Server databases
Dec
11
comment How to design a table that each rows have 5K boolean attributes?
how commonly will all/each attributes be used (set) within each row? If a fairly large percentage of the attributes are not used (or alternatively, not set) most of the time, you may be better off with a sparser approach (like EAV, as mentioned above).
Dec
2
comment SQL Server Standard High Availability (HA) with two nodes
Log Shipping is another option.
Nov
27
comment Display a List of used Table and Column
Weird, this sounds almost exactly like something that I implemented for a customer a couple of years ago. The numbers are dead on.
Nov
15
comment Limit connection rights on SQL Server
Unfortunately, Host_Name() is not secure and can be easily spoofed by just about anyone. It's particularly easy to do from Excel. Your @IPAddress would be a lot more reliable for this purpose.
Nov
5
comment What permissions are necessary for truncating a table?
TRUNCATE TABLE is DDL, not DML.
Oct
19
awarded  Benefactor