Tag Archives for " SQL Help "

SQL Server 2016 RTM Available!!

By 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 reading

How SQLRX Can Help You When Tools Do Not

By 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 reading

Database Mail Error – SQL Server

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

–By Ginger Keys Database Mail is a feature of SQL Server that sends email from the SQL Server database engine to SMTP servers. It can be used to notify administrators when events happen in SQL server, such as job failures, failover notifications, or any other event deemed important in your environment. You can also use […]

Continue reading

March 2016 Tip of the Month -Full Text Indexing – Clean up those log files!

By 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 reading

Using Ranking Functions to Partition and Order Unfamiliar Data

By Jeffry Schwartz | Expert , Miscellaneous , SQL Development , SQL Server , Windows

The Problem How many times have you had to subdivide, group, rank, and organize data when you knew very little about the data itself except for the meanings of the columns? This dilemma is one that the members of the SQLRx team encounter frequently. When a customer requests help with a performance problem, we often […]

Continue reading

Jan 2016 Tip of the Month: sys.dm_server_memory_dumps

By SQLRx Admin | Intermediate , SQL Server , Tip of the Month

January 2016 Tip of the Month:  Using sys.dm_server_memory_dumps to find SQL memory dumps. When SQL experiences a serious issue it will often dump the contents of its memory to disk. This is known as a memory dump and it does generate files that are usually located in the Logs folder. I often find that many […]

Continue reading

Repair Suspect Database – SQL Server

By Ginger Daniel | Expert , SQL Administration , SQL Server

– -by Ginger Keys Occasionally mistakes happen, things get deleted, or hardware fails. Your end users may be complaining that the application is not working or pulling up any data… or you may open SQL Management Studio and see that the database is simply unavailable. What happened!? I have encountered a situation where an inexperienced […]

Continue reading

Using Try-Catch for Error Handling

By Lori Brown | Intermediate , Miscellaneous , SQL Development , SQL Server

— By Lori Brown @SQLSupahStah While Try-Catch has been around since SQL 2005, you would be surprised at how infrequently applications and SQL programmers use this to handle errors. Since I also write my own maintenance and monitoring code and jobs that has to be deployed to my clients, I started making an effort to […]

Continue reading

Find and Remove Duplicate Records

By Ginger Daniel | Beginner , Miscellaneous , SQL Development , SQL Server

— by Ginger Keys Having duplicate records in a database is an age-old problem that almost every organization has to deal with. Duplicates can appear because of careless data input, merging records from old systems into new systems, uploading leads from purchased lists, and multiple other reasons. Identifying these duplicate records can also be tricky. […]

Continue reading