Copying Dates into Excel
There’s often a need to quickly copy/paste a database query output into an Excel sheet, rather than exporting as a .csv file.
There’s often a need to quickly copy/paste a database query output into an Excel sheet, rather than exporting as a .csv file.
As a DBA, I’ve found Stack Exchange Data Explorer to be a really useful tool for exploring and analyzing the data from the Stack Exchange network of websites.
While looking at an old script today, one that kills SPIDs on a SQL Server database… I had an instant urge to try kill a system SPIDs, just to see what would happen.