Category Archives: T-SQL
-
What version of SQL is SSMS scripting for?
Leave a commentMarch 25, 2019 by Kenneth Fisher
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
Continue reading -
Mixed feelings over the new truncation error
2March 20, 2019 by Kenneth Fisher
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
Continue reading -
Querying temp tables across a linked server.
2March 14, 2019 by Kenneth Fisher
And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
Continue reading -
Disabling and enabling triggers
1March 6, 2019 by Kenneth Fisher
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
Continue reading -
Identity in a SELECT
4December 19, 2018 by Kenneth Fisher
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
Continue reading -
Bulk insert and an identity column
1December 12, 2018 by Kenneth Fisher
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file …
Continue reading -
My backup script (where, how, how big, etc.)
4November 26, 2018 by Kenneth Fisher
A while back I wrote about how to find where your backups are. And I’ve also written about I use …
Continue reading -
SQL Homework – November 2018 – Constraints
2November 5, 2018 by Kenneth Fisher
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
Continue reading -
Highlighting sp_spaceused
Leave a commentOctober 15, 2018 by Kenneth Fisher
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
Continue reading -
Which is faster? IN (list) or IN (SELECT FROM Temp)
8October 11, 2018 by Kenneth Fisher
If you’ve done much with IN (list) then you’ve realized that it basically translates out to You’ve probably also realized …
Continue reading
