Lots of ways to UNPIVOT a table
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...
2013-08-21
1,293 reads
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...
2013-08-21
1,293 reads
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...
2013-08-19
1,232 reads
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,244 reads
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,661 reads
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...
2013-08-16 (first published: 2013-08-07)
8,760 reads
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,350 reads
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,506 reads
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,344 reads
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
656 reads
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,589 reads
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
Comments posted to this topic are about the item Combining Silver Tables into a...
Comments posted to this topic are about the item Full Text Editions
Hello I need help on writing this query. This is what i need. I...
In which editions can I use Full-Text and semantic search?
See possible answers