By Lori Brown | Advice , Beginner , SQL Administration , SQL Maintenance , SQL Server
I am recycling this blog post from 2015….”Why?”, you might ask…..Well, I am still running into instances with this exact issue. Soooo, here we go….again. Enjoy. I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found […]
Continue readingBy Lisa Dominy | Advice , Cloud , Partners , SQL Server , SQLRX
Whether you currently host your SQL Server in the Cloud or are considering moving it to the cloud, here are a few guidelines that can lead you to select the right hosting provider for your specific requirements. Set the stage for a tech discussion. Familiarize yourself with your current technology profile so you can have […]
Continue readingBy Lori Brown | Advice , Beginner , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I recently ran into someone who swears that shrinking database files on a production server is a good thing and proudly said they did it on all systems they work on. OMG!! Let me post a quote directly from MSDN regarding weather or not shrinking database files causes fragmentation (https://msdn.microsoft.com/en-us/library/ms189493.aspx) […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , SQL Administration , SQL Server , SQLRX , Windows
-by Ginger Keys We are going to re-promote this subject because it is still so relevant. All too often we run into people who are in a panic after looking at Task Manager to try to diagnose SQL stress. They seem to become very worried when looking at how much memory SQL uses not realizing […]
Continue readingBy SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade
In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]
Continue readingBy SQLRx Admin | Advice , Miscellaneous , Offer , SQL Server , SQLRX
For those of you who visit our humble blog from time to time and have never actually checked out our website (www.sqlrx.com) to get acquainted with what we do, please allow me to check that box for you. SQLRX is part of a Dallas, Texas based consulting company called Integrated Services Inc (ISI). The SQLRX […]
Continue readingBy SQLRx Admin | Advice , Beginner , Miscellaneous , SQL Administration , SQL Server , Tip of the Month
If you have Full Text catalogs set up in your databases you may notice that inside your log folder there will be lots of files named SQLFTxxxxxxxxxxxx.LOG. These are known as crawl logs which are designed to log information on the full text indexing. These logs can really pile up and there is no automated […]
Continue readingBy Jeffry Schwartz | Advice , Intermediate , Performance Tuning , SQL Development , SQL Server
-by Jeffry Schwartz Queries with multiple join clauses create particularly difficult issues when they perform poorly. Join ordering is extremely important because if a join creates a huge interim result set at the beginning of the query execution, SQL Server must continue to handle this result set until it can be trimmed down with filtering […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , Perfmon , SQL Administration , SQL Server
–by Ginger Keys Recently, a client of mine contacted me in a panic because CPU was running at 99-100% over an extended period of time, which was affecting everything on the machine. We’ve all seen it at one time or another. And there are several reasons this could be happening. It could be SQL consuming […]
Continue reading