Windows Tip - PAE - did you know that.....
Everyone remembers that in 32-bit windows architecture, in order for SQL Server (2005) to address more than 4GB of memory, one...
2009-09-21
908 reads
One Too Many Plates Spinning
I’ve written here and there about my attempts at time management and the idea that as you spin more and...
2009-09-21
612 reads
My next republished article is now available
Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com. This article compares two methods...
2009-09-21
1,289 reads
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-21
1,248 reads
Identifying Frequently Running Queries
It’s not enough to look at the longest running query. What if you have two queries, one runs for 5...
2009-09-21
988 reads
South Florida Code Camp Announced for 2010
Just received a note from Dave Noderer that the 2010 South Fla Code Camp will be February 13th in Mirarmar,...
2009-09-21
536 reads
Random Thoughts for Monday..
Hi, all! Hope everyone had a great weekend!
I was preparing my Blog for today on a subject I believe...
2009-09-21
485 reads
Built In Alerts
The more I think about this, the more I think it should be built into SQL Server as a default....
2009-09-21
940 reads
TSQLScripts.com – Script of the Week
After about 3 weeks of digging through .css files and html code I finally found the problem with the site. ...
2009-09-21
517 reads
Upcoming SQL Lunch (Live Meeting) – Historical DMV Information
The next SQL Lunch is scheduled for Monday, September 28. See below for details
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas...
2009-09-21
487 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