Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
18 reads
Carolina Technology Conference: Presentation Materials
For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...
2014-10-06
808 reads
The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,964 reads
Thoughts on the Student to IT Pro Seminar
Miscellaneous notes as I think on this.
I’ve been reading through feedback from the students. Reading the raw feedback is interesting...
2014-10-06
771 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,202 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
773 reads
SQL Server Days 2014 – Slide deck
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
517 reads
Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment...
2014-10-06
960 reads
SQL Server MVP for a Sixth Year
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and...
2014-10-05
435 reads
The Only Constant Is Change
In March of this year, I celebrated 10 years at Magenic. I blogged about it and called out values and...
2014-10-05
486 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
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