Find Largest Tables To Compress
In this post I’m gong to show some T-SQL that will show you the compression state of tables and how to quickly find objects that are worth compressing.
Last...
2013-04-16
7 reads
New SQL Server Cumulative Updates
Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...
2013-04-15
725 reads
Power Shell or Windows – Rebooting of servers local or remote computers
Rebooting of servers local or remote Using PowerShell and Windows
Powershell command
Start->Run->Powershell press enter
PS:\>RESTART-COMPUTER -COMPUTERNAME SERVER01, SERVER02,LOCALHOST
Windows Command
Start->Run->cmd press enter
c:\>shutdown /m...
2013-04-15
775 reads
The dangerous beauty of Bookmark Lookups
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...
2013-04-15
752 reads
Customizing SSMS–Results
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-04-15
1,385 reads
SQL – DBCC CLEANTABLE – DROP UNUSED COLUMNS
Drop those columns which are no more in use.
For example, After Upgrade from MOSS 2007 to SharePoint Server 2010, we have...
2013-04-15
1,300 reads
Free SQL Server 2012 Installation Guide
Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...
2013-04-15
359 reads
Microsoft GeoFlow new Excel 2013 add-in
Hi
Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...
2013-04-15
732 reads
PowerShell – Find Disk Drive Details of local or remote Server
Name of the Function : Get-DiskDriveDetails
Input Parameter : ServerName
Ouptut : Grid view, you can sort and force condition on specific output column
Function call...
2013-04-15
994 reads
PowerShell – Find top 10 Largest files of a local or remote Drive
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,895 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers