In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since SQL Server 2014, this estimation has been good! See the PS from Paul Randal’s blog for this information, here But…
I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but often – to remove the logins and jobs associated with these databases. I have created a script – without any cursors,…
This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string format with the EXECUTE (exec) command. Very easy, isn’t it? Ok, let’s GO! If I execute “select * from sys.databases” in SSMS,…
During my audits at customer places, it still happens very often to find SQL Server databases with page verification option configured to “none”. I always alert my customers on this configuration point because it can have an impact on the overall integrity of their databases. One of my customer told me that the integrity task of its maintenance will detect…
I have read a lot of SQL Server blog postings and articles in order to find the default data path. This post covers different SQL Server versions (SQL Server 2012, SQL Server 2014, SQL Server 2008, SQL Server 2005) and provides a generic script with different methods. Search with SERVERPROPERTY Since SQL Server 2012, we can use the parameter “InstanceDefaultDataPath”…
In many blogs or articles, we can read that it is recommended to recycle the error log to be sure that the size is not too big In the Best Practice Analyzer (BPA) for SQL Server, this is a rule. But what is a good size for the error log file? I have often heard “it depends”, but in my…
For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It’s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(”) SQL 2008 R2 SQL 2012 With this comparison, you can see that there are 19 new permissions in SQL Server 2012. To have a great…
A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the…
I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the…
This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server…
For this last day (
) of the TechEd 2012, I going to present the new certification cycle for dba who wants to be certified for SQL Server 2012. But before, let’s start with a brief introduction on Enterprise Information Management, also called EIM
Today it’s the real beginning of the TechEd with several sessions in parallel.
