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

2
0
Sign in
to vote
From Connection: SQL Server
Object_ID supports quoted names such as in when utilized in the code below: if object_id('[dbaFLVS].[FLVSUpdate]') is null begin exec('create procedure [dbaFLVS].[FLVSUpdate] as ') end go …
Created on 8/11/2016 (updated 2 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3038016  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Reviewing "Like Predicates" sometimes leads to unpredictable Query Plans - Index Scans Versus Index Seeks Please read more here ... 1) Transact SQL – Optimize Like Clause via “is not null” https…
Created on 6/24/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2855591  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When one issues sp_create_plan_guide and have special characters such as periods in name, plans are created but with wrong names. It is possible easier to share steps through a Blog. Here is the pos…
Created on 5/19/2016 (updated 14 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2724821  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When one creates plan guides and later check the Query Plan, the actual database that the plan resides and targets is not listed. What is listed is the current database and so the value is context …
Created on 5/14/2016 (updated 15 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2705984  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Error Message Msg 2530, Level 16, State 1, Line 13 The index "INDX_DBA_USERNAME_RecordCreated" on table "CourseManagerUserLogCustom" is disabled. Blog : 1) https://danieladeniji.wordpress.com/2016/0…
Created on 3/2/2016 (updated 25 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2428659  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
EncryptByKey fails without indicating error through @error nor raising exception. Our Algorithm is AES_256 and we using symmetric Key. We successfully encrypt 7943, but failed without error indicati…
Created on 11/21/2015 (updated 39 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 2043252  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Unable to properly encrypt float data
Created on 10/14/2015 (updated 45 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1902555  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When we issued the query referenced below, we are getting a warning that states "Columns With No Statistics".
Created on 9/21/2015 (updated 48 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 1819754  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
When I ran sp_refreshSQLModule against a scaler function that does not reference database objects it fails with : Msg 15165, Level 16, State 1, Procedure sp_refreshsqlmodule_internal, Line 175…
Created on 5/17/2015 (updated 36 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 1341891  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
Please fix "SQL Server Data Tools for Visual Studio 2012" ISO Download links. Visited https://msdn.microsoft.com/en-us/jj650015 but unable to download any of the ISO files.
Created on 3/24/2015 (updated 67 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1201042  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 24 Previous 123 Next