Category Archives: Microsoft SQL Server
-
Variables in Dynamic SQL
4November 16, 2017 by Kenneth Fisher
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
Continue reading -
It takes a village
1November 14, 2017 by Kenneth Fisher
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten …
Continue reading -
More Collation Confusion. (tempdb)
1November 8, 2017 by Kenneth Fisher
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
Continue reading -
DBA Definitions: FILLFACTOR
1November 6, 2017 by Kenneth Fisher
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
Continue reading -
SQL Homework Nov 2017: Create a view
3November 1, 2017 by Kenneth Fisher
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
Continue reading -
Schema only backup or schema only DB copy
Leave a commentOctober 25, 2017 by Kenneth Fisher
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
Continue reading -
When is it a good idea to consolidate multiple instances?
1October 23, 2017 by Kenneth Fisher
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
Continue reading -
Updateable CTEs
5October 18, 2017 by Kenneth Fisher
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t …
Continue reading -
Permissions required for developing with Temporal Tables
2October 16, 2017 by Kenneth Fisher
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table …
Continue reading -
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
2October 11, 2017 by Kenneth Fisher
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
Continue reading
SQL Studies 