2009-11-17
4,556 reads
2009-11-17
4,556 reads
Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method from MVP Jeff Moden.
2012-08-17 (first published: 2009-11-16)
57,531 reads
Returns the First or last day date of the month for a given date.
2009-12-01 (first published: 2009-11-11)
2,830 reads
2009-12-02 (first published: 2009-11-11)
728 reads
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
1,824 reads
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
2019-05-22 (first published: 2009-11-10)
43,833 reads
2009-11-09
4,712 reads
Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.
2009-11-09
11,248 reads
2009-11-17 (first published: 2009-11-06)
995 reads
That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.
2009-11-06
7,434 reads
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Another discussion in Gothenburg (such a great group of people) around Extended Events lead...
Let's be honest – SQL can be a bit of a beast. At first...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers