Mikael Syska


Windows Server 2008 R2 takes forever to start up–60 minutes or so

So a few weeks ago I disabled Ipv6 from the Local Area Connection on my Windows Server 2008 R2. I wa…

Read this article

Adding users to a TFS Project from the server

I have a few servers running, but they are all external to me, as they are placed in a data center, so my own computer aren't joined to the domain.SS-Exchange: DC, ExchangeSS-SQL: SQLSS-IIS: IIS. FTP,…

Read this article

Moving a table to another filegroup

So, how does one move a table to another filegroup.Say I have the following table:CREATE TABLE [dbo].[Tests]( [TestID] [int] NOT NULL, [TestInt] [int] NOT NULL, [TestBigInt] [bigint] NOT…

Read this article

Find duplicate rows in MS SQL

So, the other day I was reading T-SQL: Why “It Depends” and in the comments section a guys suggested using the “PARTITION BY” in the OVER clause.I thought was the heck does that do … so i searched the…

Read this article