A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.
2012-01-17
4,074 reads
Fabiano Amorim continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented and when, and explaining the concept of the 'Frame' in a window function, with plenty of examples.
2011-12-23
3,169 reads
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
2011-11-14
4,521 reads
You can create the procedure below in you master database and run this procedure from the database to which you want to grant permissions. Also, the default role name is Execute_StoredProcedure. You can pass in the role name as a parameter /* This procedure grants Execute permissions to all procedures on a database to the […]
2005-05-09
Remi, Will this work without a table/index scan?where datediff(d, Getdate(), date_column) = 0
2005-04-14
If I use a view inside a view, is it recomended and how will it affect the performance. I need this becasue I cant use an Order by clause in the inner view.
2005-04-12
Hi Kathi - this is exactly what I was looking for, thanks! Not sure how I missed it in BOL
2005-02-07
2005-01-13
This works for me. Declare @Names as varchar(8000) set @Names = 'SysObjects, SysIndexes' --this is in your stored proc : set @Names = ',' + Replace(@Names, ' ', '') + ',' Select Id, Name, XType from dbo.SysObjects where charindex (',' + Name + ',' , @Names, 1) > 0 Please note that this script assume […]
2005-01-11
2004-12-16
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers