CPU Overcommitment and Its Impact on SQL Server Performance on VMware
In the early days of virtualization, the core focus of virtualization was primarily consolidation. You could achieve quite high consolidation...
2012-12-17
1,751 reads
Technobabble by Klee from @kleegeek
SQL Saturday #173 Washington DC wrap up
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
733 reads
Speaking at SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza
I am pleased to announce that I am speaking Thursday, December 6, at the SQLPASS Performance Virtual Chapter Winter 2012...
2012-11-30
1,301 reads
SQLIO Analyzer Latency Divide by Zero Issue Corrected
A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one...
2012-11-26
1,220 reads
Getting Nexus 7 Connected To Windows 7
Have trouble getting your new Nexus 7 connected to Windows so you can move some media files over?
Install the drivers...
2012-11-24
773 reads
Speaking at SQL Saturday #173 in Washington DC
I will be speaking at SQL Saturday #173 in Washington DC at the Microsoft MTC in Chevy Chase, MD, to speak on...
2012-11-16
803 reads
Advanced VMware certification study material reference
Gregg Robertson (b | t) has posted a fantastic page that contains a tremendous amount of information for those of you...
2012-11-15
696 reads
SQL PASS Summit 2012 Came and Went – and Changed My Life
I cannot believe how surreal this past SQL PASS Summit was for me. This was the second Summit I have...
2012-11-20 (first published: 2012-11-14)
1,944 reads
Speaking with Kevin Kline at SQL PASS Summit 2012
WOW! I’m absolutely honored to announce that I am speaking with theKevin Kline tomorrow at the SQL PASS Summit 2012....
2012-11-09
676 reads
SQLIO Analyzer now has test timestamps
Yesterday I finally got around to adding a much needed improvement to my SQLIO Analyzer tool. You now get a...
2012-11-01
1,493 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers