Tag Archives: best practices
-
Is it safe to grant Administer Bulk Operations?
4November 10, 2016 by Kenneth Fisher
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are …
Continue reading -
Too many indexes!
6October 13, 2016 by Kenneth Fisher
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
Continue reading -
RBAR vs Batch
10August 17, 2016 by Kenneth Fisher
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
Continue reading -
Re-Evaluating Best Practices
8May 18, 2016 by Kenneth Fisher
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me. …
Continue reading -
Best practice recommendations for writing Dynamic SQL
16June 12, 2013 by Kenneth Fisher
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
Continue reading
SQL Studies 