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
SQLStudies
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
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Tsql query to show currently running sql agent jobs
Hi All, Using Tsql query I want to know currently running sql agent jobs...
SQL Agent Job schedule
Hi All, Want to know what are the SQL Agent Jobs scheduled for today...
Need an alert for a sudden increase in data
Hi All, Today, all of a sudden the size of the data file (.mdf)...
Ask SSC