Tag Archives: Microsoft SQL Server
-
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.
Leave a commentJanuary 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
3January 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 -
DBA Myths: Is an identity column always unique, in order, and without gaps?
6November 20, 2019 by Kenneth Fisher
Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost …
Continue reading -
DBA Myths: The system sessions are the ones with a session_id 50 or less
Leave a commentNovember 18, 2019 by Kenneth Fisher
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be …
Continue reading
