Name of the function: Get-LargestFile
The Input parameters are ServerName and Drive.
Function call
PS:\>Get-LargestFile HQDB001 E
In this case HQDB001[ServerName] and E[Drive]
****************************
Code:-
***********************
Function Get-LargestFile([String]$server,[char]$drive)
{
Get-ChildItem \\$server\$drive$...
2013-04-15
1,898 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
488 reads
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
653 reads
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
944 reads
To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You...
2013-04-15
29,018 reads
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...
2013-04-15
1,064 reads
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,497 reads
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
761 reads
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
706 reads
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,488 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers