Category: SQL Server

Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY

I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts: How does DBCC CHECKDB WITH ESTIMATEONLY work (Paul) DBCC CHECKDB WITH ESTIMATEONLY: Do you trust it? (Ana) DBCC… more »

SQL Server 2012 Tempdb File Size Change tracked with Extended Events

We are using SQL Server 2012 and the tempdb is growing so fast. How do I effectively find what’s causing my tempdb growing. Can I monitor the file size change with Extended Events to find out the ... more »

SQL Server Information

Only a short script to get informations about your SQL Server enviroment, like machine name, instance name, edition, version, level, cluster security, user mode, collation and login. I use it as a piece on my whole admin scripts. --> SQL… more »

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 4 (CTP4) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 4 (CTP4) Download: SQL Server 2012 SP1 CTP4 SQL Server 2012 SP1 CTP4 Express SQL Server 2012 SP1 CTP4 Feature Pack The SQL Server 2012 builds that were released after SQL… more »

Antivirus Software on SQL Server

It’s an old story, but still present - Why or why not installing antivirus software on a database server? First of all, I’ve been on both sides of the debate with respect, but I can only, only partially agree to install antivirus software on a database… more »

SQL Server 2012 - New and Modified Dynamic Management Views and Functions - DMVs

That's just about the limit. In Books Online for SQL Server 2012 (BOL) by reading What's New (Database Engine), I came around the topic Manageability Enhancements (Database Engine) and its paragraph New and Modified Dynamic Management Views and Function… more »

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »

Service Pack 2 (SP2) is available for SQL Server 2008 R2

SQL Server R2 Service Pack 2 (SP2 Build 10.50.4000.0) is available: http://www.microsoft.com/en-us/download/details.aspx?id=30437   List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2 http://support.microsoft.com/kb/2630458 I wish y… more »

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 3 (CTP3) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 3 (CTP3) Download: http://www.microsoft.com/en-us/download/details.aspx?id=30375   The SQL Server 2012 builds that were released after SQL Server 2012 was released: Downl… mehr »

Database Engine Service Startup Options in SQL Server 2012

Before SQL Server 2012, it was a difficult work to add a trace flag or a startup parameter other than the default startup parameters that SQL Server uses. And, by the way, how the paramater is added from SSCM - the registry keys may not be created corre… more »
1 2 3 4 5 6 7 8 9 10 11 ... 18 »