Tag Archives: option

Suspect MSDB and no Backups

By | September 18, 2015

Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best option is to use a backup and restore the database. This way you don’t lose any of the jobs and other configurations that you may have set… Read More »

SSIS – Starter kit for the uninitiated – Web Service Task

By | August 4, 2015

Continuing from the last post, we now configure the web Service task. If you visit the web service link you will see the below screen “http://free-web-services.com/web-services/geo/location-info/” Click the Link for Airport Information, it will take you to the below screen where you can find the URL for the web service.   Click the URL to… Read More »

SSIS – Starter kit for the uninitiated – Foreachloop

By | August 4, 2015

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS… Read More »

ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task

By | July 21, 2015

A quick video comparing the performance of different ETL options when importing 2 million rows into a database. All tasks use the BULK Logged Options where possible. ETl method performance Have you seen this link on the ETL world record using SSIS? https://msdn.microsoft.com/en-us/library/dd537533.aspx Summary Method Time Bulk Insert 28 sec DFT OLEDB – 500 1:13… Read More »

SQL 2016- Activity monitor – Active Expensive Queries

By | July 13, 2015

Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests Plenty of new option popping up all over Management Studio get exploring.

The tempdb – why shrinking doesn’t always work

By | July 6, 2015

Recently I was working on performance issues for a client and one of the topics we were looking at was tempdb. There was some confusion about when tempdb is a problem so I figured I would write this quick post explaining the auto growth and shrink behavior of tempdb. Here is what I started with.… Read More »

Auto Update Statistics when does it occur

By | June 17, 2015

I was recently asked when does the actual Auto Update Stats trigger and while I know its during query compile I wasn’t exactly sure what the thresholds were so I did some RnD, the results are anyway well documented in the link in the references but I have still posted the results here because I… Read More »

TRACE FLAG 1118 – Proportional Filling and the tempdb

By | June 2, 2015

Often when conducting trainings I ask my participants not to take my word for it but try things out for themselves. I was asked a question about the TRACE FLAG 1118 during a recent training for SQL 2012 and wanted to bring attention to the discussion here. The participants had read in a blog that… Read More »