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
Kenneth Fisher
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
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
EXECUTE AS USER = ‘Somebody else’
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
sp_helptext
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
At Startup SSMS setting
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
keyword DEFAULT
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
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Is TemporalTable SysStartTime available before performing an insert/Update?
I want to align a Date column (datetime2(7)) with the same full resolution date...
multiple PAGELATCH_UP waits on data file
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
dynamic update to SP
Looking for suggestions\examples of how to update a SP that the table used changes...
Ask SSC