Capture Linux Drive Space data with Powershell
Capture Linux Drive Space data with Powershell using Posh-SSH module
2016-07-19 (first published: 2016-07-06)
1,296 reads
Capture Linux Drive Space data with Powershell using Posh-SSH module
2016-07-19 (first published: 2016-07-06)
1,296 reads
2016-07-18 (first published: 2016-06-28)
671 reads
Query the earliest and latest date values found in all datetime columns in the current database.
2016-07-12 (first published: 2016-06-21)
3,415 reads
2016-07-05 (first published: 2016-05-26)
4,964 reads
2016-07-04 (first published: 2016-06-08)
922 reads
2016-07-01 (first published: 2016-05-24)
699 reads
If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2016-06-30 (first published: 2016-05-20)
1,611 reads
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
826 reads
Function for Getting Interval Dates by days,months,years for particular week number, for particular month, for particular date between 1 to 31. etc...
All in One Date Interval Related Function.
2016-06-27 (first published: 2015-11-27)
1,984 reads
If you have a requirement to send email to recipients with attachment, can use the script.
2016-06-24 (first published: 2016-05-17)
3,192 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers