Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,165 reads
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,165 reads
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,347 reads
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
726 reads
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,102 reads
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...
2012-08-27
643 reads
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,327 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
I want to align a Date column (datetime2(7)) with the same full resolution date...
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
Looking for suggestions\examples of how to update a SP that the table used changes...