Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SqlServerZest.com - SQL in simple style

Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling. You can follow him on Twitter @SqlServerZest

Archives: May 2013

SQL Server – Get the Default Data File and Log File Location using T-SQL Query

In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query as below: SELECT SERVERPROPERTY('INSTANCEDEFAULTDATAPATH') AS [Default_Data_path] ,SERVERPROPERTY('INSTANCEDEFAULTLOGPATH') AS [Default_log_path] GO Sample Output: These parameters INSTANCEDEFAULTDATAPATH & INSTANCEDEFAULTLOGPATH are new in SQL Server 2012 and are not documented yet. Usually undocumented…

Read more

1 comments, 206 reads

Posted in SqlServerZest.com - SQL in simple style on 23 May 2013

SQL Server – Does the SQL Agent Service Account Must be a SysAdmin?

As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server sysadmin fixed server role” However, in one of our environments (SQL 2012) I have seen, just a public fixed server role is good enough to start the SQL…

Read more

1 comments, 199 reads

Posted in SqlServerZest.com - SQL in simple style on 14 May 2013

SQL Server – How to Best Remove Extra TempDB Data Files and Log Files

One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today, on one of our servers, I noticed there are 13 data files with different sizes as shown in the below screenshot: My target here is to configure tempdb with…

Read more

7 comments, 163 reads

Posted in SqlServerZest.com - SQL in simple style on 6 May 2013