Primary Keys – why accept the defaults.
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-22
3,044 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-28
2,054 reads
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-20
1,930 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
Remove the Dynamic code from my SQL sproc
I have a stored procedure that was created to run dynamically. Other than me...
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Ask SSC