Lori Brown Archives - Page 5 of 9

Feb 16

Shrinking Database Files – Let’s Not And Say We Did

By 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) […]

Jan 26

SSISDB – Package Execution Time in Minutes and Average Execution Time

By Lori Brown | Expert , SQL 2016 , SQL Development , SQL Server , SSIS Catalog

–By Lori Brown @SQLSupahStah I have a client who has a lot of SSIS packages in the SSIS catalog that we are migrating to a new server. Of course there is lots of testing going on. So the question came up about how to more easily see package runtimes and comparing to the overall average […]

Jan 19

Find Currently Executing Jobs Running Longer Than 30 Day Average

By Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server

–By Lori Brown @SQLSupahStah I needed to update some of our long running job monitoring code to improve it from the version that we have right now. I like this version because it uses msdb.dbo.syssessions (https://msdn.microsoft.com/en-us/library/ms175016.aspx) to validate that a job is actually running. I also wanted to know the percent difference between the current […]

Jan 12

SQL 2016 SP1 USE HINT

By Lori Brown | Intermediate , Performance Tuning , SQL Development , SQL Server , Trace Flags

–By Lori Brown @SQLSupahStah After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. Here’s where you find info from Microsoft: https://msdn.microsoft.com/en-us/library/ms181714.aspx and here is a link for all of the bugs that are fixed in SP1: https://support.microsoft.com/en-us/kb/3182545 USE […]

Jan 05

Synchronize Logins on AlwaysOn Replicas

By Lori Brown | Helpful Scripts , Intermediate , Security , SQL Administration , SQL Server

–By Lori Brown @SQLSupahStah At one of my clients who has an AlwaysOn failover cluster, I noticed as I was checking up on things on the secondary replica that there were several fewer Windows and SQL logins on the secondary than on the primary. I really did not want to tediously compare the logins on […]

Dec 29

Script to De-Orphan SQL Logins

By Lori Brown | Intermediate , Security , SQL Administration , SQL Server , Upgrade

–By Lori Brown @SQLSupahStah I am working with a client who is migrating from SQL 2012 to SQL 2016. It just so happens that while they have just a few databases to move, they also have a ton of SQL logins that needed to be migrated. This is not an issue since I know to […]

Dec 22

SQL 2016 Service Pack 1 Released

By Lori Brown | SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah SQL 2016 SP1 has been released. I might be a little late to this announcement but thought I would at least give the download link and some highlights on things that are fixed in it. Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54276 Some of the highlights are: New CREATE OR ALTER that […]

Dec 09

Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade

— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Nov 17

List All Objects and Indexes in a Filegroup or Partition

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

— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]

« Previous 1 … 3 4 5 6 7 … 9 Next »

Tag Archives for " Lori Brown "