-
10 mars 2013 i T-SQL, Level 200, SQL Server performance, Steinar Andersen, SQL Server, T-SQL, sv, en
Today I just wanted to have a little fun, while at the same time brushing off my T-SQL skills. As you know, prime numbershave many uses, for example...
-
05 december 2012 i T-SQL, Level 200, SQL Server allmänt, Steinar Andersen, SQL Server, T-SQL, sv, en
I have a proposal to enhance the T-SQL JOIN syntax, to simplify writing joins that use an existing PK/FK relationship. The examples in this post
-
09 oktober 2012 i T-SQL, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 200, SQL Server maintenance, Steinar Andersen, Verktyg, T-SQL, performance, sv
Ibland vill man veta vilka tabeller som tar upp utrymmet i en vissa databas, till exempel om du upplever ökad tillväxt eller helt enkelt vill ta reda...
-
18 september 2012 i T-SQL, SQL Server 2008R2, SQL Server 2012, Level 400, SQL Server maintenance, Steinar Andersen, T-SQL, sv, en
The other day I had reason to think about how to get more reliable statistics about the number of commands beeing replicated between SQL Servers. As...
-
14 september 2012 i Michael K Campbell, T-SQL, Level 400, SQL Server performance, transactions, T-SQL, performance, sv, en
SQL Service are happy to welcome Michael K Campbell as a guest blogger! Michael K Campbell (mike@sqlserveraudits.com and www.sqlserveraudits.com) is a...
-
30 augusti 2012 i T-SQL, Level 400, SQL Server maintenance, Steinar Andersen, SQL Server, T-SQL, sv, en
As you might already know, SQL Server stores the data in the databases in *.mdf and *.ndf files. And internally, these files are divided up into 8Kb...
-
22 augusti 2012 i T-SQL, Level 400, Steinar Andersen, T-SQL, sv, en
When investigation problems whit SQL Server, we often use commands like DBCC INPUTBUFFER, or tools like SQL Server Profile to view the various
-
17 april 2012 i Mikael Cedersved, T-SQL, Level 400, SQL Server maintenance, T-SQL, sv, en
About me My name is Mikael Cedersved, also (un)known as FrozenFishes. I’m a 26 year old DBA and BI developer from Sweden, working in the health care...
-
21 mars 2012 i T-SQL, Indexering, Joakim Nyström, Level 300, SQL Server performance, Verktyg, T-SQL, sv, en
Hi again and thank you for all replies! Now that you aquainted yourself with the missing index dmv:s, it is time to set the tools into proper work
-
16 mars 2012 i Mikael Cedersved, T-SQL, Level 300, SQL Server maintenance, T-SQL, sv, en
About me My name is Mikael Cedersved, also (un)known as FrozenFishes. I’m a 26 year old DBA and BI developer from Sweden, working in the health care...