T-SQL to check Data and Log Files are on same drive or not
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
625 reads
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
625 reads
Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...
2014-01-10
680 reads
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...
2014-01-10
752 reads
Here’s a very quick post by request.I just had a request for searching the file system for files matching certain...
2014-01-08
1,651 reads
Useful links – I hope you might like it too..
http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos/
2014-01-08
613 reads
Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...
2014-01-06
2,146 reads
I got a request to monitor multiple services and send an email to intended recipients. This post explains how to...
2013-12-04
1,385 reads
This tool helps you get the disk space information on the computers of your choice. Either you can type the...
2013-12-03
863 reads
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,661 reads
PowerShell – Disk Space GUI Tool - Sharing a useful PowerShell GUI script to check disk drive usage along with a graph.
Copy and...
2013-10-24 (first published: 2013-10-14)
4,533 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers