Tag Archives: sql statements
-
Who’s using that database?
1March 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading -
Test your UPDATEs and DELETEs before you run them
15February 18, 2015 by Kenneth Fisher
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
Continue reading -
Except and Intersect
7January 19, 2015 by Kenneth Fisher
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in …
Continue reading -
Pagination in SQL Server
5January 15, 2015 by Kenneth Fisher
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL …
Continue reading -
Finding a common AD group for a set of users.
9December 29, 2014 by Kenneth Fisher
I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
Continue reading -
Do you want to build an Audit?
1December 29, 2014 by Kenneth Fisher
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
Continue reading -
INSERT INTO SELECT vs SELECT INTO
5December 3, 2014 by Kenneth Fisher
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and …
Continue reading -
Using a date or int column as the clustered index.
13December 1, 2014 by Kenneth Fisher
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
Continue reading -
You don’t really need ORDER BY do you?
8November 19, 2014 by Kenneth Fisher
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without …
Continue reading -
Using T-SQL to populate a Central Management Server
6November 17, 2014 by Kenneth Fisher
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
Continue reading
SQL Studies 