PASS Update #65 (Officers, September Meeting)
I wanted to start with a follow up to my last post about the officer elections and the concerns about...
2011-09-20
704 reads
I wanted to start with a follow up to my last post about the officer elections and the concerns about...
2011-09-20
704 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
20,459 reads
Looks like it is that time again… for me to present a FREE webinar for good ol’ Pragmatic Works today...
2011-09-20
656 reads
I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes,...
2011-09-20
1,342 reads
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at...
2011-09-20
889 reads
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this...
2011-09-20
1 reads
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,093 reads
T-SQL Tuesday #22 is history, and I was pleased by the many posts and participants in this month’s September blog...
2011-09-20
3,641 reads
After having spent much time attempting to settle a point regarding my favourite pastime of provincial politics, it has come...
2011-09-20
1,589 reads
Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You...
2011-09-19
756 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers