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

1
0
Sign in
to vote
From Connection: SQL Server
Consider the following script: CREATE TABLE dbo.x ( i INT IDENTITY(1,1) PRIMARY KEY, c1 BIT NOT NULL DEFAULT 1, c2 VARCHAR(MAX) ); GO CREATE NONCLUSTERED INDEX idx1 ON dbo.x(c1) INCLUDE (c2…
Created on 8/20/2014 (updated 10 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 951192  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The documentation for sys.dm_exec_query_profiles: http://msdn.microsoft.com/en-us/library/dn223301(v=sql.120).aspx Includes the column "lob_scan_count" - however my co-worker Brooke Philpott discove…
Created on 3/12/2014 (updated 2 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 832951  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
Just another in the long line of quirky or downright wrong behavior with all of the visual designers in SSMS. If you create a table using the table designer, and you choose an unwise column name, lik…
Created on 11/20/2013 (updated 2 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 809209  | 
Closed
as Won't Fix Help for as Won't Fix
10
0
Sign in
to vote
From Connection: SQL Server
If you create a clustered columnstore index on an empty table, then insert data, SET STATISTICS IO ON on any subsequent queries reports 0 logical reads until the delta store is compressed. This does…
Created on 9/5/2013 (updated 11 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 799804  | 
Active
6
0
Sign in
to vote
From Connection: SQL Server
I have complained in the past about SP1 setup showing confusing things about services and applications that might cause a restart to be required: https://connect.microsoft.com/SQLServer/feedback/deta…
Created on 12/12/2012 (updated 94 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 774111  | 
Closed
as Won't Fix Help for as Won't Fix
4
0
Sign in
to vote
From Connection: SQL Server
If I create the following table: CREATE TABLE dbo.foo(ID INT, CONSTRAINT foo_ID PRIMARY KEY(ID)); GO Then in Object Explorer, expand my table > indexes and right-click the constraint, choosing scrip…
Created on 11/29/2012 (updated 2 days ago) | 2 validations | 0 workarounds | 2 comments | feedback id: 772800  | 
Closed
12
0
Sign in
to vote
From Connection: SQL Server
We recently stumbled on a scenario where if a plan uses TOP and parallelism, with a low enough DOP, SET STATISTICS IO ON produces incorrect and unreliable information. Thanks to Steve Wright and Thoma…
Created on 10/12/2012 (updated 8 weeks ago) | 5 validations | 0 workarounds | 5 comments | feedback id: 767250  | 
Closed
as Fixed Help for as Fixed
6
0
Sign in
to vote
From Connection: SQL Server
In Management Studio 2012, attempting to modify a numbered procedure only yields the first numbered procedure, rather than all versions. Create the following numbered procedure: CREATE PROCEDURE dbo.…
Created on 9/22/2012 (updated 77 weeks ago) | 3 validations | 0 workarounds | 3 comments | feedback id: 764197  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
In Cumulative Updates 1, 2 and 3 for SQL Server 2012, the very first setup dialog ("Install a SQL Server 2012 update") has the following text: "Welcome to the SQL Server 2012 update. This installatio…
Created on 9/4/2012 (updated 110 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 761178  | 
Closed
as Duplicate Help for as Duplicate
6
0
Sign in
to vote
From Connection: SQL Server
When you write TRY_PARSE() in SSMS, you get little tooltips trying to help you. Except they don't really help you because the syntax they tell you to use is wrong. When you type TRY_PARSE( and move y…
Created on 8/25/2012 (updated 79 weeks ago) | 2 validations | 0 workarounds | 4 comments | feedback id: 759535  | 
Closed
Showing 1 - 10 of 378 Previous 123 Next