Server Up-Time Information
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,446 reads
Scripts
Fix orphaned users after restoring database to another server.
Script reassigns database orphan users to the matching SQL Server logins.
2011-11-15 (first published: 2011-10-24)
2,570 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
689 reads
Database Files Physical Location
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
2011-11-11 (first published: 2011-09-27)
1,175 reads
Check if Constraint is enabled or disabled
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-10 (first published: 2011-10-12)
7,838 reads
Last month Name and Year in a SSRS expression
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
9,159 reads
Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,535 reads
Compare 2 datasets and output delta in one TSQL statement
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,316 reads
2011-11-03 (first published: 2011-10-21)
1,760 reads
2011-11-01 (first published: 2011-10-18)
2,558 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
ALAMAT KONTAK BCA KCP Krian Telp:08218154393
WA:08218154393 Jl. Kauman No.25, Magersari, Krian, Kec. Krian, Kabupaten Sidoarjo, Jawa Timur 61262
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers