Tips for using indexes in SQL Server 2012 Keep your indexes as narrow as possible. Because each index takes disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Check that index you tried to create does not already...
SQL Server
DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2
DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2 This is the second article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. As we noted in Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1,the primary focus of this series will be an introduction to PowerPivot for...
10 Hidden Time Wasters That You Might Be Doing
10 Hidden Time Wasters That You Might Be Doing Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and managing our professional careers on a weekly...
Back to basics: Transact-SQL programming fundamentals – (Part 2)
Back to basics: Transact-SQL programming fundamentals – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL variables. In this part, you will learn about Transact-SQL control-of-flow language, including BEGIN…END, IF…ELSE, CATCH, WHILE, BREAK, CONTINUE, RETURN, and WAITFOR. Control-of-Flow Transact-SQL provides special...
Tips for designing SQL Server 2012 tables
Tips for designing SQL Server 2012 tables Try to reduce the number of columns in a table. The fewer the number of columns in a table, the less space the table will use, since more rows will fit on a single data page, and less I/O overhead will be required to access the table’s data. Use char/varchar columns instead of...
Recovery Is a Compliance Issue
Recovery Is a Compliance Issue By Craig S. Mullins When data professionals think about regulatory compliance we tend to consider only data in our production databases. After all, it’s this data that runs our business and must be protected. So, we work to implement database auditing to know who did what to which data when; or, we tackle database security...
Useful SQL Server 2012 trace flags
Useful SQL Server 2012 trace flags Introduction Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2012: – global trace...
Back to basics: Transact-SQL programming fundamentals – (Part 1)
Back to basics: Transact-SQL programming fundamentals – (Part 1) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learn how to use scripts and batches, and basics of Transact-SQL variables. SQL Server users use Transact-SQL programming to create sets of statements for ad hoc execution. The aim of the Transact-SQL programming is to carry...
SQL Server 2012 Profiler Optimization Tips
SQL Server 2012 Profiler Optimization Tips SQL Server 2012 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some tips to performance tune and optimize SQL...
Planning for Recovery
Planning for Recovery Author: Basit A. Farooq A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can continue to function in case of hardware failure, natural disaster, or other catastrophe. A backup server or a standby server (using Database Mirroring, AlwaysOn Failover Cluster Instances, AlwaysOn Failover Groups or Log Shipping...