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

2
0
Sign in
to vote
From Connection: SQL Server
Running the below script will cause an error with UPDATE STATISTICS USE AdventureWorks2012; GO ALTER DATABASE AdventureWorks2012 SET COMPATIBILITY_LEVEL = 120; GO IF OBJECT_ID('AscendingTest') IS NO…
Created on 2/20/2014 (updated 5 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 820041  | 
Closed
as Duplicate Help for as Duplicate
4
0
Sign in
to vote
From Connection: SQL Server
Consider the two queries : select SalesOrderID from sales.SalesOrderHeader where RevisionNumber<1 option(recompile) go select SalesOrderID,SalesOrderNumber from sales.SalesOrderHeader where RevisionN…
Created on 1/13/2014 (updated 5 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 813591  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
Hi, I understand that the are many unknowns, assumptions and assertions that go into making the estimate for a memory grant for operations, however in this scenario is would seem fairly straightfor…
Created on 12/20/2013 (updated 5 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 812070  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
Im struggling to understand if this is natural or not :S I had a query that ran fine (30sec) in a user database, executing the same query against a snapshot of the database would not return ( LATCH_S…
Created on 11/5/2013 (updated 38 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 807755  | 
Closed
as By Design Help for as By Design
5
0
Sign in
to vote
From Connection: SQL Server
When displaying execution plans, SSMS shows "Query Cost Relative to Batch". This is at best misleading at worst, just wrong. Please change this wording to "Estimate query cost ( Relative to batch e…
Created on 5/30/2013 (updated 74 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 788973  | 
Closed
1
0
Sign in
to vote
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 5 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 780521  | 
Closed
as Won't Fix Help for as Won't Fix
8
0
Sign in
to vote
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 31 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 775760  | 
Closed
6
0
Sign in
to vote
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 100 weeks ago) | 0 validations | 1 workaround | 2 comments | feedback id: 774098  | 
Closed
as By Design Help for as By Design
3
0
Sign in
to vote
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 20 weeks ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 773928  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
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 102 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 772495  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 22 Previous 123 Next