Author Archives: thomasrushton

SQL Server Installation Failed Due to Pending Restart of Server?

Incidentally, the sort of problem I’m discussing here is why I (almost) always copy the patch/servicepack/media to somewhere local – each time you run a servicepack or cumulative update, the whole package decompresses to your hard drive, runs, and then … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Skype for Business – SQL Server Frustrations

Scenario The environment is new and secure. Assumptions: You are a DBA who knows how to build WSFCs and AGs. If you need help with that, then you’re in the wrong place for this post. The Windows 2016 / SQL … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

What A Difference An Index Makes

M’colleagues over the way were having problems with an upgrade / feature installation of McAfee EPO UDLP (no, I have no idea what that means). Looking at what was happening on the SQL Server that’s at the back of that … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Database Migration / Upgrade problem – Fulltext Wordbreaker, filter, or protocol handler does not exist

Long title. Sorry about that. What? I was migrating a few databases to a slightly upgraded server – new hardware, same OS/SQL main version, but the new one was fully service packed / updated etc. The environment dictated that I … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | 1 Comment

SQL Server Non-Unique Clustered Indexes Are Evil!

Non-Unique Clustered Indexes Are Evil And We Have The Proof. You won’t believe it when you see it. Face it – I can’t write click-bait… I was reading Grant Fritchey’s (Blog|@gfritchey) comments in the SQL Server Central forum thread “Advice … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 2 Comments

Windows 2012 R2 KB2883200 / KB2919355

In case you ever get round to trying to install vNext (or SQL2016SP1) on a Windows 2012R2 server, you may encounter some problems with missing updates. At least, I did, while following these steps: Create new Windows 2012 R2 VM … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Setting SQL Server Maximum Memory

One of the dafter defaults in SQL Server is the Maximum Server Memory (MB) – set to a value of 2147483647. Who has a server with 2PB RAM? Give me a call if you do – I want to have … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments