SQL Server : Part 10: Importance of Key Column Position While Creating Index
Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...
2013-04-22 (first published: 2013-04-16)
6,633 reads
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Here I share a free and easy way for you to get valuable insight into the...
2013-04-16
177 reads
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...
2013-04-16
2,494 reads
SQL Server 2012 Diagnostic Information Queries (April 2013)
Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-04-16
946 reads
Cumulative Updates - SQL Server 2012 RTM CU7
A 7th Cumulative Update is available for those users still on the RTM branch of SQL Server 2012. This is in keeping with Microsoft’s Incremental Service Modelling.
http://support.microsoft.com/kb/2823247You may have...
2013-04-16
15 reads
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
10 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
726 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
776 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,388 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers