Tanken med denna blogg är att våra SQL server konsulter kan dela med sig av sina kunskaper när de stöter på roliga, svåra eller överraskande saker relaterade till SQL Server. På grund av att vi har en hel del besökare från andra delar av världen, är den mestadels på Engelska.
So, CTEs (Common Table Expressions) are fast and give you flexibility. This is a fact. (They operate in memory, which gives faster access and so on.)
Here is why, though, CTEs remind me a bit of a three-wheeler sports c…
Läs merHere is a very cryptic error message which managed to puzzle me a bit:
”The package failed to load due to error 0xC0010014 ”One or more error occurred. There should be more specific errors preceding this…
Läs merEvery time you run the DTA (database tuning advisor) the results are saved in the MSDB database. If you run it many times and save many sessions, your MSDB may grow too big.
The question is simple: is there an automated m…
Läs merMicrosoft has just released the Microsoft SQL Server 2008 R2 Feature Pack. It contains a lot of goodies well worth downloading.Most notably it contains Power Pivot, but also other interesting add-ons such as Micro…
Läs merEver thought you’d wanted to have all the last update statistics run date/time for a table of choice. Not just the index-based, but all statistics at once?
Läs merI got a question from the project when (and regarding 2005, if) the next servicepack is due for SQL Server versions 2005 and 2008.
Läs merCOPYRIGHT SQL Service | Strandbergsgatan 61, 112 51 Stockholm
Hemsida av webbdesigner på Grafix Studio
