High-Performance Transact-SQL with Window Functions
Window functions are more intuitive and simpler in many cases than alternative SQL methods.
2013-12-02
8,459 reads
Kamil Moscicki
Blogs
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
This is one of those things that probably doesn’t happen all that often, but...
In Memory Table Indexes
Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s...
Forums
Trigger for only updating specific column
Hi, using Merge I can sync table A with Table B at ROW level....
SQL Server Licencing Question
This question is about SQL Server Licencing and licencing for Maximum Virtualisation. I'm curious...
Error converting data type varchar to float
All, I know this topic has been discussed numerous times and I tried all...
Ask SSC