Do you see tables taking up much more space than expected? And when looking at the table design and doing a little math numbers just don’t add up! I have seen issues so many times, where you have a simple little table with only a few thousand rows taking up GB’s of storage space. The case is more or less always the same, and that is what I’ll demonstrate in this blog post.
Vi har igennem et stykke tid ønsket at Geniiius CRM skulle have nyt layout der matcher geniiius.com og Geniiius Track.
In SQL Server Management Studio 2008 there is a small anoying issue when trying to copy a multi-line text from the result grid. The line breaks are gone!
This usually annoys me when I want to look at the query text from a query plan, or a logged stack trace from an application or something similar.
How can we go about that?
Continue Reading
The other day we blogged about query plan warnings. By executing a simple query, we could find a list of all plan_handles which contained some type of warning. By changing the text "Warnings" with "MissingIndexes", we can find the plans with missing indexes identified instead:
Geniiius CRM har efterhånden eksisteret i snart 2 år og kunderne strømmer fortat ind.
Systemet er et gratis CRM system (customer relationship management), hvor alt overflødigt er skåret væk.
Det betyder samtidigt at systemet er hurtigt at blive fortroligt med, og at dømme ud fra tallene er det noget kunderne kan lide.
Where did I put my Sales table?
Filegroups? What can I say! Sometimes I love them and sometimes I just hate them. In theory this should be quite simple and give you benefits – but in my years as a consultant, I have seen so many bad file group designs where the simplicity is traded in for an over complex layout that looks good on paper, but is a nightmare to maintain.
Another scenario that I often come across is misplaced tables and indexes. This happens a lot if the person that created the database layout is not responsible for creating objects afterwards, or if the end-users does not get the proper instructions on how to do things the right way. When this is the case, things can end up messy. I will show you how to query the Meta data, so that you can check if your data is placed in the right filegroup.
When did you last have a look at your plan cache?
One of the important things to be familiar with when tuning queries, is the query plan. When SQL Server is asked to execute a query, it needs a plan for how to do it.
Continue Reading
With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been added. Now the BACKUP command support “TO URL” when you specify a backup device. This gives you the option to use an Azure Storage account as destinations for your backups.
