Tag Archives: microsoft sql server
-
T-SQL Formatters
3August 6, 2018 by Kenneth Fisher
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, …
Continue reading -
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
2July 18, 2018 by Kenneth Fisher
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
Continue reading -
Counting NULLs
4July 16, 2018 by Kenneth Fisher
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
Continue reading -
SQL Puzzle – FizzBuzz3d
18June 27, 2018 by Kenneth Fisher
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case …
Continue reading -
Be our guest, be our guest, put our database to the test.
3June 25, 2018 by Kenneth Fisher
When I think of the public role I often think of the guest database principal (user) at the same time. …
Continue reading -
The identity column, the insert and the linked server.
4June 14, 2018 by Kenneth Fisher
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
Continue reading -
What queries are getting blocked?
Leave a commentJune 6, 2018 by Kenneth Fisher
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how …
Continue reading -
What are the system databases?
5May 21, 2018 by Kenneth Fisher
I get to help with technical interviews every now and again, and one of the questions we always ask is …
Continue reading -
The trials and tribulations of REVERTing from impersonation
1May 16, 2018 by Kenneth Fisher
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
Continue reading
