Agus Wijiyanto

Slice your data queries in half Demystify complex relationships with SQL Server 2017 and graph source :  msft.it

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted cells in excel these are converted as 36464 => 1 / 11 / 1999 37104 => 1 / 08 / 2001 35412 => 13 / 12 / 1996 In SQL: SELECT DATEADD ( d , 36464 , '1899-12-30' ) -- or thanks to rcdmk SELECT CAST ( 36464 - 2 as SmallDateTime ) SELECT CONVERT (DATE, DATEADD(day, CONVERT(INT, 36464), '1899-12-30')) In SSIS, see here:  http://msdn.microsoft.com/en-us/library/ms141719.aspx Source :  https://stackoverflow.com/questions/13850605/convert-excel-date-serial-number-to-regular-date

Issue SQL Queries taking longer than normal to complete. Product Struxureware Power Monitoring Power Monitoring Expert ION Enterprise ION EEM Environment SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016 Cause When a database is frequently updated via INSERT, UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL Server query optimizer may chose a non-optimal execution plan when using an index to resolve a query. This will affect the overall query performance and you may notice a query behaving slower than normal. Resolution *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* The following is a simple query that will list every index on every table in your database, ordered by percentage of index fragme...

If your Windows 10 is working slowly, and when you check your Task Manager and find that the System item is hogging much of your CPU (or Disk in some cases) usage, you’re not alone. Many Windows users are reporting this problem. No worries, it’s possible to fix.  * Right-click the System item and click Properties, you’ll see a new item called ntoskrnl.exe. What is ntoskrnl.exe? Ntoskrnl.exe, short for Windows NT operating system kernel, is a fundamental part of the system. Usually, when you see the uncommon usage of high CPU or memory, you should shut down the possible programs that are causing the problem. If this happens a lot, you should see if there is something wrong with certain application settings or file in your system.   How do I fix it? Here are 4 methods for you to try. You may not have to try them all; just work your way down until you find the one works for you. Read More >>>