Comments by Daniel Jones

Daniel Jones 10-Jan-17 0:07am View

fl_st_id nonclustered located on PRIMARY

Daniel Jones 10-Jan-17 0:05am View

SELECT DISTINCT TOP (@SearchLimit) fl_st_id AS [Key],
LTRIM(RTRIM(fl_st_id))+' - '+ fl_st_name AS [Description] FROM FCLEGS WHERE fl_st_id like @SearchTer

Daniel Jones 21-Dec-16 23:24pm View

what if commercial products are the only solution for the particular situation

Daniel Jones 21-Dec-16 23:14pm View

All of this is absolutely terrible advice, and can only make a bad situation worse:

This database is online; there is no need to discard the log and force data distruction.

Daniel Jones 5-Aug-16 1:46am View

take a look at this link hope: https://documentation.play-sql.com/display/SQL/Matching+records+from+two+tables+-+the+JOIN

Daniel Jones 18-Jul-16 0:48am View

have you seen this: http://stackoverflow.com/questions/15220921/how-to-store-double-array-to-database-with-entity-framework-code-first-approac

Daniel Jones 13-Jul-16 1:06am View

i think the Windows task manager is little tedious to manage

Daniel Jones 7-Jul-16 1:58am View

Take a look at this link: http://stackoverflow.com/questions/1559770/send-values-from-one-form-to-another-form

Daniel Jones 2-Jul-16 0:08am View

Take a look on this thread: http://stackoverflow.com/questions/548475/efficient-way-to-implement-paging

Daniel Jones 1-Jul-16 1:05am View

take a look at these links
https://www.simple-talk.com/sql/performance/which-of-your-stored-procedures-are-using-the-most-resources/
http://blog.sqlauthority.com/2009/01/02/sql-server-2008-2005-find-longest-running-query-tsql/

Daniel Jones 29-Jun-16 0:59am View

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2b5c7b9c-1126-47f6-90b2-2dd9030b06c0/how-can-i-access-and-get-sql-server-data-from-javascript-webapp?forum=sqldataaccess

Daniel Jones 28-Jun-16 0:25am View

check out the following link: http://stackoverflow.com/questions/7952406/get-each-file-size-inside-a-folder-using-sql

Daniel Jones 27-Jun-16 0:13am View

Right click on SQL > proprieties > security > select SQL server and windows authentication mode

Daniel Jones 21-Jun-16 9:25am View

I am new in this forum, so I don't have much knowledge about it. I found this thread on the first page of the SQL question category, so I answered it and I think this answer of this question is not accepted yet

Comments by Daniel Jones (Top 14 by date)