Here’s a TSQL snippet that will give you the sizes of the indexes that the query optimiser isn’t using. Note that the NULL values are SINCE THE LAST RESTART. So if you just restarted your server then this is rather a waste of time.
Read More →Error while enabling windows feature: netfx3. – resolved
Something I have run into a few times now which is an annoying timewaster is the following error: You’ll get it on windows 2012 installations when installing SQL 2012(And probably lower versions) and it’s caused by dotnet 3.5not being enabled on the windows installation. It’s frustrating because it happens during the actual installation and is […]
Read More →TSQL to Send Email From a SQL Server With Attachment
There are about a billion different technologies used to connect remotely to SQL Servers and some are better than others. Some allow file transfer, some allow sharing clipboards and some don’t. Of course, better depends entirely on your perspective. In most cases those ‘inconvenient’ things are there for a reason – security. nonetheless it’s a […]
Read More →An Introduction to Always On Availability Groups
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of Always On Availability Groups.
Read More →Mirror, mirror….
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of SQL Server Mirroring.
Read More →An Introduction to SQL Clustering
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post talks about SQL Server Failover Clustering.
Read More →How to resolve “No Global Profile Is Configured” issue in SQL Server
All you need to know to resolve a “No global profile is configured. Specify a profile name in the @profile_name parameter” error is to know that when it’s talking about a global profile, SQL Server is referring to a default profile in database mail.
Read More →