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

1
0
Sign in
to vote
From Connection: SQL Server
When the Deploy Database to Windows Azure SQL Database utility was released with SQL Server 2014 SSMS, there were two tiers of Azure service. Business and Web were the tiers. Now Azure has three servi…
Created on 10/16/2014 (updated 2 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1003131  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The June 2013 build of SSDT will not show trigger differences when trigger is the only object type selected for a schema comparison.
Created on 7/3/2013 (updated 63 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 792484  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
SET FIPS_FLAGGER is not flagging certain non-ANSI statements. Additionally, SET FIPS_FLAGGER 'FULL' is flagging less than SET FIPS_FLAGGER 'INTERMEDIATE'.
Created on 5/28/2013 (updated 2 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 788759  | 
Closed
as Won't Fix Help for as Won't Fix
3
0
Sign in
to vote
From Connection: SQL Server
If you use DEFAULT CURRENT_TIMESTAMP when creating a table, when you use SSMS to script the table, the script contains the non-ANSI getdate() instead of the ANSI CURRENT_TIMESTAMP. If I go to the tro…
Created on 3/13/2013 (updated 2 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 781321  | 
Closed
as Won't Fix Help for as Won't Fix
2
1
Sign in
to vote
From Connection: SQL Server
Books Online incorrectly states that CURRENT_TIMESTAMP "Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offse…
Created on 2/12/2013 (updated 87 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 779097  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
http://msdn.microsoft.com/en-us/library/ms188917.aspx says "To reduce the extent fragmentation of a heap, create a clustered index on the table and then drop the index." Paul Randal says "Myth #29:…
Created on 8/18/2010 (updated 190 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 587255  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
Using SSMS 2008 R2 pointing to a SQL Server 2008 database, the DDL event RENAME has red squigglies with a mouseover message of 'RENAME' is an invalid event type.
Created on 7/22/2010 (updated 169 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 577391  | 
Closed
as Fixed Help for as Fixed
4
7
Sign in
to vote
From Connection: SQL Server
It is by design (we all understand this) that the following three properties are not restored after a database restore: is_broker_enabled is_honor_broker_priority_on is_trustworthy_on Again,…
Created on 4/15/2010 (updated 88 weeks ago) | 0 validations | 0 workarounds | 5 comments | feedback id: 551695  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
sys.sysobjects BOL is incomplete - by John Paul Cook
From Connection: SQL Server
BOL for sys.sysobjects is incomplete. The following types are not documented: IT SN SQ
Created on 8/12/2009 (updated 269 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 482604  | 
Closed
as Fixed Help for as Fixed
0
0
Sign in
to vote
From Connection: SQL Server
There is a trivial inconsistency between the comment line and the ENABLERANU setting. Here is the relevant snippet: ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="True"
Created on 8/15/2008 (updated 265 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 362006  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 25 Previous 123 Next