SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,540 reads
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,540 reads
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging...
2012-08-14
969 reads
As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or...
2012-08-14
571 reads
It’s Not A Repeat
Speaking at the PASS Summit last year was one of the highlights of my career. I had...
2012-08-14
744 reads
I’ve been reading about wooden hand planes lately (as opposed to hand planes made of metal that plane wood) and...
2012-08-14
895 reads
Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...
2012-08-14
1,202 reads
My 2011 version of Live Writer didn’t seem to want to embed a Vimeo video, so I checked for an...
2012-08-14
536 reads
As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will...
2012-08-14
1,140 reads
I’m flying in on Sunday again this year, arriving in time for lunch, and looking forward to the luxury of...
2012-08-14
622 reads
Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...
2012-08-14
1,096 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers