Search
SQL Server Home
DownloadsFeedbackSurveys
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 Wayne Sheffield for this product (signing in could show even more results)
Showing 1 - 10 of 11 Previous 12 Next

1
0
Sign in
 to vote
BOL for sys.dm_exec_sessions does not mention 2 columns returned by the DMV - by Wayne Sheffield
From Connection: SQL Server
The sys.dm_exec_sessions DMV does not have documentation for the database_id and open_transaction_count columns returned by the DMV in BOL (http://msdn.microsoft.com/en-us/library/ms176013.aspx)
Created on 12/31/2012 (updated 19 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 775508  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
 to vote
sp_help_job BOL documentation error - by Wayne Sheffield
From Connection: SQL Server
In the BOL for sp_help_job (http://msdn.microsoft.com/en-us/library/ms186722.aspx) it states that you must provide either @job_id or @job_name, but not both. Actually, you can supply no parameters to …
Created on 11/28/2012 (updated 24 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 772627  | 
Active
2
0
Sign in
 to vote
sys.server_principals BOL for SQL 2012 does not include newly added columns - by Wayne Sheffield
From Connection: SQL Server
sys.server_principals BOL for SQL 2012 (http://msdn.microsoft.com/en-us/library/ms188786.aspx) does not include newly added columns owning_principal_id and is_fixed_role.
Created on 10/17/2012 (updated 29 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 767805  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
 to vote
Go to Next Bookmark skips bookmarks after Clear Bookmark clears the current bookmark. - by Wayne Sheffield
From Connection: SQL Server
Go to Next Bookmark skips bookmarks after Clear Bookmark clears the current bookmark.
Created on 6/8/2012 (updated 13 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 747722  | 
Closed
1
0
Sign in
 to vote
BOL: Aggregate Functions incomplete / inconsistent and inaccurate. - by Wayne Sheffield
From Connection: SQL Server
On the BOL page for Aggregate Functions (http://msdn.microsoft.com/en-us/library/ms173454.aspx), there is a table of aggregate functions. On this same page is a tree view navigation pane on the left s…
Created on 4/1/2012 (updated 52 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 734976  | 
Closed
as Fixed Help for as Fixed
14
0
Sign in
 to vote
LAST_VALUE() returns current row when used inside a cte - by Wayne Sheffield
From Connection: SQL Server
When using the AdventureWords2008R2 database from codeplex, a query that uses the LAST_VALUE() function returns a different result depending on whether it is used from within a cte or not. (FIRST_VALU…
Created on 12/9/2011 (updated 72 weeks ago) | 4 validations | 0 workarounds | 2 comments | feedback id: 712918  | 
Closed
as Duplicate Help for as Duplicate
1
0
Sign in
 to vote
UPDATE statement shows 0 writes in profiler - by Wayne Sheffield
From Connection: SQL Server
When running an update statement on 1 million rows of the form set @variable = column = expression, the writes are not being calculated in profiler. Additionally, some of the ROWS|RANGE options of t…
Created on 8/23/2011 (updated 3 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 685241  | 
Closed
as Won't Fix Help for as Won't Fix
3
1
Sign in
 to vote
DefaultData/DefaultLog directory settings not honored until SQL Server service is restarted. - by Wayne Sheffield
From Connection: SQL Server
When you set the default location for a new database data/log file, this information is not used until the server is restarted, even though SSMS reports that this is the running value. Note: read dis…
Created on 12/22/2010 (updated 122 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 633050  | 
Closed
as Won't Fix Help for as Won't Fix
4
1
Sign in
 to vote
Inconsistent actions by cast/convert when converting different data types - by Wayne Sheffield
From Connection: SQL Server
The cast/convert function inconsistently truncates strings when converting to different data types. DECLARE @ID NVARCHAR(MAX) = N'0E984725-C51C-4BF4-9960-E1C80E27ABA0wrong'; select @ID, CONVERT(uniq…
Created on 10/12/2010 (updated 112 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 612923  | 
Closed
as By Design Help for as By Design
6
0
Sign in
 to vote
Documentation: Index Structures listed in BOL are incorrect - by Wayne Sheffield
From Connection: SQL Server
The following links reference index structures for different types of indexes as being a "B-Tree" index structure. These are all actually a "B+ Tree" structure. Clustered Index Structure: http://msdn…
Created on 7/22/2010 (updated 136 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 577525  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 11 Previous 12 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement