Tag Archives: code language
-
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 the reason for the error “Subquery returned more than 1 value”
1January 7, 2015 by Kenneth Fisher
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
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 -
DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD
6December 11, 2014 by Kenneth Fisher
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
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 -
Putting sp_ at the beginning of your stored procedure.
1November 24, 2014 by Kenneth Fisher
Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
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 