(Greg Larsen) As a DBA one of the most important tasks you might be asked to do is to restore an application database. When a database becomes corrupted for some reason you need to be able to restore the data to the last know point in time when the database was in a consistent state. In order to
Tag: sql server
What’s New in SQL Server 2012 Reporting Services
(Scott Murray) SQL Server Reporting Service 2012 (SSRS) is now available. What are the main new features available in SSRS 2012?
Partitioning in SQL Server – Part 2
(Arshad Ali) When a table grows large or huge in size it becomes really difficult to load new data, remove old data, maintain indexes and queries involving this table, and runs extremely slow. In this situation, we can partition the table, which essentially breaks the table and its indexes into logi
SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
(Pinal Dave) A common question – I often get from Oracle/MySQL Professionals:
Risk Matrix Chart in SSRS
(Jason Thomas) Of recent, I have been getting mails from my readers whether I have forsaken Reporting Services for Analysis Services in my blog. I want to reassure all of you that this is not the case and that I will be equally focussing on both the technologies.
Interesting Observation – Declaring Table Variables impact on Tempdb
(Devi Prasad) Following was an intresting observation when creating table variables.
It’s Christmas: 3 Ways To Be Wise About Your Rowsize
(Thomas LaRock) Empty space. That’s what you have inside your database, I’m certain of it.
SQL Server 2012 Cluster with TempDB on Local Disk
(Dan Quinones) With the introduction of SQL Server 2012 Microsoft officially supports local disk TempDB in SQL Server cluster configurations. This tip will show you how to configure TempDB on a local disk when installing your SQL Server 2012 cluster. We will also discuss the benefits of using TempDB
Hypothetical Indexes on SQL Server
(Fabiano Amorim) Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.
SQL Server Performance Statistics Using a Server Side Trace
(Greg Robidoux) When troubleshooting a SQL Server performance problem, one of the tools to use is Profiler. This tool allows you to collect metrics on statements that are run on your SQL Server for analysis and troubleshooting. The problem with using Profiler is that it is a client tool and unless