Reputation
225
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 8
Newest
 Yearling
Impact
~54k people reached

Dec
18
awarded  Yearling
Dec
18
answered Can you use COUNT DISTINCT with an OVER clause?
Oct
21
answered Read XML file in SQL Server 2008
Oct
21
answered How do I import XML to a SQL Server table?
Jan
26
comment Reclaiming data file free space after deleting a large amount of data
Or just run DBCC INDEXDEFRAG: msdn.microsoft.com/en-us/library/ms177571.aspx
Oct
3
comment How can I call a remote User Defined Function with Parameters?
@gbn: No you can't, exec requires a stored procedure, not a table-valued function.
Jun
18
suggested rejected edit on SQL query slow-down from 1 second to 11 minutes - why?
Sep
26
awarded  Notable Question
Sep
17
awarded  Teacher
Sep
17
answered PostgreSQL: Creation date of a table
Feb
13
awarded  Popular Question
Jul
21
awarded  Excavator
Jul
21
awarded  Editor
Jul
21
revised How do I list all databases and tables using psql?
added datistemplate = false, otherwise you get the template dbs as well
Jul
21
suggested approved edit on How do I list all databases and tables using psql?
Jul
21
awarded  Supporter
Mar
26
awarded  Student
Mar
26
awarded  Scholar
Mar
20
accepted SQL query slow-down from 1 second to 11 minutes - why?
Mar
20
comment SQL query slow-down from 1 second to 11 minutes - why?
Great answer. And thanks for the side note, that's a nice catch. I think for the time being I feel safer keeping the older version for SQL Server instead of creating a persistent/tem table. I intend to replace sysobjects with sys.objects. Hopefully no bad surprises there. A CTE hint would indeed be good, given the fact that the optimizer is, unlike its pg counterpart, not intelligent enough to recognize this automagically. BTW until now I didn't realize one can export the execution plan as image. One of the 4 things I learned from this post - thank you.