Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by Rob Farley for this product (signing in could show even more results)
Showing 1 - 8 of 8 Previous 1 Next

9
0
Sign in
to vote
From Connection: SQL Server
This is a strange one, because you can get around it by using views instead of CTEs. Also, the behaviour is worse in SQL 2012 than in SQL 2008. If you have windowed functions combined with MERGE and …
Created on 7/2/2012 (updated 65 weeks ago) | 3 validations | 1 workaround | 3 comments | feedback id: 752088  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
I just installed Denali SSMS on a machine that had earlier versions of SSMS on it, and chose to use my earlier customizations. But despite the fact that I have changed my toolbars, status bar and fon…
Created on 8/27/2011 (updated 151 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 685924  | 
Closed
as Fixed Help for as Fixed
8
0
Sign in
to vote
From Connection: SQL Server
I love the idea behind Missing Indexes, and love that it's there in SSMS's Execution Plan viewer as well... but it just should be better. See my blogpost for more details. http://msmvps.com/blogs/ro…
Created on 10/11/2008 (updated 135 weeks ago) | 4 validations | 1 workaround | 2 comments | feedback id: 375024  | 
Closed
as Won't Fix Help for as Won't Fix
7
0
Sign in
to vote
From Connection: SQL Server
When using the Design Query in Editor window, predicates can be repeated, like this: FROM Sales.SalesOrderHeader INNER JOIN Sales.SalesPerson ON Sales.SalesOrderHeader.SalesPersonID = Sale…
Created on 6/25/2008 (updated 245 weeks ago) | 4 validations | 0 workarounds | 2 comments | feedback id: 352874  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
To use the Script() method in SQLPS with ScriptingOptions, I have to use Reflection to be able to create the ScriptingOptions way. There should be a way of avoiding this.
Created on 3/3/2008 (updated 234 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 331292  | 
Closed
as By Design Help for as By Design
0
0
Sign in
to vote
From Connection: SQL Server
Using SQLPS, when in the SQLPolicy drive, the instances cannot be listed if a SQL2005 instance is on the same machine.
Created on 3/3/2008 (updated 324 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 331267  | 
Closed
as Fixed Help for as Fixed
0
0
Sign in
to vote
From Connection: SQL Server
As per http://msmvps.com/blogs/robfarley/archive/2008/02/23/transfer-sql-server-objects-task-internals.aspx, the query for default constraints should be one that includes those that have a parent_obje…
Created on 2/25/2008 (updated 335 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 330014  | 
Closed
as Fixed Help for as Fixed
2
1
Sign in
to vote
From Connection: SQL Server
A UNION ALL query that refers to a column that is part of the first resultset but aliased should error, rather than working. The query select o.object_id as id from sys.objects o union all …
Created on 2/25/2008 (updated 97 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 330013  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 8 of 8 Previous 1 Next