First day and last day of a week
This scripts calculates the first day and the last day of a given week
2015-11-10 (first published: 2015-10-12)
1,121 reads
Kamel AL GAZZAH
Make a list of all tables in all data bases with creation date
This scripts allows to store all tables names in all databases for the current server, it stores also the creation date, this script can be runned ins SQL Server 2000 or later
2012-07-02 (first published: 2012-06-25)
1,408 reads
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
how can i see the last 100 select statements that were run by any user
how can i see the last 100 select statements that were run by any...
Dynamically execute SSIS package.
I am trying to figure out how to dynamically execute SSIS package based on...
Metric CPU show 100% , but Query Performance Insight show only 60% same period
Hi, I am investigation DTU spike for period specific period of time In my...
Ask SSC