Developers give DBA work, thank you!
This is a story from real life that explains one of the reasons why I love developers. At my current ... Läs mer »
This is a story from real life that explains one of the reasons why I love developers. At my current ... Läs mer »
Technology has changed a lot, and so have our expectations of it. What I mean by this is that with ... Läs mer »
"There are many roads you can take in the forest," my grandma would say. And by this she meant that ... Läs mer »
Grattis Sql Service! Det har varit ett år fyllt av produktivt arbete i SQL Server området. Förra helgen firade vi ... Läs mer »
Just want to drop a quick note about the importance of updating your SQL Server database statistics. At a client ... Läs mer »
Gotten tired of that SQL Server 2000 system tables map hanging on your consultant 3x3 meter cubicle wall? Well. Here ... Läs mer »
Jag når inte TFS objekten idag, då den servermiljön uppgraderas, där jag nu sitter som SQL Server konsult på ett ... Läs mer »
Recently, at a SQL Server conference, the parallelism topic was brought up. One of the participants in the conversation expressed ... Läs mer »
The Microsoft SQL server 2008 Service Pack 2 and Feature Pack updates are now ready for download on the Microsoft ... Läs mer »
Some 15 years ago, way before I even thought of data and all questions that come with it, I read ... Läs mer »
This week I have had a problem at a client, with a newly installed server with Windows 2003 R2 and SQL ... Läs mer »
Fragmentering av index uppstår vid INSERT, DELETE och UPDATE. Denna fragmentering påverkar prestandan negativt i SELECT satser, ju mer fragmentering ... Läs mer »
Here is the story: you wake up one morning, and as you read your email, you come across a SQL ... Läs mer »
Som SQL Server konsult måste man ibland använda andra verktyg än de strikt SQL Server relaterade, hur fel det än ... Läs mer »
I Enterprise versionerna av SQL server 2005 och SQL server 2008 så finns möjligheten att partitionera tabeller och index horisontellt. ... Läs mer »
User defined scalar valued function har funnits sedan SQL server 2000 och används, enligt våra SQL konsulter, väldigt ofta i databaser ... Läs mer »
Question: What is the performance difference between rebuilding indexes with parallelism set to 1 and parallelism set to 0? The ... Läs mer »
När du försöker köra ett SQL server Integration Services (SSIS) paket i Business Intellegence Studio (BIDS) på en dator med ... Läs mer »
I have many times recieved the question from various customers, why should I pay so much extra for Enterprise edition? ... Läs mer »
So, CTEs (Common Table Expressions) are fast and give you flexibility. This is a fact. (They operate in memory, which ... Läs mer »