2016-10-28 (first published: 2016-10-05)
23,117 reads
Scripts
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
848 reads
Extracting only Deadlock details from ErrorLog
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,956 reads
2016-10-21 (first published: 2015-05-12)
2,443 reads
2016-10-20 (first published: 2015-05-15)
1,683 reads
Calculate two internships
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2016-10-19 (first published: 2016-10-03)
537 reads
Copy Backup Files to Remote Shared Location and Delete them periodically
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
2,136 reads
2016-10-17 (first published: 2016-10-03)
903 reads
Recompile All Databases stored Procedures
When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
4,458 reads
Expand Template with Values from Result Set
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
396 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Temanggung Hub/Wa. 0817-819-444
Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa Tengah 56200
Alamat Telp BCA KCP Kutoarjo Hub/Wa. 0817-819-444
Jl. Pangeran Diponegoro No.120, RT.002/RW.010, Serdo Barat, Kutoarjo, Kec. Kutoarjo, Kabupaten Purworejo, Jawa Tengah...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers