What Write Ahead Logging Is and Why It Matters
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2020-01-20
267 reads
Database Performance
Query Performance Diagnostics with sp_PerfSQ
This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.
2019-12-02
6,617 reads
2019-11-25
3,344 reads
Parameter pain
A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]
2019-11-11
4,476 reads
2019-10-28
5,337 reads
2019-06-10
976 reads
2019-05-24
Bad Guesses and Bad Choices: Better Living Through Indexes
Batch Cussidy In the last post, we looked at how S...
2019-05-24
Predicate Execution Order on Mixed Data Type Columns
Watch this week’s episode on YouTube. SQL Server...
2019-05-22
2019-05-22
Blogs
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st...
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having...
Forums
SMO Certificate Export - FailedOperationException
Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...
Resultset in a format
I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...
SQL Server data masking
Can you able to mask data in sql server 2012? If yes, would it...
Ask SSC