Lock Pages in Memory in SQL Server on VMware – Why or Why Not
Two weeks ago I presented my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” at the SQL PASS...
2013-11-12 (first published: 2013-11-04)
3,651 reads
Two weeks ago I presented my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” at the SQL PASS...
2013-11-12 (first published: 2013-11-04)
3,651 reads
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,205 reads
This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....
2013-10-28
808 reads
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
892 reads
I am proud to be selected to speak at this weekend’s first ever SQL Saturday in Charleston, SC. I am...
2013-10-11
566 reads
I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of...
2013-09-30
1,262 reads
The last couple of months have shown that the hypervisor battles for bigger, faster, and smoother are still heated and...
2013-10-02 (first published: 2013-09-26)
2,433 reads
Last month at VMworld, VMware announced the upcoming release of their virtualization suite, vSphere 5.5. As you all know, I...
2013-09-23
1,217 reads
This past weekend I presented a preview of my SQL PASS Summit spotlight session entitled “Squeezing Top Performance From Your...
2013-09-16
576 reads
September is a wild month for me! This Saturday, September 14th, I will be at Kansas City’s next SQL Saturday #191...
2013-09-12
730 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
This is my last week of the year working (I guess I come back...
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
I have a common problem that I just cannot figure out after scrolling through...
Hello, I am a new member here so forgive me if I am not...
I created a small procedure that reads the backup file and restores the DB...
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 ENDHow can I call this and invoke the default value for @two? See possible answers