Tag Archives: Microsoft SQL Server
-
Set a variable and update a column at the same time.
11February 19, 2020 by Kenneth Fisher
The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked …
Continue reading -
SQL Homework – February 2020 – Write a blog post.
1February 3, 2020 by Kenneth Fisher
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what …
Continue reading -
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
Leave a commentJanuary 27, 2020 by Kenneth Fisher
If you read the title to this post and your first thought was That’s not SQL is it? then you …
Continue reading -
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
1January 22, 2020 by Kenneth Fisher
This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow …
Continue reading -
Help! My restore has finished but the database still has a status of recovering.
Leave a commentJanuary 8, 2020 by Kenneth Fisher
I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, …
Continue reading -
SQL Homework – January 2020 – Document, document, document
4January 1, 2020 by Kenneth Fisher
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s …
Continue reading -
What happens if I disable the clustered index?
1December 16, 2019 by Kenneth Fisher
You are probably already aware that you can disable an index. This can be handy when you have a large …
Continue reading -
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
7December 5, 2019 by Kenneth Fisher
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone …
Continue reading -
SQL Homework – December 2019 – The default trace and the system health session.
Leave a commentDecember 2, 2019 by Kenneth Fisher
I know this is the holiday season for many of us (which ones depend on your religion and nationality of …
Continue reading -
Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;
Leave a commentNovember 27, 2019 by Kenneth Fisher
One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of …
Continue reading
SQL Studies 