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.
A while back we wrote about how to configure Database Mail, as well as how to troubleshoot it. Today I'll show you another thing you can use Database Mail for, as well as share the template I normally use for generating simple html mails from SQL Server.
Database Mail enables you to send emails from your SQL Server, and from a DBA point of view, this can come in handy to be able to work proactively to avoid problems. Every question you can answer with a piece of t-sql, you can receive a notification about via email.
Every now and again i just need to create a simple SQL Server trace to see whats happening under the hood.
Every now and again i find myself starting up SQL Server profiler, using this to create a SQL server trace definition.
But all i often really want is a simple set of SQL commands to:
- Create a trace
- See trace status
- Stop/remove the trace
- Read the trace
So here goes!
