-
18 maj 2012 07:16 i SQL Server 2008, Level 300, Håkan Winther, bugs, sv, en
In SQL server 2008 (serivce pack3), we are trying to use merge to insert new records in a table and the source data doesn't contain any NULL values
-
14 maj 2012 19:13 i SQL Server 2012, Level 100, Steinar Andersen, sv, en
I am sure you have heard of the new SQL Server 2012 licensing model, out with CPU licensing and in with Core licensing. But did you know that all
-
11 maj 2012 06:19 i Level 200, Jan Nieminen, T-SQL, sv
Yesterday i stumbled on a behaviour that i hadn't thought about before. This time it was RAISERROR error that surprised me, or it was RAISERROR
-
10 maj 2012 08:47 i SQL Server allmänt, Level 200, SQL Server version, Jonas Bergström, sv, en
If you have configured Database Mail correct in the Management Studio wizard in SQL Server 2005 (yes, some still use that old but stable chump), with...
-
09 maj 2012 03:59 i Indexering, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 200, Göran Rönnbäck, Håkan Winther, sv
En av nyheterna när det gäller SQL Server 2012 är möjlighet till 15 000 partitioner. Veckans fråga till Håkan Winther handlar om just partitionering...
-
06 maj 2012 21:01 i T-SQL, Level 200, SQL Server säkerhet, Steinar Andersen, sv, en
I would like to share a little tip form Books Online, that I found the other day. Sometimes it is needed to find out what my permissions are. A good...
-
07 maj 2012 06:19 i Level 100, SQL Server allmänt, Göran Rönnbäck, sv
Ibland är WHERE inte alltid vad vi tänker på, nämligen i våra SQL-satser. Man kan ju också använda det för att söka efter filer. Det gör man i
-
06 maj 2012 20:41 i T-SQL, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 300, SQL Server performance, Steinar Andersen, sv, en
Recently I had an idea about trying to emulate some of the functionality of Resource Governor using options available in Microsoft SQL Server Standard...
-
04 maj 2012 10:22 i Jan Nieminen, Level 300, SQL Server best practices, sv
Att man skall köra CHECKDB på sina databaser regelbundet har väl de allra flesta koll på hoppas jag.Datat man lagrar i databaserna kan vara mer eller...
-
02 maj 2012 21:33 i Grant Fritchey, T-SQL, Level 400, SQL Server best practices, sv, en
In a recent discussion it was suggested to me that not only is dynamic T-SQL useful for things like catch-all queries or some really hard to solve