Peter Larsson is a key player for performance written code. He can turn a 10 hour query into a 3 minute piece of code. Peter is also a SQL Server MVP since 2009.
He often hangs out at SQLTeam.com (27k+ posts) and other various sites where he helps all people understand SQL Server.
When not working, he takes care of a wife and 4 kids.
CREATE FUNCTION dbo.fnISOWEEK
WHEN nextYearStart <= theDate THEN 0
WHEN currYearStart <= theDate THEN (theDate - currYearStart) / 7
ELSE (theDate - prevYearStart) ...
During my tests to port several databases to SQL Azure, one of the recurring things that fails export is the Extended Properties. So I just wanted to remove them.
This is a simple wayh to list all Extended Properties and the corresponding delete statement.
SELECT 'EXEC ...
This week I was invited my Microsoft to give two presentations in Slovenia. My presentations went well and I had good energy and the audience was interacting with me.
When I had some time over from networking and partying, I attended a few other presentations. At least the ones who where held in ...
I have started a new article series at Simple Talk. It's all about the transition from procedural programming to declarative programming.
First article is found ...
DECLARE @Sample TABLE
x INT NOT NULL,
y INT NOT NULL
VALUES (3, 9),
;WITH cteSource(x, xAvg, y, yAvg, n)
SELECT 1E * ...