(Tim Chapman) In this blog post I’ll take a look at what is actually stored in a non-clustered index and (re)introduce you to some tools that you can use for looking at the contents of a given data or index page.
Tag: sql server
DBCC CHECKDB scalability and performance benchmarking on SSDs
(Paul Randal) Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options and traceflags, and now I’m finally getting around to presenting the results. Make sure to also read the recent post where I talk abou
Defining Post Deployment Scripts in the SQL Server Data Tools
(Mike Bishop) Maybe I jumped the gun a bit, but I’ve started using SQL Server Data Tools (SSDT) in Visual Studio 2010. Since then I’ve become SSDT’s biggest fan. The tool is just so much easier to use than the old VS 2010 database projects. But unfortunately, for some reason, I can’t seem to get my
SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick
(Pinal Dave) I hardly get hard time to come up with the title of the blog post. This was one of the blog post even though simple, I believe I have not come up with appropriate title. Any way here is the question I received.
Altering Text Columns: Only a Metadata Change?
(Michael J. Swart) Say you want to change the type of a text column using the ALTER TABLE … ALTER COLUMN syntax. It is valuable to know how much work SQL Server will have to do to fulfill your request.
A Journey from OLTP to OLAP
(Franco Lopes) In this first Part of the series I will discuss the OLTP and OLAP and the transition from OLTP to OLAP in pursuit performance improvements as well as the benefits of the each technology.
How To Survive Any Database Disaster
(Thomas LaRock) Database disasters happen from time to time. I have a method that allows you and your business to survive any database disaster.
Use SQL Server and MBAM for BitLocker Recovery Passwords
(Jan De Clercq) Q: Can we store our BitLocker recovery passwords in a SQL Server database instead of in Active Directory?
Network Packet Size: to Fiddle With or Not to Fiddle With
(Robert Davis) A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data.
Where do I find the Performance Dashboard for SQL Server 2008?
(Norman Chan) I’ve downloaded and installed Performance Dashboard reports for SQL Server 2005 from Microsoft’s download site, but I can’t find Performance Dashboard for SQL Server 2008? How can I use this for SQL Server 2008 and 2008R2?