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 Dave_Ballantyne for this product (signing in could show even more results)
Showing 1 - 10 of 17 Previous 12 Next

1
0
Sign in
 to vote
Inconsitent results from sys.dm_exec_describe_first_result_set_for_object when objectID not valid - by Dave_Ballantyne
From Connection: SQL Server
sys.dm_exec_describe_first_result_set_for_object returns inconsistent results when the objectid is not valid. Select * From sys.dm_exec_describe_first_result_set_for_object(object_id('NoObject'),1);…
Created on 3/2/2013 (updated 10 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 780521  | 
Active
6
0
Sign in
 to vote
[SSDT] ONLINE index option is ignored - by Dave_Ballantyne
From Connection: SQL Server
If i declare an index in SSDT as CREATE INDEX [IX_myTable_Column] ON [dbo].[myTable] ([Name]) with(ONLINE=ON) when i generate the publish script the ONLINE =ON option is missing. Needless to say t…
Created on 1/4/2013 (updated 8 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 775760  | 
Closed
6
0
Sign in
 to vote
[SSDT] Whitespace in a comment is not ignored when using the ignorewhitespace option - by Dave_Ballantyne
From Connection: SQL Server
Hi, i have been comparing schema 'A' to schema 'B' and have been having some random procs being returned as being changed. We can see that there are only whitespace changes and that the ignore white…
Created on 12/12/2012 (updated 22 weeks ago) | 0 validations | 1 workaround | 2 comments | feedback id: 774098  | 
Closed
as By Design Help for as By Design
1
0
Sign in
 to vote
[SSDT] Schema comparison (sqlpackage) and DATA_COMPRESSSION - by Dave_Ballantyne
From Connection: SQL Server
If i declare a table inside SSDT without DATA_COMPRESSION and then compare the dacpac against a database that has DATA_COMPRESSION set on that table, SSDT will report this as a change. This happen…
Created on 12/10/2012 (updated 16 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 773928  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
 to vote
[SSDT] SSDT doesent support hypothetical indexes - by Dave_Ballantyne
From Connection: SQL Server
If i have a hypthetical index on my database: Create index IdxName on TableName(ColumnName) with statistics_only Firstly SSDT doesnt understand the syntax so i have to create it as non hypothetical.…
Created on 11/28/2012 (updated 24 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 772495  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
 to vote
SSDT - Agent Escape Macros - by Dave_Ballantyne
From Connection: SQL Server
Similar to: https://connect.microsoft.com/SQLServer/feedback/details/635082/sqlcmd-bug-scripting-variable-not-defined When publishing a database that uses , for example , $(ESCAPE_SQUOTE()) , then a…
Created on 7/6/2012 (updated 43 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 752581  | 
Closed
as By Design Help for as By Design
1
0
Sign in
 to vote
Incorrect actual row count given - by Dave_Ballantyne
From Connection: SQL Server
With sqlserver 2012 RTM and 2008R2 - When a query is using top, is reading data from a cold cache and the query also uses a key lookup , the actual row counts returned from the initial scan of the NC …
Created on 3/8/2012 (updated 61 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 729828  | 
Closed
as By Design Help for as By Design
7
0
Sign in
 to vote
Inserting to an indexed view can fail - by Dave_Ballantyne
From Connection: SQL Server
Consider the below code : create table myTable ( Id integer not null, InView char(1) not null, SomeData varchar(255) not null ) go Create view vwIxView with schemabinding as Select ID,Somedata,left(…
Created on 1/6/2012 (updated 2 weeks ago) | 1 validation | 2 workarounds | 3 comments | feedback id: 717171  | 
Closed
as Won't Fix Help for as Won't Fix
2
0
Sign in
 to vote
SSDT - Importing a stored procedure using FORCESEEK - by Dave_Ballantyne
From Connection: SQL Server
Importing a database with SSDT errors when a stored procedure that uses FORCESEEK eg create procedure Seek as Select * from sys.objects with(forceseek) where name ='j' go Errors with : System.…
Created on 12/19/2011 (updated 71 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 714721  | 
Closed
as Duplicate Help for as Duplicate
3
0
Sign in
 to vote
inaccurate_cardinality_estimate not shown in extended events manager - by Dave_Ballantyne
From Connection: SQL Server
In ssms 2012 , the new extended event of inaccurate_cardinality_estimate is not shown in the extended events manager. Additionally the actual row count is returned as (estimated rows *5)+1, why not…
Created on 12/6/2011 (updated 70 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 711792  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 17 Previous 12 Next





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